Hi friends,
Sometimes we are facing errors from RMAN for Oracle backup as following.
RMAN-06207: WARNING: 2 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 /ocfs2/arch/SPTELCO/SPTELCO_1_18272_647314401.arc
RMAN-06214: Archivelog /ocfs2/arch/SPTELCO/SPTELCO_2_18747_647314401.arc
Solution for RMAN-06207, RMAN-06208, RMAN-06210 errors:
To solve RMAN-06207, RMAN-06208, RMAN-06210 errors perform crosscheck command execution from rman prompt. This command update RMAN’s metadata and catalog.
RMAN>crosscheck archivelog all;
If this command error doesn’t resolve then delete command can be helpful in this situation.
RMAN>DELETE FORCE OBSOLETE;
If above all commands do not working then kindly check from where are you executing the above commands.
Because standby archives don’t register in the primary database. For this situation execute the above commands in standby and primary both with “crosscheck archivelog all” command also.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.
