|
|
|
|
| Re: Restore Database in Prior Time [message #243816 is a reply to message #243458] |
Sat, 09 June 2007 04:45  |
balaji1010
Messages: 35
Registered: March 2006
Location: London
|
Member |
|
|
Well,
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.
OR
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
RMAN or USER MANAGED ?
Recovery methods differs for both, so plan accordingly
Hope this helps
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
