When restore a LEO backup, RMAN recieved the following error:
no backup or copy of datafile 1 found to restore
Example:
RMAN> restore database from tag=TAG20111013T212907 until time "to_date('09/06/11 06:00','MM/DD/YY HH24:MI')";
Starting restore at 13-OCT-11
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/13/2011 21:44:19
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
This could be due to the basic backup/restore process based in the dates provided in the script not match.
In this case, the backup was taken on October 13, 2011. The backup script below was trying to restore all data from October 13, 2011 to September 06, 2011. However, this might not return any data, since October comes after Septemeber.
RMAN> restore database from tag=TAG20111013T212907 until time "to_date('09/06/11 06:00','MM/DD/YY HH24:MI')";
Starting restore at 13-OCT-11
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/13/2011 21:44:19
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Another reason would be the control file is not present or not match to the restore information. The controlfile have no idea of other datafiles backup.
Resolution 1:
Make sure the script is correct.
Resolution 2:
Make sure the controlfile is present and match by trun the controlfile autobackup on,
by set up CONTROLFILE AUTOBACKUP ON
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center