目录
1 要求................................................................................................................................................3
2 数据库环境.....................................................................................................................................3
2.1 数据库主机环境.................................................................................................................3
2.2 数据库备机环境.................................................................................................................4
3 数据库软件安装............................................................................................................................5
3.1 主机安装数据库软件和配置数据库(primary).............................................................5
3.2 备机安装数据库软件,但不配置数据库(standby) .....................................................5
4 Dataguard 配置...............................................................................................................................5
4.1 主机设置为归档模式(primary).....................................................................................5
4.2 主机设置必要的参数(primary).....................................................................................5
4.3 主机生成 pfile(primary).................................................................................................6
4.4 主机密码文件传到备机(primary 和 standby) .............................................................7
4.5 主机和备机配置 tnsnames.ora(primary 和 standby) ....................................................7
4.6 主机创建 standby log 文件(primary) ............................................................................7
4.7 备机启动数据库到 nomount 状态(standby).................................................................8
4.8 主机利用 rman 恢复 standby 数据库(primary)..................................................................8
4.9 备机应用日志(standby) .................................................................................................8
4.10 验证数据同步(primary 和 standby) ...........................................................................9
5 DataGuard 维护.............................................................................................................................9
5.1 备机停起和应用日志(standby) .....................................................................................9
5.2 DataGuard 管理的相关视图...............................................................................................9
5.3 维护 archivelog 文件........................................................................................................10
6 灾难恢复......................................................................................................................................10
6.1 主备切换(switchover)..................................................................................................10
6.1.1 主库变备库: ...........................................................................................................10
6.1.2 备库变主库: ...........................................................................................................11
6.2 灾难切换(falover) ........................................................................................................11