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;
Comments