| 失效链接处理 |
|
最�?j��ng)_��践：11G-RAC�?1G单实例物理DG配置参考v5.0 PDF 下蝲
本站整理下蝲�Q?/strong>
链接�Q?a target="_blank">https://pan.baidu.com/s/1Z3tFW4389PeAle-EDOASBw
提取码：0m5n
相关截图�Q?/strong>
主要内容�Q?/strong>
1、主库归�?�?RAC1 节点执行
sqlplus / as sysdba
alter system set log_archive_dest_1=’location=+DATA’;
exit
停库 immediate
srvctl stop database –d orcl –o immediate;
启动 RAC1 节点实例�?mount 模式
srvctl start database –d orcl –n rac1 –o mount
讄��� RAC1 节点数据�?archivelog
sqlplus / as sysdba
alter database archivelog;
alter databae open;
启动 RAC2 节点实例
srvctl start instance –d orcl –I orcl2 –o open
���认是否为归���开�?/div>
sqlplus / as sysdba
archive log list
2、主�?force logging 模式开�?在节�?RAC1 执行�Q�查看数据库的模式：
Select
LOG_MODE,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,GUARD_STATUS,FORCE_LOGGING
from v$database;
在节�?RAC1 上执行：
SQL> alter database force logging;
3、主库创�?standby redo log 文�g
��d�� RAC1 节点 sqlplus 执行查看现有日志�l�情�?/div>
col member format a50;
select a.thread#,a.group#,a.bytes/1024/1024,b.member from v$log a,v$logfile b where a.group#=b.group#;
每个 thread 都需要创建，standby redo log �?redo log 多一�l?大小相同
alter database add standby logfile thread 1 group 11 ('+DATA') size 50m;
alter database add standby logfile thread 1 group 12 ('+DATA') size 50m;
alter database add standby logfile thread 1 group 13 ('+DATA') size 50m;
alter database add standby logfile thread 2 group 14 ('+DATA') size 50m;
alter database add standby logfile thread 2 group 15 ('+DATA') size 50m;
alter database add standby logfile thread 2 group 16 ('+DATA') size 50m;
创徏完查看日志组
select group#,type,member from v$logfile order by 2;
|
苏公�|�安�?32061202001004�?/p>
