0
Oracle Database 12c 部署Data Guard(ADG、LDG)并实现Switchover和Failover(Rman Duplicate和Broker)
1070
41页
15次
墨值5
Oracle Database 12c
部署 Data Guard(ADG/LDG)
并实现 Switchover Failover
(结合 RMAN Duplicate Broker 技术)
By Luocs.Xu
Blog:http://www.luocs.com
2013 07 31
目录
1. ....................................................................................................................................................................... 4
2. 准备实验环境 ................................................................................................................................................... 4
2.1 查看 OS DB 版本信息 .................................................................................................................... 4
2.2 Primary Standby hosts 里添加主备库信息 ............................................................................. 4
2.3 Primary Standby 的环境变量 ........................................................................................................ 4
2.4 Primary 构造测试数据 ................................................................................................................... 5
3. 搭建 Active Data Guard .................................................................................................................................. 7
3.1 Primary 开启 FORCE LOGGING .................................................................................................... 7
3.2 添加 standby logfile ............................................................................................................................. 7
3.3 Primary 运行于归档模式 ............................................................................................................... 8
3.4 Primary 网络配置 ................................................................................................................................ 8
3.5 配置 Standby ...................................................................................................................................... 10
3.5.1 创建初始化参数和口令文件 ................................................................................................. 10
3.5.2 创建必要的目录 ..................................................................................................................... 10
3.5.3 配置 Standby 网络 ................................................................................................................. 10
3.5.4 启动监听 ................................................................................................................................. 11
3.5.5 Standby 实例启动到 NOMOUNT 状态 ............................................................................... 11
3.5.6 Primary 进行连接测试 ..................................................................................................... 12
3.6 编写脚本并执行 ................................................................................................................................. 12
3.6.1 编写 rman duplicate 命令脚本 ............................................................................................. 12
3.6.2 解锁 sysbackup 用户 .............................................................................................................. 12
3.6.3 口令文件重新复制到 Standby .............................................................................................. 14
3.6.4 执行脚本 ................................................................................................................................. 14
3.7 Primary 修改参数 .............................................................................................................................. 23
3.8 查看主备库状态信息 ......................................................................................................................... 23
4. 配置 Broker .................................................................................................................................................... 24
4.1 启用 Broker 功能并使用 ................................................................................................................... 24
4.1.1 启用 Broker 功能 ................................................................................................................... 24
4.1.2 Standby 库启动到 Read Only ............................................................................................... 24
4.1.3 主备库打开 PDB ............................................................................................................... 24
4.1.4 使用 Broker 创建主备库 ....................................................................................................... 24
4.1.5 查看主备库详细信息 ............................................................................................................. 25
4.1.6 ADG 实时应用测试 ............................................................................................................... 28
4.2 Data Guard 保护模式 ........................................................................................................................ 29
4.3 SWITCHOVER ................................................................................................................................. 30
4.3.1 进行 switchover ...................................................................................................................... 30
4.3.2 Switchover 之后进行确认 ..................................................................................................... 30
4.3.3 测试 ......................................................................................................................................... 31
4.4 Failover ............................................................................................................................................... 32
4.4.1 配置并启动 FSFO(FastStartFailover) ................................................................................. 32
4.4.2 开启 flashback db 功能.......................................................................................................... 33
4.4.3 启用 FSFO .............................................................................................................................. 33
4.4.4 进行故障转移 ......................................................................................................................... 35
5. 逻辑备用数据库 ............................................................................................................................................. 37
of 41
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部