现在可以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,
解决
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13337857/viewspace-738559/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13337857/viewspace-738559/