ORA-38856: Unable to mark instance unnamed_instance_2 (Redo thread 2) as Enabled

In doing offsite recovery database test, the error ORA 38856, the specific situation is as follows:

1. Source Library is Oracle rac,2 node database version 11.2.0.4

2. Target library for single-instance Oracle, version 11.2.0.4

3. Source Repository Rman Backup is level 0 fully prepared

After the success of restore, recover unsuccessful, need to use the original online log, rebuild the control file,

Then ALTER DATABASE open Resetlogs, error

sql> ALTER DATABASE Open Resetlogs;alter database open resetlogs* 1th line error: ORA-38856: Unable to unnamed_instance_2 instance (Redo thread 2) Mark as Enabled

is a bug:

Oracle Bug, 4355382 ora-38856:failed to OPEN DATABASE with Resetlogs if USING RAC BACKUP, exists in the

Oracle 10g Release 2.0 This affects backups taken from a RAC database. The problem is related to the number of threads

Used by the source database and a expectation that the cloned database must has an identical number of threads.

Solutions

1. Set The following parameter in the auxiliary Init.ora file: _ no_recovery_through_resetlogs=true.2. Open the database in Resetlogs mode.3. Remove _no_recovery_through_resetlogs=true from Init.ora.4. Restart database.

This article is from the "Database Road" blog, make sure to keep this source http://dbaway.blog.51cto.com/7099215/1697030

ORA-38856: Unable to mark instance unnamed_instance_2 (Redo thread 2) as Enabled