Point-in-time recovery using hot backup
I am developing and practicing backup and recovery process.
Primary test database : TEST
second test database : STEST
Nov/10 09:20 AM
A developer dropped a table called A in TEST.
Nov/10 10:00
I checked log list
Oldest online log sequence 41
Next log sequence to archive 43
Current log sequence 43
I stared hot backup of TEST.
From the hot backup I got all datafiles, archived log files, control files and text control file.
Nov/10 10:30
I decided to do Point-In-Time recovery in a Primary node since nothing was inserted or modified between 09:20 and 10:00.
Shutdown TEST , start up mount and then issued
Recover database until time '2000-11-10 :09:00:00' using backup controlfile;
Oracle responded ;
Media Recovery Start
Media Recovery Not Required
Completed: ALTER DATABASE RECOVER database until time '2000-11-10 :09:00:00'
Then I opened database with resetlog mode.
-obviously, Nothing was recovered and I opened database (stupidly)using reset log.
- I can not perform recovery in this database since I opened database with reset log option.
- Before I performed recovery I didn't make sure the time the object was dropped, probably I should have went before 09:00 o'clock.
- I decide to clone the database( recovery) in the second node.
My question and confusion is that since I have a hotbackup of TEST database before I resetlog, with this backup, Can I go back to before 9:00 o'clock.
In other word, if I perform a point - in -time recovery in the second node, using hot backups but can I recover to the point in time before the object was dropped?
I performed this process and I applied archive log # 43 but I can not find a table A in the new database(STEST).
I guess that since I didn't have online redo logs(hot backup), I could not roll forward. Is this reason or what I 've done was totally wrong?
Please share your experience with me.
Thank you for your time.
[Edited by chobo on 11-16-2000 at 05:12 PM]