Oracle11g的RMAN-06207: WARNING:不能刪除歸檔日誌
在Oracle11g的rman中,如:
RMAN> delete archivelog all;
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Archivelog +ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=588 instance=cboms1 device type=DISK
validation succeeded for archived log
archived log file name=+ARCHDG/cboms/archivelog/2010_12_20/thread_1_seq_161.321.738252445 RECID=390 STAMP=738252447
validation failed for archived log
archived log file name=+ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115.276.737837641 RECID=325 STAMP=737837643
validation succeeded for archived log
archived log file name=+ARCHDG/cboms/archivelog/2010_12_20/thread_2_seq_156.323.738252443 RECID=389 STAMP=738252446
Crosschecked 3 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=588 instance=cboms1 device type=DISK
List of Archived Log Copies for database with db_unique_name CBOMS
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
325 2 115 X 15-DEC-10
Name: +ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115.276.737837641
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archived log
archived log file name=+ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115.276.737837641 RECID=325 STAMP=737837643
Deleted 1 EXPIRED objects
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12778571/viewspace-682178/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- crontab不能自動刪除歸檔日誌
- 歸檔日誌的刪除
- oracle刪除歸檔日誌Oracle
- Oracle歸檔日誌刪除Oracle
- 刪除歸檔日誌檔案
- 刪除data guard歸檔日誌
- 手動刪除歸檔日誌
- 作用RMAN 刪除歸檔日誌
- 刪除歸檔,保留最近的5個歸檔日誌
- oracle 刪除過期的歸檔日誌Oracle
- 歸檔日誌刪除的五種方法
- 【Oracle】 rman 刪除歸檔日誌的命令Oracle
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- 保證歸檔日誌不能隨意被刪除的四種方法
- 當ORACLE歸檔日誌滿後如何正確刪除歸檔日誌Oracle
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- oracle rman不能自動刪除歸檔日誌備份解決Oracle
- rman刪除舊的歸檔日誌問題
- Oralce資料庫關閉歸檔日誌並且刪除歸檔日誌資料庫
- RMAN delete archivelog命令刪除歸檔日誌及歸檔日誌拷貝deleteHive
- rman刪除歸檔日誌命令集
- oracle dataguard 自動刪除歸檔日誌Oracle
- 如何定期自動刪除歸檔日誌
- 【警鐘】謹慎刪除歸檔日誌
- 如何正確刪除ORACLE歸檔日誌檔案Oracle
- DG_保證歸檔日誌不能隨意被刪除的四種方法
- DATAGUARD_standby刪除歸檔日誌的指令碼指令碼
- rman 刪除指定時間點的歸檔日誌
- 用rman 正確地刪除歸檔日誌
- rac+dg環境刪除歸檔日誌
- DELETE OBSOLETE不刪除歸檔日誌以及歸檔的備份集delete
- oracle11G歸檔日誌管理Oracle
- ORA-00257 (線上更改歸檔路徑,刪除歸檔日誌)
- 11gR2 RMAN歸檔日誌刪除策略
- DataGuard已應用歸檔日誌刪除指令碼指令碼
- RMAN刪除歸檔日誌時將ASM上空目錄同時刪除ASM
- 在Oracle中,如何定時刪除歸檔日誌檔案?Oracle
- Oracle11g redo log 建立、新增、刪除(重做日誌組,重做日誌檔案)Oracle