Database Recovery - Change Based
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Recovery - Change Based

  1. #1
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Question

    Hi guys

    I had attempted recovering the DB using Change based as follows

    SQL> recover database until change 30333;


    The following message appeared

    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01152: file 1 was not restored from a sufficiently old backup
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\PNL\SYSTEM01.DBF'



    how do i proceed from here

    regards

    ramji

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Restart your recovery process from the beggining, this time by firstly restoring files from sufficiently old backup.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    hi,
    Since you are doing incomplete recovery, did you restored all the datafiles?
    www.cnoug.org

  4. #4
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Question

    hi jmodic/ chao_ping

    when i try RECOVER DATABASE; all the archive log (ARC 8,9,10) and online redo logs are applied and the database is brought to the latest position.


    but, my requirement is to recover the DB until ARC 9 starting from the old backup.

    regards

    ramji


  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The backup datafile you are restoring must be older than CHANGE 30333.

    Sanjay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width