Your Doorstep to the Temple of Oracle

Oracle EBS

ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

Posted by appsdba11i on December 26, 2011

Hi Folks

we got this error recently when we cloned our prod to test.
here are the issue details

Issue: ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

Error Message :
SQL> alter database open resetlogs;
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

Solution
==========
Edit the init.ora file and put the parameter “_no_recovery_through_resetlogs”.
Startup mount the instance.
SQL>startup mount.
SQL>alter database open resetlogs;

This should resolve the issue

Ref Note : Doc ID 409045.1

Issue arrises when Clone From Rac DB To Non-Rac DB.

Thanks
Reddy

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: