Recovery process
51182Jan 17 2007 — edited Jan 18 2007I 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...