Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> hot backup recovery

hot backup recovery

From: Martin Cernicka <martin_at_surfeu.com>
Date: 2000/05/11
Message-ID: <391A1D11.4D919AA8@surfeu.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US