I was attempting to open a cloned RAC database and got the following error:
SYS@NETFRD1> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
The fix was to use the undocumented parameter - _no_recovery_through_resetlogs=TRUE to open the database. I guess this is one of those scenarios where Oracle suggests using this undocumented/unsupported parameter. Here is what I did to get pass the problem:
1. Shutdown;
2. Startup mount (with the parameter _no_recovery_through_resetlogs=TRUE set in init.ora)
3. Open the database with RESETLOGS;
SYS@NETFRD1> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
SYS@NETFRD1> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS@NETFRD1> !vi /tmp/init$ORACLE_SID.ora
SYS@NETFRD1> startup mount pfile=/tmp/init$ORACLE_SID.ora
ORACLE instance started.
Total System Global Area 1577058304 bytes
Fixed Size 2084232 bytes
Variable Size 385876600 bytes
Database Buffers 1174405120 bytes
Redo Buffers 14692352 bytes
Database mounted.
SYS@NETFRD1> alter database open resetlogs;
Database altered.
Friday, April 17, 2009
Subscribe to:
Post Comments (Atom)
15 comments:
Thanks Man. That helped
Thanks for this piece. It helped.
It helped us
It really helped !
thanks :)
Great help in need...
If I remember correctly, i too faced this error message after cloning a rac database. At that time, we had added separate threads of logfiles and it worked fine.
Sai
God is great. You are great too :) Thanks for sharing. -Raj KL.
it works perfectly!!!!
Thanks! That helped.
This parameter saved to do 15hrs job again
Another thank you. Finding the correct answer in the first search result is truly a beautiful thing.
May good fortune follow you always.
thanks a lot great job
Dude, I've gotten help from your site twice this weekend. Nice job, thanks.
You've helped me out twice this weekend. Nice job, thanks.
Thanks a bunch. Worked like a charm.
Post a Comment