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

Thread: Restore database

  1. 02-21-2008, 02:48 PM #1
    pascal01
    pascal01 is offline Member
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222

    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 ?
    Reply With Quote Reply With Quote
  2. 02-21-2008, 03:40 PM #2
    ebrian
    ebrian is offline Senior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width