关于data guard的问题
AIX4.3.3ORACLE9.2.0.4
首先将主库向备库归档禁用
命令 alter system set LOG_ARCHIVE_DEST_3='defer'
然后在备库将归档日志全部应用,关闭数据库,
然后冷拷贝一份数据(时间大约2小时),目录为 DBDR_B.原目录为DBDR
然后将原目录DBDR改名为DBDR_BAK,而将刚备份的DBDR_B改名为DBDR
然后将这个新的备用数据库重新启动到自管理模式
再将主库已经禁用选项恢复
命令 alter system set LOG_ARCHIVE_DEST_3='enable'
这是后,我发现在这2个多小时之内,主库产生的归档日志有8个,并且不断的传送到备库里,得以应用.
但是我检查主库时候发现主库在这段时间报错ORA-03113错误.
trace文件如下:
Destination LOG_ARCHIVE_DEST_3 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_3 is in MAXIMUM PERFORMANCE mode
Destination LOG_ARCHIVE_DEST_3 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_3 is in MAXIMUM PERFORMANCE mode
Destination LOG_ARCHIVE_DEST_3 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_3 is in MAXIMUM PERFORMANCE mode
.
.
.
.
Destination LOG_ARCHIVE_DEST_3 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_3 is in MAXIMUM PERFORMANCE mode
Destination LOG_ARCHIVE_DEST_3 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_3 is in MAXIMUM PERFORMANCE mode
Destination LOG_ARCHIVE_DEST_3 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_3 is in MAXIMUM PERFORMANCE mode
RFS network connection lost at host 'HAI_dbdr'
Error 3113 creating standby archive log file at host 'HAI_dbdr'
*** 2005-11-29 16:36:54.248
ARC0: Error 3113 Creating archive log file to 'HAI_dbdr'
*** 2005-11-29 16:36:54.248
kcrrfail: dest:3 err:3113 force:0
ORA-03113: end-of-file on communication channel
Standby database restarted; old mount ID 0x54dc0759 now 0x54fa3196
Destination LOG_ARCHIVE_DEST_3 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_3 is in MAXIMUM PERFORMANCE mode 我在从库这边先执行:alter database mount standby database;
然后执行:recover managed standby database;
再在主库执行:alter system archive log current;
主库归档到从库都很正常.
经过测试:主库对数据的操作,在从库都可以看到. 试试这样的命令
alter system set LOG_ARCHIVE_DEST_3='enable reopen'
页:
[1]