一次oracle 9i physical standby database 的監聽未啟動導致的主庫日誌傳輸不到目的端
主庫做了幾次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 2011ARC1: 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 9i physical standby database 的源端正常傳輸歸檔日誌到目的端的條件OracleDatabase
- Oracle監聽日誌過大導致的問題Oracle
- Physical Standby上開啟flashback database實驗日誌Database
- oracle 9i physical standby database 上的v$archived_logOracleDatabaseHive
- oracle 9i physical standby database狀態查詢OracleDatabase
- oracle 9i physical standby database 中v$database switchover_status的含義OracleDatabase
- Oracle監聽日誌2g-監聽啟動報錯Oracle
- 配置oracle 9i physical standby database時,duplicate命令的執行記錄OracleDatabase
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- ORACLE的歸檔空間滿導致的監聽故障資料庫無法啟動Oracle資料庫
- 監聽狀態對dataguard及其日誌傳輸的影響
- oracle清理監聽日誌Oracle
- Oracle10G Physical Standby Database setupOracleDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- oracle實驗記錄 (physical standby 日誌應用方面)Oracle
- DG 日誌傳輸監控
- Sybase資料庫日誌過大導致不能啟動(轉)資料庫
- Oracle11g的Dataguard測試,建立物理備庫(Physical Standby Database)OracleDatabase
- Oracle 監聽器日誌解析Oracle
- 【DataGuard】Oracle DataGuard 日誌傳輸狀態監控Oracle
- Physical Standby Database 切換到 Snapshot Standby DatabaseDatabase
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase
- oracle 10g physical standby database creationOracle 10gDatabase
- ORACLE10G DG配置下Physical Standby Database的管理OracleDatabase
- 配置Oracle11g的Dataguard測試,建立物理備庫(Physical Standby Database)OracleDatabase
- 刪除oracle 11g的警告日誌和監聽日誌Oracle
- Oracle 監聽器日誌解析(續)Oracle
- Oracle之外部表監聽日誌Oracle
- ORACLE停止監聽日誌檔案Oracle
- 關閉監聽的日誌。
- oracle資料庫監聽啟動不了的原因分析Oracle資料庫
- Creating a Physical Standby DatabaseDatabase
- 11g 最大保護模式 standby database網路故障導致主庫當機模式Database
- Oracle physical standbyOracle
- oracle 資料庫lsnrctl監聽的日誌路徑和trace檔案Oracle資料庫
- Oracle 監聽器日誌配置與管理Oracle
- Linux作業系統啟動時自動啟用oracle standby備庫日誌應用Linux作業系統Oracle
- Oracle 跟蹤/告警/監聽日誌的清理指令碼Oracle指令碼