认真就输

今天在帮QQ群 朋友恢复数据库的时候遇到ORA-38856报错，报错信息如下：

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

报错的原因很简单，RAC到单机以resetlogs强制打开数据库

增加参数

_no_recovery_through_resetlogs=true

SQL> alter database open resetlogs;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------------------------------------
READ WRITE
数据库正常打开