To solve RMAN-06207, RMAN-06208, RMAN-06210 errors

July 21, 2010 | By

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 resolved 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 above commands.

Because standby archives doesn’t register in primary database. For this situation execute above commands in standby and primary both with “crosscheck archivelog all” command also.

Thanks and regards,

Dbametrix Solutions

Be Sociable, Share!

Tags: , , , , , , ,

Category: blog, blogging, oracle troubleshooting

Comments are closed.