3 Replies Latest reply: Oct 9, 2012 9:11 AM by ggiulian RSS

    Problem with Recover Until Time

    ggiulian
      Hi All.

      Scenario
      RAC DB SERVER 11g
      RMAN + HP Dataprotector for backup

      OS HP-UX

      On 3 december I receive a Block Corruption into DB 11g

      Now I'm tring to restore until time (2 december) but I receive some errors

      List incarnation output:

      RMAN> list incarnation of database dbcorp;


      List of Database Incarnations
      DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
      ------- ------- -------- ---------------- --- ---------- ----------
      66873 66908 DBCORP 2282530099 PARENT 1 19-MAY-10
      66873 66909 DBCORP 2282530099 PARENT 7737623344710 20-OCT-10
      66873 66910 DBCORP 2282530099 PARENT 7737892001057 22-OCT-10
      66873 66874 DBCORP 2282530099 CURRENT 7739974480835 06-DEC-10

      In this care, when try to restore until time, i receive
      RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

      If I change incarnation to previus (66910) I receive RMAN-00600: internal error, arguments [8201] [] [] [] []


      Select * from v$log_hitory into the database
      RESETLOGS
      ---------
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10

      RESETLOGS
      ---------
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      22-OCT-10
      06-DEC-10
      06-DEC-10
      06-DEC-10
      06-DEC-10
      06-DEC-10


      Can I restore until 01 december???
      Any ideas???

      Regards

      Giovanni Giuliani

      Edited by: user12172728 on 13-dic-2010 3.37

      Edited by: user12172728 on 13-dic-2010 3.37