Home » RDBMS Server » Backup & Recovery » Restore Database in Prior Time
Restore Database in Prior Time [message #243458] Thu, 07 June 2007 06:11 Go to next message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

can I recover/ restore my database by mentioning a prior time. Suppose I want to go to the state in the database as it was in 4th June, 2007 6:00am .. Is it possible? I have oned my flashback feature and I run my database in archive log mode.
Re: Restore Database in Prior Time [message #243474 is a reply to message #243458] Thu, 07 June 2007 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Re: Restore Database in Prior Time [message #243816 is a reply to message #243458] Sat, 09 June 2007 04:45 Go to previous message
Messages: 35
Registered: March 2006
Location: London


You can take your database back to its previous state in number of ways, it depends on for what reason you are doing it.

simply restore the recent whole backup of your database and recover it until time by using the command 'RECOVER DATABASE UNTIL TIME '...' ' and then open your DB with RESETLOGS.


Create an auxiliary database (replica of your database) as it was on 4th june and perform exp / imp to get back the data you want

Another feature is FLASHBACK database.

Any of the above would do.... but depends on what backup strategy you maintain


Recovery methods differs for both, so plan accordingly

Hope this helps

Previous Topic: Script for Schedule Backup.
Next Topic: Using Recovery Catalog?
Goto Forum:

Current Time: Mon Aug 21 05:26:38 CDT 2017

Total time taken to generate the page: 0.08205 seconds