主库做了几次alter system switch logfile;

看主库的alert日志：

[oracle@rhel42 bdump]$ tail -f alert_orac.log
ARCH:
Tue Jul 12 22:27:14 2011
ORA-16038: log 2 sequence# 23 cannot be archived
ORA-12541: TNS:no listener
ORA-00312: online log 2 thread 1: '/u01/app/oradata/orac/redo02.log'
Tue Jul 12 22:27:14 2011
Errors in file /u01/app/admin/orac/bdump/orac_arc0_5024.trc:
ORA-16038: log 2 sequence# 23 cannot be archived
ORA-12541: TNS:no listener
ORA-00312: online log 2 thread 1: '/u01/app/oradata/orac/redo02.log'

后来在目的端lsnrctl start，主库的alert中马上就有了反映：

Tue Jul 12 22:31:23 2011
ARC1: Evaluating archive log 2 thread 1 sequence 23
ARC1: Archive destination LOG_ARCHIVE_DEST_1: Previously completed
ARC1: Beginning to archive log 2 thread 1 sequence 23
Creating archive destination LOG_ARCHIVE_DEST_2: 'STANDBY'
ARC1: Completed archiving log 2 thread 1 sequence 23
Archiver process freed from errors. No longer stopped
Tue Jul 12 22:31:24 2011
ARC0: Evaluating archive log 1 thread 1 sequence 24
ARC0: Beginning to archive log 1 thread 1 sequence 24
Creating archive destination LOG_ARCHIVE_DEST_2: 'STANDBY'
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/backup/1_24.dbf'
ARC0: Completed archiving log 1 thread 1 sequence 24[@more@]

ITPub博客

一次oracle 9i physical standby database 的监听未启动导致的主库日志传输不到目的端

最新文章