Restore database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Restore database

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question Restore database

    I have an active oracle 10.2 database. I take hot backups daily. In begin backup mode, I backup all datafiles, redologs and control files and archive logs. I want to restore the database to yesterday. Do I take yesterdays backup including all files(datafiles, redo, control) and do a RECOVER UNTIL CANCEL ? Do I need to use the current control file or the backed up control file ?

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    First and foremost, do NOT backup redo logs with a hot backup. There are not needed for recovery purposes.

    Check Performing User-Managed Database Point-in-Time Recovery for all the details on performing the recovery.

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