internal error after brrestore from online backup

[Former Member]

after run brrestore -m full -b last -d util_file to restore sap system from a online+redo log backup,

I try to startup database, and I get these error:

Tue Jan 13 09:38:58 2009

Completed: ALTER DATABASE OPEN

Tue Jan 13 09:38:59 2009

Errors in file /oracle/PRD/saptrace/background/prd_smon_1327258.trc:

ORA-00600: internal error code, arguments: [4194], [5], [4], [], [], [], [], []

Tue Jan 13 09:39:00 2009

Doing block recovery for file 30 block 2309

Block recovery from logseq 7, block 70 to scn 992186000

Tue Jan 13 09:39:00 2009

Recovery of Online Redo Log: Thread 1 Group 3 Seq 7 Reading mem 0

Mem# 0: /oracle/PRD/origlogA/log_g13m1.dbf

Mem# 1: /oracle/PRD/mirrlogA/log_g13m2.dbf

Block recovery stopped at EOT rba 7.98.16

Block recovery completed at rba 7.98.16, scn 0.992185999

Doing block recovery for file 2 block 137

Block recovery from logseq 7, block 70 to scn 992185990

Tue Jan 13 09:39:00 2009

Recovery of Online Redo Log: Thread 1 Group 3 Seq 7 Reading mem 0

Mem# 0: /oracle/PRD/origlogA/log_g13m1.dbf

Mem# 1: /oracle/PRD/mirrlogA/log_g13m2.dbf

Block recovery completed at rba 7.80.16, scn 0.992185992

Tue Jan 13 09:39:00 2009

Errors in file /oracle/PRD/saptrace/background/prd_smon_1327258.trc:

ORA-01595: error freeing extent (6) of rollback segment (9))

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4194], [5], [4], [], [], [], [], []

Could you give some solutions , thanks a lot.

Is there something I should do after brrestore ?

Edited by: victor on Jan 13, 2009 2:49 AM

Edited by: victor on Jan 13, 2009 2:50 AM

[Former Member · Accepted solution]

Hi Victor,

Did you perform any recovery on the DB after restore was done? The error that you have got is usually because of the following reason :

"A mismatch has been detected between Redo records and rollback (Undo) records. We are validating the Undo record number relating to the change being applied against the maximum undo record number recorded in the undo block. This error is reported when the validation fails."

Suggestion :

Try to do a recovery of the DB till the end time of the backup which you have used for restoration and then try to open your database. Also, take care of re-creating your controlfile and opening the database in resetlogs case.

Regards,

Deoraj Alok.

[Former Member · Accepted solution]

thanks, I do follow your suggestion to solve my problem.

but I do not know whether my steps are right.

1> SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

2> I alter database backup controlfile to trace, then I found this trace file

3> I go to sqlplus to execute this control file SQL> @/oracle/PRD/saptrace/usertrace/prd_ora_1355912.trc

4> alter database open resetlogs; then, the database can open successfully.

Could you give me some suggestions. thanks.

[Former Member · Accepted solution]

Hi Victor,

First thing is to create the controlfile, if you have not done this step, generate a trace file at the source system and use it to recreate the controlfile at your target server.

You need to use the following query to recover your database:

recover database using backup controlfile;

After the recovery gets completed, you can open the DB in resetlogs case.

Regards,

Deoraj Alok.

[Former Member]

Hi,

Seems like Some corruption in UNDO tablespace, Report this to oracle support.

There is one more workaround, if its not in production environment you can try this.

Create a new undo tablespace and change the parameters in init<SID>.ora.

Old undo tablespace will not be used at all, once db started remove the tablespace.

Hope it helps

Regards

KT