| Backup scenario [message #165098] |
Tue, 28 March 2006 05:44  |
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
|
Member |
|
|
Hi All,
i have one backup scenario,
suppose my production database is running in archive log mode, and i have taken the hot backup at night.
today at 2:00 pm i created one table and dropped at 4:00 pm.
my question is :is it possible recover the dropped table as the same is not backed up at night ??? if yes then how.
Regards
Mohammad Asif
|
|
|
|
|
|
|
|
|
|
 Re: Backup scenario [message #165135 is a reply to message #165126] |
Tue, 28 March 2006 07:49  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
hi,
If you are using 10g you can do DDL flashback.
I will explain one method
1. Shutdown DB
2. Make a fresh cold Backup including controlfiles and redo log files.
3. Restore from the Previous Backup (only datafiles).
4. Recover the database until time (here the time means time just before the drop table).
5. Open the database in reset logs.
6. Export that table.
7. Shutdown Database.
8. Restore the Database (including redo log files and control files) using the fresh backup made in Step 2.
9. Open the Database.
10. Export the Dump.
I didn't get a situation to test this.
Try to avoid this situation by taking the export of important tables at regular intervals.
Regards
SALIH KM
[Updated on: Tue, 28 March 2006 07:50] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
