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
|