| Recovering the data [message #52814] |
Thu, 15 August 2002 05:33  |
Jinu
Messages: 3
Registered: August 2001
|
Junior Member |
|
|
|
one of my friend made a mistake at a client site.. he deleted the entire record from a table... is there any way to recall the same records using any recovery options of 'oracle 8i' ... please help
|
|
|
|
| Re: Recovering the data [message #52816 is a reply to message #52814] |
Thu, 15 August 2002 08:32  |
David Simpson
Messages: 29
Registered: May 2002
|
Junior Member |
|
|
If only one record has been deleted, then option #1 would be to find out if you have any printed copy of the info and re-enter it manually into the database. This may be the quickest way to resolve the issue.
Option #2 would be to use Oracle's Log Miner utility to go thru the archivelog files to find the redo for the deleted info.
Beyond these first two options, then it gets more involved. I have a list of 15 Oracle Recovery Scenarios on my website, and you may find the info in Scenario #8 to be helpful for this situation. See the link below.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
