eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To: eygle
　　最近我在搞逻辑的standby，但是我发现当从库shutdown 后，主库居然无法切换日志了，执行了alter system swtich logfile后，就停在那里了，为什么呢？
下面是部分主库日志：
ARC1: Evaluating archive log 2 thread 1 sequence 569
ARC1: Unable to archive log 2 thread 1 sequence 569
 Log actively being archived by another process
ARC1: Evaluating archive log 2 thread 1 sequence 569
ARC1: Unable to archive log 2 thread 1 sequence 569
 Log actively being archived by another process
ARC1: Evaluating archive log 2 thread 1 sequence 569
ARC1: Unable to archive log 2 thread 1 sequence 569
 Log actively being archived by another process
ARC1: Evaluating archive log 2 thread 1 sequence 569
ARC1: Unable to archive log 2 thread 1 sequence 569
 Log actively being archived by another process
Thu Jul 28 14:38:38 2005
ARC0: Archive destination LOG_ARCHIVE_DEST_1: Previously completed
ARC0: Archiving not possible: No available destinations
ARC0: Failed to archive log 2 thread 1 sequence 569
Thu Jul 28 14:38:38 2005
Errors in file /T3/DEMO/ora/demodb/9.2.0/admin/DEMO_sun750/bdump/demo_arc0_18557.trc:
ORA-16014: log 2 sequence# 569 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/T3/DEMO/ora/demodata/log02a.dbf'
ORA-00312: online log 2 thread 1: '/T3/DEMO/ora/demodata/log02b.dbf'
ARC0: Evaluating archive log 2 thread 1 sequence 569
ARC0: Archive destination LOG_ARCHIVE_DEST_1: Previously completed
ARC0: Archiving not possible: No available destinations
ARC0: Failed to archive log 2 thread 1 sequence 569
Thu Jul 28 14:38:43 2005
Errors in file /T3/DEMO/ora/demodb/9.2.0/admin/DEMO_sun750/bdump/demo_arc0_18557.trc:
ORA-16014: log 2 sequence# 569 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/T3/DEMO/ora/demodata/log02a.dbf'
ORA-00312: online log 2 thread 1: '/T3/DEMO/ora/demodata/log02b.dbf'

From: Remen
2005.07.27 23:28