RMAN-03002 , RMAN-06015 When Restore Rman Backup

刘泽宇

现象：
Partial RMAN restore with skip tablespace option fails when putting set newname command for the skipped tablespace's datafiles.

Error when Restore RMAN  backup On Another host will fail with the following error:

Finished restore at 23-APR-23

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch command at 04/23/2011 06:03:55
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: +DATA//datafile/data_tbs1.01

原因：
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.

处理方法：

Resolve this error by removing the SET NEWNAME-clause for all datafiles which have NOT been restored, for instance due to a SKIP TABLESPACE-clause