I have a full database backup taken using RMAN. Since that backup a table was created and dropped before another backup had been done. All online redo logs, archived logs are avaliable. The time and sequence# before table was dropped is know. How do i recover this table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recover a dropped table
- Thread starter dbstudent
- Start date
Logmine won't help. It only can help with dml, not ddl.
Flashback may help, but no experience there (luckily I never needed to use it).
But I guess you'll have to create a bogus db on another box from your backup and do a point in time recovery there, then export the table and import into production.
There is another way if I remember correctly, but it would take huge downtime of your production db...
Stefan
Flashback may help, but no experience there (luckily I never needed to use it).
But I guess you'll have to create a bogus db on another box from your backup and do a point in time recovery there, then export the table and import into production.
There is another way if I remember correctly, but it would take huge downtime of your production db...
Stefan
- Status
Similar threads
