RAC+TO+RAC+FOR+DG.pdf
5墨值下载
Technical Architecture of 11g R2
RAC Primary to RAC Standby
DataGuard 配置指南
By Luocs.Xu
2012 年 09 月 05 日
目录
1. 技术架构和实验环境 ....................................................................................................................................... 3
1.1 技术架构 ............................................................................................................................................... 3
1.2 实验环境 ............................................................................................................................................... 3
2. 其他配置 ........................................................................................................................................................... 4
2.1 Primary Site ......................................................................................................................................... 4
2.2 DR Site .................................................................................................................................................. 4
2.3 etc/hosts 设置 ........................................................................................................................................ 4
3. 准备 Primary RAC Database ..................................................................................................................... 5
3.1 打开 Force Logging .............................................................................................................................. 5
3.2 创建 Standby Redo 日志(SLRs) ......................................................................................................... 5
3.3 修改参数 ............................................................................................................................................... 6
3.4 备份数据 ............................................................................................................................................... 8
3.5 创建 Standby 数据库的 Pfile .............................................................................................................. 8
3.6 更新 tnsnames.ora................................................................................................................................ 9
4. 准备 Standby RAC Database .................................................................................................................. 10
4.1 复制参数文件 ..................................................................................................................................... 10
4.2 复制密码文件 ..................................................................................................................................... 10
4.3 创建相关目录 ..................................................................................................................................... 11
4.4 修改参数文件 ..................................................................................................................................... 11
4.5 创建 ASM 路径 .................................................................................................................................. 12
5. 创建 Physical Standby Database .......................................................................................................... 12
5.1 使用修改好的参数 Standby 实例启动到 NOMOUNT 状态 .......................................................... 12
5.2 RMAN DUPLICATE 复制数据库 .................................................................................................... 12
5.3 修改 Primary 和 Standby 的 TNSNAMES.ORA ............................................................................ 25
5.4 启动 Managed Recovery Process ...................................................................................................... 27
5.5 创建 spfile 并使用 spfile 启动 RAC Database ................................................................................. 29
5.6 Standby Database 注册到 OCR 里................................................................................................... 30
5.7 启动 Active Dataguard. ..................................................................................................................... 30
6. 修改 DataGuard 保护模式 .......................................................................................................................... 31
6.1 最高可用性 MAXIMUM AVAILABILITY ..................................................................................... 31
6.2 最大保护 MAXIMUM PROTECTION ........................................................................................... 32
7. Primary 和 Standby 数据库切换 .............................................................................................................. 33
7.1 Switchover 到 Physical Standby Database ...................................................................................... 33
7.2 Failover 到 Physical Standby Database ........................................................................................... 40
8. Related Posts .............................................................................................................................................. 49
of 50
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论