This discussion is archived
6 Replies Latest reply: Apr 19, 2013 12:03 AM by 980965 RSS

Rman restore problem

980965 Newbie
Currently Being Moderated
Hello all,

i have two level 0 backup and five leve1 backup details 08-Apr-13 level 0 at 6 pm, 09-Apr-13 level 1 6 pm, 10-Apr-13 level 1 6 pm , 11-Apr-13 leve1 6 pm, 12-Apr-13 level 1 6 pm

and next week 15-Apr-13 level 0 at 1.30 pm, 15-Apr-13 level 1 at 6 pm.

Archive logs generated every day, 15-Apr-13 days archivelog times are morning 9.30 am , 10.45 am, 1.40 pm, 3.30 pm, 5.45 pm.
My Database has little problem on 15-Apr-13 at 6.10 pm. i want to restore the database to 15-Apr-13 using archivelog time 5.45 pm for this

First i restore the 15-Apr-13 level 0 backup

Rman> startup mount;
> restore database;
> recover database until time '15-Apr-2013 05:45:12';
error is Rman-06555 data file 1 mustbe restored from backup created before 15-Apr-13
Then i try to restore the second way
first restore 08-apr-13 level 0 backup its level 1 backups, then restore second 15-Apr-13 level 0 backup and try to resore
recover database until time '15-Apr-2013 05:45:12'
still the same error above
error is Rman-06555 data file 1 mustbe restored from backup created before 15-Apr-13

But i can restore to 15-Apr-13 10.45am using the first level 0 backup. i couldn't restore to 15-apr-13 5.45pm Why?
can i recover to 15-apr-13 5.45pm ?
please help me
Thanks to all
regards mkv

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points