ORA-38856 Error

I am restoring a database from a production environment to a test environment, I am using a hot backup and restoring from sqlplus (of course, I must use rman). When I execute “alter database open resetlogs”” to reset the redo files gives me the following error (also from rman);

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL>
SQL>
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thr ead 2) as enabled

After a while of investigantions it seems that it is the bug (4355382 and 11076718). The solution is to configure the next parameter in the init.ora or spfile;

_no_recovery_through_resetlogs=TRUE

Shutdown the database and restart the database, performing the open resetlogs. After of execute this step removed the parameter from init.ora or spfile file.

HTH – Antonio NAVARRO

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s