Re: hot backup recovery

If your backup is indeed bad, and cannot be recovered, then you are pretty much dead... However, I know for a fact, that Oracle has a utility, which a engineer will have to come out and compile and use, which will extract your data from the actual datafiles, place it in a file which can be loaded, the utility lets the engineer even decide on the delimiter with which to use.... I know this for a fact, because several years ago, on a very large and critical database, they were able to extract the data for a table for me.....

Ernie Emerick
(214) 707-7000

 <martin_at_surfeu.com> wrote in message news:391A1D11.4D919AA8_at_surfeu.com...
>
>
> I am having a serious problem restoring our database from backup.
>
> Here is the scenario. Oracle is 8.0.5, Linux, backups are done nightly
> as a filesystem mirror with the Linux 'dump' utility. Database is in
> redo archive mode and I am backing up everything - datafiles, control
> files, redo logs and archive.
>
> I accidentaly deleted everything. OK, got my nerves back and restored
> all the files from tape. Oracle didn't start and after the db mount the
> log file says:
>
> Thread 1 opened at log sequence 27158
> Current log# 2 seq# 27158 mem# 0:
> /disk2/oracle/oradata/surfeu/redosurfeu02.log
> Successful open of redo thread 1.
> Wed May 10 20:14:51 2000
> SMON: enabling cache recovery
> SMON: enabling tx recovery
> Wed May 10 20:14:51 2000
> Errors in file /disk2/oracle/admin/surfeu/bdump/smon_surfeu_2157.trc:
> ORA-00600: internal error code, arguments: [4146], [32734], [32613], [],
> [], [], [], []
>
> Trying to recover the database manually didn't help - the latest redo
> archive is missing and the datafile 'needs more recovery'.
>
> Please, is there any possibility of at least getting the data from the
> database? Oracle says the database is not consistent, is it possible to
> open it at least for the export?
>
> Any help would be greatly appreciated.
>
> Thank you
>
> Martin Cernicka
Received on Thu May 11 2000 - 00:00:00 CDT