Q
Problem solve Get help with specific problems with your technologies, process and projects.

Restore a dropped table with hot backup

I have last night's hot backup. One user unexpectedly dropped a table. How can I restore the table with minimal time?

I have a 2-terabyte database. I don't have a standby database and I don't have a cold backup of the database. I have last night's hot backup. One user unexpectedly dropped a table. How can I restore the table with minimal time?
If you are using Oracle 10g, you can restore the table with the Flashback Table operation with the following command:
FLASHBACK TABLE table_name TO BEFORE DROP; 
If you are not using Oracle 10g, then you can restore the entire database and perform an incomplete recovery. Instead of opening your restored database, do the following:
STARTUP MOUNT
RECOVER DATABASE UNTIL TIME '2000-01-31:23:59:00';
ALTER DATABASE OPEN RESETLOGS;
You can specify the appropriate time to recover to.

Immediately shut down your database and take a good backup.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

what if, i dont have backup & user dropped a table?
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close