Log in

Sangfor Support Center

Table of Contents
< All Topics
Print

[aCloud] Errors when running Rman backup scripts: RMAN-06208, RMAN-06210, RMAN-06214

Posted
Updated
Byadmin
Views1

Problem Description

An error is reported when running the Rman backup script, as shown below. The message indicates that the backup was successful, but a controlfile copy exists that cannot be deleted.

Alarm Information

RMAN-06207: WARNING: cannot drop 1 object (for DISK channel) due to state mismatch.
RMAN-06208: Please use CROSSCHECK command to correct the status
RMAN-06210: list of mismatched objects
RMAN-06211: ==========================
RMAN-06212: object type  filename/handle
RMAN-06213: ————— —————————————————
RMAN-06214: Datafile Copy   E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFORACLE10.ORA

Root Cause

Oracle MOS gives the following explanation: The snapshot controlfile is cataloged as a controlfile copy and is now obsolete. RMAN cannot delete this file as it is used by rman. This means that an expired control file snapshot copy is being used by rman and cannot be automatically deleted. It needs to be cleaned up manually.

Solution

Since RMAN will continue to use that file as it's snapshot copy, you must change the location/name that RMAN is using before it will allow you to delete the file.
This solution is provided by Oracle MOS. You need to modify the location of CONFIGURE SNAPSHOT CONTROLFILE NAME so that RMAN no longer uses the existing controlfile copy, and then delete the file. The specific solution steps are as follows:

  1. Log in to the rman command line. The login command is: rman target /

  2. In the rman command line, execute the following command to modify the "SNAPSHOT CONTROLFILE NAME" configuration:

  3. CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCF_TEMP.ORA';

  4. On the operating system, manually delete the controlfile copy file "E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFORACLE10.ORA" of the alarm (just cut it away, it is recommended not to delete it directly);

  5. In the RMAN command line, execute "list copy of controlfile;" and find that the file is in the RMAN backup information. Continue to execute the "crosscheck copy of controlfile;" command to crosscheck the copy of controlfile;

  6. RMAN> list copy of controlfile;

  7. RMAN> crosscheck copy of controlfile;

  8. After crosscheck is completed, you can execute "delete noprompt copy of controlfile ;" in the rman command line to delete the backup information of "E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFORACLE10.ORA". At this point, the controlfile copy file information that could not be deleted and was originally warned has been cleared.

  9. RMAN> delete noprompt copy of controlfile;

  10. Under the rman command line, restore the second step and execute the changes of the "SNAPSHOT CONTROLFILE NAME" configuration to the default.

  11. RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

Original Link

https://support.sangfor.com.cn/cases/list?product_id=33&type=1&category_id=15742&isOpen=true