dg rac to single 问题杂记

最新推荐文章于 2020-03-07 10:48:35 发布

congfen5646

最新推荐文章于 2020-03-07 10:48:35 发布

阅读量93

点赞数

备库：
select member from v$logfile;
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/oracle/oradata/alone/group_2.275.727831277
+DGB/orcl/onlinelog/group_2.263.727831281
/u01/oracle/oradata/alone/group_1.274.727831267
+DGB/orcl/onlinelog/group_1.264.727831271
/u01/oracle/oradata/alone/group_3.279.727831743
+DGB/orcl/onlinelog/group_3.262.727831749
/u01/oracle/oradata/alone/group_4.280.727831759
--日志文件的convert存在异常
这个东东困扰了好一阵子
后来才发现细节决定成败啊。。
主库：
+DGA/orcl/onlinelog/group_2.275.727831277
+DGB/orcl/onlinelog/group_2.263.727831281
+DGA/orcl/onlinelog/group_1.274.727831267
+DGB/orcl/onlinelog/group_1.264.727831271
+DGA/orcl/onlinelog/group_3.279.727831743
+DGB/orcl/onlinelog/group_3.262.727831749
+DGA/orcl/onlinelog/group_4.280.727831759
+DGB/orcl/onlinelog/group_4.265.727831767
修改备库的log_file_name_convert重新复制一次即可
结果：
--------------------------------------------------------------------------------
/u01/oracle/oradata/alone/group_2.275.727831277
/u01/oracle/oradata/alone/group_2.263.727831281
/u01/oracle/oradata/alone/group_1.274.727831267
/u01/oracle/oradata/alone/group_1.264.727831271
/u01/oracle/oradata/alone/group_3.279.727831743
/u01/oracle/oradata/alone/group_3.262.727831749
/u01/oracle/oradata/alone/group_4.280.727831759
/u01/oracle/oradata/alone/group_4.265.727831767

之前有看到日志文件报错现在没有了：
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+DGB/orcl/onlinelog/group_1.264.727831271'
ORA-17503: ksfdopn:2 Failed to open file +DGB/orcl/onlinelog/group_1.264.727831271
ORA-15001: diskgroup "DGB" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/alone/group_1.274.727831267'
ORA-27037: unable to obtain file status
查过提示说：第一次置于recover状态的时候，备库会生成对应的online redo log
recover managed standby database disconnect from session;
说明启动recover后对无法标识的日志做强制清理转换操作
日志：
ALTER DATABASE RECOVER managed standby database disconnect from session
Tue Aug 31 00:14:36 2010
Attempt to start background Managed Standby Recovery process (alone)
Tue Aug 31 00:14:37 2010
MRP0: Background Managed Standby Recovery process started (alone)
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u01/oracle/oradata/alone/group_1.274.727831267
Clearing online log 1 of thread 1 sequence number 76
Clearing online redo logfile 2 /u01/oracle/oradata/alone/group_2.275.727831277
Clearing online log 2 of thread 1 sequence number 75
Clearing online redo logfile 3 /u01/oracle/oradata/alone/group_3.279.727831743
Clearing online log 3 of thread 2 sequence number 79
Clearing online redo logfile 4 /u01/oracle/oradata/alone/group_4.280.727831759
Clearing online log 4 of thread 2 sequence number 80
logfile则变成：
/u01/oracle/oradata/alone/group_2.275.727831277
/u01/oracle/admin/alone/archivelog/ALONE/onlinelog/o1_mf_2_67qp82xz_.log
/u01/oracle/oradata/alone/group_1.274.727831267
/u01/oracle/admin/alone/archivelog/ALONE/onlinelog/o1_mf_1_67qp7sbq_.log
/u01/oracle/oradata/alone/group_3.279.727831743
/u01/oracle/admin/alone/archivelog/ALONE/onlinelog/o1_mf_3_67qp8ddq_.log
/u01/oracle/oradata/alone/group_4.280.727831759