Wednesday, August 5, 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: ==========================

    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

    0
    - Advertisment -
    dbametrix

    Most Popular

    The Life of DBAs is Changing

    Article explains how The Life of DBAs is Changing in Self-Managing Oracle Database. An detail introduction of Oracle Autonomous Database Cloud

    MySQL as PHP database

    The article illustrates the relationship between data and semantics of data stored in a database with reference to the semantic WEB

    Supply Chain Management in ERP

    The article provides detail of what is supply chain management system and what is the importance.

    Business Intelligence Market

    The blog explains how business intelligence is growing in Global market and what is the future of BI.

    Recent Comments