RMAN 解决(RMAN-06208,RMAN-06207,ORA-19606)删除过期文件问题
-
RMAN> Delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 18 16-JUN-15 /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
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: Datafile Copy /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
released channel: orademo
RMAN>
RMAN> CROSSCHECK CONTROLFILECOPY 18;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
validation failed for control file copy
control file copy file name=/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f RECID=18 STAMP=882531818
Crosschecked 1 objects
RMAN> delete expired CONTROLFILECOPY 18;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
18 X 16-JUN-15 3621263 16-JUN-15
Name: /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
Tag: TAG20150616T114337
Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 08/14/2015 10:16:38
ORA-19606: Cannot copy or restore to snapshot control file
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.fbak';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.fbak';
new RMAN configuration parameters are successfully stored
RMAN> crosscheck controlfilecopy '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
validation failed for control file copy
control file copy file name=/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f RECID=18 STAMP=882531818
Crosschecked 1 objects
RMAN> delete expired controlfilecopy '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
18 X 16-JUN-15 3621263 16-JUN-15
Name: /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
Tag: TAG20150616T114337
Do you really want to delete the above objects (enter YES or NO)? yes
deleted control file copy
control file copy file name=/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f RECID=18 STAMP=882531818
Deleted 1 EXPIRED objects
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.fbak';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
RMAN configuration parameters are successfully reset to default value
-
RMAN> Delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 18 16-JUN-15 /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
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: Datafile Copy /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
released channel: orademo
RMAN>
RMAN> CROSSCHECK CONTROLFILECOPY 18;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
validation failed for control file copy
control file copy file name=/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f RECID=18 STAMP=882531818
Crosschecked 1 objects
RMAN> delete expired CONTROLFILECOPY 18;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
18 X 16-JUN-15 3621263 16-JUN-15
Name: /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
Tag: TAG20150616T114337
Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 08/14/2015 10:16:38
ORA-19606: Cannot copy or restore to snapshot control file
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.fbak';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.fbak';
new RMAN configuration parameters are successfully stored
RMAN> crosscheck controlfilecopy '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
validation failed for control file copy
control file copy file name=/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f RECID=18 STAMP=882531818
Crosschecked 1 objects
RMAN> delete expired controlfilecopy '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1335 device type=DISK
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
18 X 16-JUN-15 3621263 16-JUN-15
Name: /app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f
Tag: TAG20150616T114337
Do you really want to delete the above objects (enter YES or NO)? yes
deleted control file copy
control file copy file name=/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f RECID=18 STAMP=882531818
Deleted 1 EXPIRED objects
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.fbak';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle11.f';
RMAN configuration parameters are successfully reset to default value
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29065182/viewspace-1771378/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29065182/viewspace-1771378/