RMAN error collection

SQL> select * from v $ version;

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-Prod
PL/SQL Release 10.2.0.3.0-Production
CORE10.2.0.3.0Production
TNS for 32-bit Windows: Version 10.2.0.3.0-Production
NLSRTL Version 10.2.0.3.0-Production

 

Detailed description of the cross check command under RMAN

 

(RMAN-06207 & RMAN-06208) decide which keyword to use based on the blue font Section

One of these cases (solved by crosscheck copy)

RMAN> report obsolete;

The RMAN retention policy is applied to this command.
Set the RMAN retention policy to redundancy 1.
Obsolete backup and copy reports
Type keyword completion time file name/handle
----------------------------------------------------------------

Control file copy 7 17-4 month-13 E: \ CONTROLFILE. TXT

RMAN> delete obsolete;


The RMAN retention policy is applied to this command.
Set the RMAN retention policy to redundancy 1.
Use channel ORA_DISK_1
Delete the following obsolete backups and copies:
Type keyword completion time file name/handle
----------------------------------------------------------------
Control file copy 7 17-4 month-13 E: \ CONTROLFILE. TXT


Are you sure you want to delete the above objects (enter YES or NO )? Yes


RMAN-06207: Warning 1 object (for DISK channel) cannot be deleted because the status does not match ).
RMAN-06208: Use the CROSSCHECK command to correct the status
RMAN-06210: List of unmatched objects
RMAN-06211: ================================
RMAN-06212: object type file name/handle
RMAN-06213 :------------------------------------------------------------------
RMAN-06214: Datafile Copy E: \ CONTROLFILE. TXT

RMAN> crosscheck copy;

Released channel: ORA_DISK_1
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 159 devtype = DISK
The description does not match any archived logs in the recovery directory.
An error occurred while verifying the control file copy.
Control file copy file name = E: \ CONTROLFILE. TXT recid = 7 stamp = 812996873
1 object that has been cross-checked

RMAN> delete obsolete;

The RMAN retention policy is applied to this command.
Set the RMAN retention policy to redundancy 1.
Use channel ORA_DISK_1
Delete the following obsolete backups and copies:
Type keyword completion time file name/handle
----------------------------------------------------------------
Control file copy 7 17-4 month-13 E: \ CONTROLFILE. TXT


Are you sure you want to delete the above objects (enter YES or NO )? Yes
Deleted control file copy
Control file copy file name = E: \ CONTROLFILE. TXT recid = 7 stamp = 812996873
1. The object has been deleted.

RMAN> report obsolete;

The RMAN retention policy is applied to this command.
Set the RMAN retention policy to redundancy 1.
No obsolete backup found

1 2 3 Next Page