on 01-12-2009 3:13 PM
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.
Did you recreate the control files?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.