RMAN 解決（RMAN-06208，RMAN-06207，ORA-19606）刪除過期檔案問題

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