We're here to help!

After switchover RMAN backup copy images are useless

Follow

 This issue was encountered after running GS. The RMAN backup copy images become useless (uncataloged / removed) because of the new controlfile. 


Problem Details

Problem Statement

The RMAN backup copy images become useless after GS.

Applicable Error Code

N/A

Affected Versions

v8

Affected Platforms

All

 

Description

The RMAN backup copy images become useless after GS.

Create a new backup as the copy image files result in this :

no parent backup or copy of datafile x found
no parent backup or copy of datafile y found
no parent backup or copy of datafile z found

Solution

Oracle support stated they do not support a catalog recovery area of catalog start with on an image copy.

Solution: The datafiles have to be cataloged one by one.

Example:  
RMAN> CATALOG DATAFILECOPY 'C:\ORADATA\PRD\AC66B818C\DATAFILE\O1_MF_DATA_X.DBF' LEVEL 0 TAG='DB_COPY'; 
RMAN> CATALOG DATAFILECOPY 'C:\ORADATA\PRD\AC66B818C\DATAFILE\O1_MF_DATA_Y.DBF' LEVEL 0 TAG='DB_COPY'; 
RMAN> catalog backuppiece 'C:\ORADATA\PRD\AC66B818C\BACKUPSET\2018_07_25\O1_MF_DB_COPY_X.BKP; 
RMAN> catalog backuppiece 'C:\ORADATA\PRD\BACKUPSET\2018_07_25\O1_MF_DB_COPY_XX.BKP; 
RMAN> catalog backuppiece 'C:\ORADATA\PRD\AC66B818C\BACKUPSET\2018_07_25\O1_MF_DB_COPY_Y.BKP; 
RMAN> catalog backuppiece 'C:\ORADATA\PRD\BACKUPSET\2018_07_25\O1_MF_DB_COPY_YY.BKP;
Have more questions? Submit a request

Comments