-
Title
RMAN restore generates "RMAN-06024: no backup or copy of the control file found to restore." -
Description
When an RMAN restore identifying backup by 'TAG' is initiated from the command line the following errors may occur -
RMAN-03002: failure of restore command at 10/18/2011 20:21:15
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore -
Cause
An invalid 'TAG' is specified in the RMAN restore command.
-
Resolution
Use the "backup list" command to display details of current backups. Below is some sample output highlighting a valid backup 'TAG'.
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26257 Full 13.50M SBT_TAPE 00:00:05 18-OCT-11
BP Key: 26260 Status: AVAILABLE Compressed: NO Tag: TAG20111018T195832
Handle: hll:#298:hllepddev:534_764884712:RMAN FULL DB EPD_1318948043 Media:
Control File Included: Ckp SCN: 33681484 Ckp time: 18-OCT-11Run the backup command again specifying a valid TAG:
RMAN> run {allocate channel ch1 type 'SBT_TAPE'; restore controlfile from TAG 'TAG20111018T195832'; release channel c1;}