目录
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
文档被以下合辑收录
评论