| Help! Accidental data deletion! Recovery! [message #53500] |
Tue, 24 September 2002 13:49  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
We have a database in archive log mode. Cold backups are performed weekly (Saturday) and daily exports are done. Its a very busy database. A user has accidently deleted a large amount of data
from a table (say TAB1) at 8.30am Thursday. Nobody came to know about this until 12.30pm the same day. The database is then shutdown. Users have entered more data into TAB1 between 8.30am and 12.30pm. How do we recover this deleted data and also make sure that new data entered between 8.30am and 12.30pm is also available?
Any procedures with and without RMAN will be helpful. I got a OracleREcoveryScenarious info from this site, but that doesn't explain this scenario.
Thx
Tony
|
|
|
|
| Re: Help! Accidental data deletion! Recovery! [message #53502 is a reply to message #53500] |
Tue, 24 September 2002 14:38  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
This could be a possibility,
Have a complete copy of the db and all related files before you atempt to do the recovery.
Since you need both the deleted data and also the new data entered between 8.30am and 12.30pm, then I think
you will have to clone the database from the backup files and do an imcomplete recovery on the cloned database until just before 8.30am Thursday (just before the user deleted the data). Open the cloned db with 'resetlogs' option and you will have the table TAB1 with the data that was deleted by the user. Copy the deleted data from cloned db table TAB1 into your Original database table TAB1.
I am not sure of the new tools in 9i (if you are using 9i).
Hope some one else give you a better solution.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
