Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recovery process

51182Jan 17 2007 — edited Jan 18 2007
I am trying to understand the oracle recovery process.

Let's say User.dbf file got lost.. I made a back up copy last night.. ( currently DB is in the archived log mode)

Here is the steps that I am going to follow to recover the DB
1) shutdown the DB
2)copy the back up file to the data file location
3)startup mount
4)set autorecovery on
5)recover database;
6) alter database open;

are these all steps that I need to follow to bring the DB back online?

I Am trying to recover DB up to the current point in time.. if I say set autorecovert on, will it recover to the curent pont it time by using redo logs?
what about the archived log files? when does these files are going to be used during the recovery process? I am trying to recover DB for the yesterday's backup file..
I am trying to understand the recovery process and make sure no data got lost since the last backup...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2007
Added on Jan 17 2007
8 comments
303 views