6 Replies Latest reply: Apr 19, 2013 2:03 AM by 980965 RSS

    Rman restore problem

    980965
      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