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

Thread: Recovery

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    How can v handle the following situation ?

    Suppose :

    I hv a offline backup of 28th September. And after that I hv archive logs till 6th October.

    What else I need to recover my database.

    What type of recovery I need to do.

    Until Change or Untill Cancel will also do.

    I know that I cannot recover it fully as I don't hv Arch Logs from 7th Ownards.

    Please advise.


    Regards
    Vijay
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The maximum you can recover upto is the time till that you have archive logs.
    Till what time to recover, depends on your requirement. If you want to require upto the latest archive log availbale do "recover until cancel"

    HTH
    Sanjay

  3. #3
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    For this do i need to hv a latest control file

    if I don't hv latest cntrl file then what is the scenario ?

    vijay
    --------------------------
    The Time has come ....

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by vijay8282
    Hi,

    For this do i need to hv a latest control file

    if I don't hv latest cntrl file then what is the scenario ?

    vijay
    Not necessary.... If you don't have latest controlfile, you can rebuild also..

    Sameer

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No need to rebuild control file, no need to have current controlfile. Simply use the controlfile from cold backup and specify that you are recovering by using old controlfile:

    RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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