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