Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1
Information in this document applies to any platform.
RMAN-06136: ORACLE error from auxiliary database:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
The target database is a RAC two node database being duplicated to a single instance database.
ORA-38856 is the expected error during open database resetlogs when the set of enabled instances (redo threads) in the controlfile does not match the set of enabled instances (redo threads) in datafile checkpoint. This is expected behavior in a normal RAC restore/recover/open resetlogs situation.
However, in a cloning scenario where, once the clone database is opened with resetlogs you would never expect to restore the old (RAC) backup , this check doesnt matter.
1.Set the following parameter in the auxiliary init.ora file:
Then open with resetlogs;
Once the auxiliary has opened, removed this hidden parameter.