一次oracle 9i physical standby database 的監聽未啟動導致的主庫日誌傳輸不到目的端

msdnchina發表於2011-07-15

主庫做了幾次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部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1052501/,如需轉載,請註明出處,否則將追究法律責任。

相關文章