0
Oracle DataGuard安装运维规范(10G)
243
19页
26次
墨值5
1
Oracle DataGuard
安装运维规范
(10G)
2
!
!
1.
目的
......................................................................................................................................... 5
2.
范围
......................................................................................................................................... 5
3. DG
配置规范
............................................................................................................................ 5
3.1 DG 类型规范 .......................................................................................................................... 5
3.2 DG 保护模式规范 ................................................................................................................... 5
3.3 REDO LOG 传输配置规范 .......................................................................................................... 6
3.4 STANDBY LOG 规范 ..................................................................................................................... 6
3.5 命名规范 ................................................................................................................................ 6
3.6 延时规范 ................................................................................................................................ 7
3.6.1
目标端延迟 APPLY .................................................... 7
3.6.2
生产端尽快切换日志 .................................................. 7
4.
具体配置步骤
.......................................................................................................................... 7
4.1 配置主备库监听和 TNSNAME.ORA ............................................................................................ 7
4.2 传输密码文件 ........................................................................................................................ 8
4.3 修改 PRIMARY 端的配置 ........................................................................................................... 8
4.4 修改 STANDBY 端的配置 ........................................................................................................... 9
4.5 原库备份控制文件和 DATABASE ............................................................................................ 10
4.6 DUPLICATE 复制(可选) ............................................................................................................. 11
4.7 NBU 备份中恢复(可选) ..................................................................................................... 11
4.7.1
Standby 恢复 controlfile ............................................ 11
4.7.2
Restore 数据库 ..................................................... 12
4.7.3
Recover 数据库(可选) ............................................... 12
4.8 STANDBY 端执行角色 ......................................................................................................... 12
4.8.1
查看 standby 端状态: ............................................... 12
4.8.2
添加 standby 日志 ................................................... 13
4.8.3
执行应用语句 ....................................................... 13
of 19
最新上传
暂无内容,敬请期待...
下载排行榜
周榜月榜总榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部
暂无课程,敬请期待...