Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recover erased records.
By "erased" do you mean deleted the rows or dropped the table?
Check to see if the exp utility is ran against the database on a regular basis. If so the last export prior to the error should have the table structure and at least some of the data.
If you have hot or cold backups these can be used to recover the data but doing so requires knowledge of the backup and recovery process in Oracle. One method is to create a copy of the database using the backup removing all tablespaces not necessary to hold the table. If the database is in archive log mode this copy database is then rolled forward to a point in time just prior to the error. The data is then extracted via export and imported to the real database. If the database is not in archive log mode then the data is just extracted from the copy. But this takes knowledge of how to manually build an Oracle database, alter the control file, recover, using exp, and imp.
There are a couple of manuals on Backup and Recovery. The imp and exp utilities are covered in the Utilities manual.
HTH -- Mark D Powell -- Received on Wed Apr 13 2005 - 08:01:59 CDT