IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “RMAN-20230: datafile copy not found in the recovery catalog ” error.
Details of error are as follows.
RMAN-20230: datafile copy not found in the recovery catalogCause: the specified datafile is not in the recovery catalog or it has been marked deleted
Action: check the datafile copy name or key
RMAN-03002: failure of switch command at 04/23/2020 08:08:34
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: +DATA/MSDB/datafile/data_tbs01
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: +DATA/MSDB/datafile/data_tbs01
This error is related with the SWITCH DATAFILE ALL is executed after the restore of the datafiles which have been relocated to a new location.
The problem is a ‘SET NEWNAME’ clause for a skipped tablespace, which is therefore not restored.
To solve this error by removing the SET NEWNAME-clause for all datafiles which have NOT been restored, for instance due to a SKIP TABLESPACE-clause
Do you want to learn more details about RMAN, then read the following articles.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/
