RMAN-06207: WARNING: 286 objects could not be deleted for DISK channel(s)
RMAN備份報錯:
RMAN-06207: WARNING: 286 objects could not be deleted for DISK channel(s) due to mismatched status
RMAN> delete noprompt obsolete;
RMAN-06207: WARNING: 286 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備份的時候沒有找到想找的controlfile檔案。
crosscheck backup和crosscheck backupset找不到過期的copy的備份檔案。
RMAN> CROSSCHECK CONTROLFILECOPY;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "tag, double-quoted-string, integer, single-quoted-string"
RMAN-01007: at line 1 column 27 file: standard input
可以找到過期的copy的備份檔案。
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38104.bak RECID=38086 STAMP=957567614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38106.bak RECID=38088 STAMP=957569142
crosschecked backup piece: found to be 'EXPIRED'
RMAN> crosscheck backupset;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38104.bak RECID=38086 STAMP=957567614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38106.bak RECID=38088 STAMP=957569142
crosschecked backup piece: found to be 'EXPIRED'
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 38090 16-OCT-17
Backup Piece 38090 16-OCT-17 /backup/scprd1/rman/Full_SCPRD_20171016_38101.bak
Backup Set 38091 16-OCT-17
Backup Piece 38091 16-OCT-17 /backup/scprd1/rman/Full_SCPRD_20171016_38102.bak
。。。。。。
Backup Set 38558 20-OCT-17
Backup Piece 38558 20-OCT-17 /backup/scprd1/rman/Full_SCPRD_20171020_38578.bak
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38101.bak RECID=38090 STAMP=957567614
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38102.bak RECID=38091 STAMP=957567614
deleted backup piece
。。。。。。
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171020_38576.bak RECID=38559 STAMP=957913223
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171020_38578.bak RECID=38558 STAMP=957914789
Deleted 286 objects
刪除成功。
RMAN-06207: WARNING: 286 objects could not be deleted for DISK channel(s) due to mismatched status
RMAN> delete noprompt obsolete;
RMAN-06207: WARNING: 286 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備份的時候沒有找到想找的controlfile檔案。
crosscheck backup和crosscheck backupset找不到過期的copy的備份檔案。
RMAN> CROSSCHECK CONTROLFILECOPY;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "tag, double-quoted-string, integer, single-quoted-string"
RMAN-01007: at line 1 column 27 file: standard input
可以找到過期的copy的備份檔案。
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38104.bak RECID=38086 STAMP=957567614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38106.bak RECID=38088 STAMP=957569142
crosschecked backup piece: found to be 'EXPIRED'
RMAN> crosscheck backupset;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38104.bak RECID=38086 STAMP=957567614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38106.bak RECID=38088 STAMP=957569142
crosschecked backup piece: found to be 'EXPIRED'
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 38090 16-OCT-17
Backup Piece 38090 16-OCT-17 /backup/scprd1/rman/Full_SCPRD_20171016_38101.bak
Backup Set 38091 16-OCT-17
Backup Piece 38091 16-OCT-17 /backup/scprd1/rman/Full_SCPRD_20171016_38102.bak
。。。。。。
Backup Set 38558 20-OCT-17
Backup Piece 38558 20-OCT-17 /backup/scprd1/rman/Full_SCPRD_20171020_38578.bak
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38101.bak RECID=38090 STAMP=957567614
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171016_38102.bak RECID=38091 STAMP=957567614
deleted backup piece
。。。。。。
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171020_38576.bak RECID=38559 STAMP=957913223
deleted backup piece
backup piece handle=/backup/scprd1/rman/Full_SCPRD_20171020_38578.bak RECID=38558 STAMP=957914789
Deleted 286 objects
刪除成功。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2147828/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Rman]RMAN-06207 WARNING:2 objects could not be deleted for DISK channel(s) dueObjectdelete
- RMAN-08137: WARNING: Archived Log Not DeletedHivedelete
- WARNING:Could not lower the asynch I/O limitMIT
- RMAN-08137: WARNING: archived log not deleted, needed for standby or upstreamHivedelete
- 【轉】WARNING:Could not lower the asynch I/O limit 錯誤MIT
- Disk arrary's adapter in troubleAPT
- WARNING:Could not lower the asynch I/O limit 錯誤解決MIT
- Oracle11g的RMAN-06207: WARNING:不能刪除歸檔日誌Oracle
- lightdb WARNING: could not establish connection after 30000 ms
- 關於RMAN-08137: WARNING: archive log not deleted as it is still needed問題的分析Hivedelete
- WARNING:Could not increase the asynch I/O limit to 164 for SQL direct I/OMITSQL
- RMAN-03009: failure of backup command on ORA_DISK_1 channelAI
- WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O.MITSQL
- WARNING:Could not increase the asynch I/O limit to 224 for SQL direct I/O.MITSQL
- OCA 042 286題庫
- ObjectsObject
- deleted object would be re-saved by cascade (remove deleted object from associatdeleteObjectREM
- Connection with Administrator Privileges (286)
- latch: row cache objects 和cursor: pin S wait on X共同出現ObjectAI
- SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192SQL
- deleted事件監聽報錯delete事件
- 手工建立ASM Disk Groups、為 ASM Disk Groups 新增 diskASM
- Spring Boot 專案 Maven Install 出現的問題 [WARNING] The requested profile “pom.xml“ could not be activatedSpring BootMavenXML
- 啟動Jmeter5.3 後彈出警告: WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs at root 0JMeterJava
- 【檢視】oracle 資料字典檢視之 DBA_OBJECTS / ALL_OBJECTS / USER_OBJECTS(OBJ)OracleObject
- go : channel , queue , 程式管理 , 關閉channel ?Go
- 求助Exception: the model Id=(1) maybe be deleted!Exceptiondelete
- drop asm disk、撤銷drop asm diskASM
- Oracle dba_objects和all_objects 最大的區別OracleObject
- 6 Java NIO Channel to Channel Transfers-翻譯Java
- 淺談Associated ObjectsObject
- Destroying Window ObjectsObject
- create objects inmemory optionsObject
- Naming Database ObjectsDatabaseObject
- mysql WarningMySql
- NTFS Disk by Omi NTFS Mac;NTFS Disk by Omi NTFSMac
- PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* tPHPUI
- 模型deleted事件監聽報錯解析模型delete事件