一次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 DG建立Physical Standby DatabaseOracleDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- Oracle Physical Database LimitsOracleDatabaseMIT
- 在Oracle DG Standby庫上啟用flashback database功能OracleDatabase
- Oracle 12.2 physical standby備庫收集AWR報告Oracle
- 搭建windows到linux的oracle 12c physical standby備庫WindowsLinuxOracle
- Oracle 12c DG備庫啟動報錯standby database requires recoveryOracleDatabaseUI
- oracle 資料庫lsnrctl監聽的日誌路徑和trace檔案Oracle資料庫
- oracle DG 日誌傳輸小結Oracle
- oracle10g DataGuard的日誌傳輸方式Oracle
- Standby_file_management引數導致日誌無法應用
- Oracle啟動兩個監聽Oracle
- Oracle DG Standby Database型別OracleDatabase型別
- Oracle DG建立Logical Standby DatabaseOracleDatabase
- 資料庫管理-第118期 記一次開啟附加日誌導致的效能問題(202301129)資料庫
- 在duplicate時,出現監聽BLOCKED的情況,導致監聽自動關閉BloC
- STANDBY_FILE_MANAGEMENT引數未設定auto導致的ADG備庫異常
- 啟動資料庫監聽資料庫
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- oracle監聽不到例項服務Oracle
- 通過RMAN設定standby接收日誌後主庫歸檔日誌才可刪除
- Oracle RAC啟動因CTSS導致的異常Oracle
- 監聽MySQL的binlog日誌工具分析:CanalMySql
- Zabbix如何監控Oracle的告警日誌Oracle
- Oracle sysman.mgmt_jobs導致資料庫自動重啟Oracle資料庫
- Mysql 從庫如果有未提交的事務主庫ddl操作導致主從延遲MySql
- 主庫千萬級的資料更新後,STANDBY日誌應用大量延遲的問題處理
- 【DG】Data Guard搭建(physical standby)
- 使用zabbix監控oracle的後臺日誌Oracle
- Oracle 自動化運維-Python監控Oracle告警日誌Oracle運維Python
- JVM 輸出 GC 日誌導致 JVM 卡住,我 TM 人傻了JVMGC
- 【ASK_ORACLE】Oracle 12.2 Bug導致網路卡出現故障後RAC庫未向TCP註冊本地VIP監聽OracleTCP
- oracle rac+adg調整redo日誌組導致adg備庫ogg抽取程式abendOracle
- 啟動tomcat時,日誌裡大量輸出建立資料來源dataSource的日誌Tomcat
- 案例:DG主庫未設定force logging導致備庫壞塊
- zabbix-agent啟動之後10050埠未監聽
- 在被線上大量日誌輸出導致效能瓶頸,執行緒Block的坑執行緒BloC
- oracle 序列值導致的主鍵衝突問題Oracle