Friday, April 17, 2009

ORA-38856 - while opening a cloned RAC database

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.

16 comments:

Anonymous said...

Thanks Man. That helped

Rishabh said...

Thanks for this piece. It helped.

Paolo Cumin said...

Christ almighty, this saved my ass! Thanks a bunch!

Anonymous said...

It helped us

Anonymous said...

It really helped !
thanks :)

Rama said...

Great help in need...

Anonymous said...

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

Anonymous said...

God is great. You are great too :) Thanks for sharing. -Raj KL.

Anonymous said...

it works perfectly!!!!

Anonymous said...

Thanks! That helped.

Anonymous said...

This parameter saved to do 15hrs job again

Anonymous said...

Another thank you. Finding the correct answer in the first search result is truly a beautiful thing.

May good fortune follow you always.

Shwetha Kt said...

thanks a lot great job

Anonymous said...

Dude, I've gotten help from your site twice this weekend. Nice job, thanks.

Anonymous said...

You've helped me out twice this weekend. Nice job, thanks.

Anonymous said...

Thanks a bunch. Worked like a charm.