restore problem

[Former Member]

I restored sap system use: brrestore -m full -b last -d util_file

after restore finished, I try to alter database open, then I get :

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [2141], [1739644956], [0], [], [],

[], [], []

and alert.log says:

Mon Jan 12 23:08:06 2009

alter database open

Mon Jan 12 23:08:06 2009

Error: Controlfile was changed externally while mounted

Please check if another Oracle database is running

and accessing the same controlfile

Mon Jan 12 23:08:06 2009

Errors in file /oracle/PRD/saptrace/usertrace/prd_ora_1179688.trc:

ORA-00600: internal error code, arguments: [2141], [1739644956], [0], [], [], [], [], []

ORA-600 signalled during: alter database open...

what can I do to make the database available? Do you have any solutions, thanks a lot.

[markus_doehr2 · Accepted solution]

Did you recreate the control files?

Markus

[Former Member · Accepted solution]

I do not know how to recreate a new control file.

I just run: brrestore -m full -b last -d util_file our backup is online+redolog backup.

I do not know what I should do after brrestore from a online backup?

thanks

[Former Member · Accepted solution]

Hi,

Think you have not generated control file.

Firstly have to take control file copy from source system.

In source system run this command

alter database backup controlfile to trace;

Created file will get stored in saptrace folder, copy the file to target system.

After backup restoration, we have to recompile the controlfile by using that file.

Then try to start the database

Hope it helps

Regards

KT