現在可以open了，因為日誌檔案不能複製，所以只能強制resetlogs了。

alter database open resetlogs報錯，

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

繼續百度下，解決，轉載下面的內容

Details:

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.

修改pfile檔案，加上 _ no_recovery_through_resetlogs引數，再次open resetlogs，

解決

oracle 10g rac轉成單機4

相關文章