Sunday, October 25, 2020
dbametrix
More
    Home Oracle Troubleshooting To solve RMAN-06207, RMAN-06208, RMAN-06210 errors

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

    Hi friends,

    Sometimes we are facing errors from RMAN for Oracle backup as following.

    - Advertisement -
    dbametrix

    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: ==========================

    - Advertisement -
    dbametrix

    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.

    Thanks and regards,

    Dbametrix Solutions

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    Recent Comments