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

来源：互联网发布：java中怎么求绝对值编辑：程序博客网时间：2024/05/16 05:02

将rac的备份拷贝到一台单机上进行恢复，当open resetlog数据库的时候报错：

SQL> 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

经查：

Oracle bug, 4355382 ORA-38856: FAILED TO OPEN DATABASE WITH RESETLOGS WHEN USING RAC BACKUP, exists in the
Oracle 10g release 2.0 that affects backups taken from a RAC database. The problem is related to the number of threads
used by the source database and an expectation that the cloned database must have an identical number of threads.
Solution:
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.

0 0