備份歸檔日誌報錯ORA-19625: crosscheck archivelog all
因手工刪除歸檔日誌,在使用RMAN進行歸檔日誌備份的時候報如下錯誤:
RMAN> backup database plus archivelog delete input;
Starting backup at 08-FEB-09
current log archived
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=17 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/08/2009 08:28:19
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oracle/arch1_2.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
解決方法:
$ rman target / nocatalog
RMAN> crosscheck archivelog all;
------------------------------------------------------------------------
What is your method of deleting your previous archivelogs? Is it OS command?
If OS command, your controlfile might not be updated so it treats that those archivelogs are still available in your disk. You should update your controlfile when deleting archivelogs using OS command.
RMAN> crosscheck archivelog all; // validate all archvelogs in your disk. If some are missing, it will treat it as expired.
RMAN> delete expired archivelog all; // it ill delete expired archivelog and updates your controlfile.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-628318/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 手工刪除歸檔日誌導致RMAN備份時報ORA-19625錯誤
- 用restore archivelog從備份集中恢復歸檔日誌RESTHive
- 備份歸檔日誌
- [zt] crosscheck archivelog allROSHive
- crosscheck archivelog all;crosscheck backup of區別ROSHive
- 備份歸檔日誌檔案
- 備份之歸檔重做日誌備份
- 【故障處理】手工刪除歸檔日誌導致RMAN備份時報ORA-19625錯誤
- 更換歸檔日誌引數路徑導致RMAN備份時報ORA-19625錯誤
- oracle10g rac(rhel4)_rman備份歸檔出錯_backup archivelog allOracleHive
- rman全庫備份備份歸檔日誌檔案
- RMAN備份歸檔日誌多份 %c
- RMAN備份歸檔日誌指令碼指令碼
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- RMAN delete archivelog命令刪除歸檔日誌及歸檔日誌拷貝deleteHive
- 冷備份+歸檔日誌的恢復
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- rman 還原歸檔日誌(restore archivelogRESTHive
- Oracle基礎 04 歸檔日誌 archivelogOracleHive
- rman 還原歸檔日誌(restore archivelog)RESTHive
- Rman Crosscheck刪除失效歸檔-備份恢復ROS
- 都是crosscheck惹的禍,備份歸檔失敗ROS
- crosscheck archivelog all error ORA-19587ROSHiveError
- 歸檔日誌大小 與使用rman 備份後的歸檔日誌產生的備份集大小的關係
- oracle rman備份歸檔日誌需要先切換日誌嗎Oracle
- rman備份後為什麼要同時備份歸檔日誌
- 歸檔的備份之delete all inputdelete
- 刪除歸檔物理檔案備份失敗!ORA-19625
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- RMAN備份資料檔案+控制檔案+歸檔日誌
- RMAN備份整庫和歸檔日誌的方法
- oracle歸檔切換以及歸檔日誌滿報錯問題Oracle
- DELETE OBSOLETE不刪除歸檔日誌以及歸檔的備份集delete
- RMAN備份及恢復歸檔日誌的語法
- 老虎是如何從備份集中恢復歸檔日誌
- 聯機重做日誌、歸檔日誌、備用重做日誌