oracle adg 启动报ORA-03113错误

今天，DB同事问我自己怎么配的adg启动不了啊

SQL> startup
ORACLE instance started.


Total System Global Area  993775616 bytes
Fixed Size    2259360 bytes
Variable Size  318768736 bytes
Database Buffers  666894336 bytes
Redo Buffers    5853184 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 11116
Session ID: 5 Serial number: 3

我一看alert日志，发现这家伙居然给单节点的dg陪了rac的方式，导致报rac错误

Errors in file /opt/app/oracle/diag/rdbms/fafa/FAFA/trace/FAFA_ora_11056.trc:
ORA-16038: log 1 sequence# 4 cannot be archived
ORA-00254: error in archive control string ''
ORA-00312: online log 1 thread 1: '/opt/app/oracle/oradata/FAFA/redo01.log'
ORA-15001: diskgroup "ARCH" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service

DB啊

在这里提醒大家VALID_FOR=(all_LOGFILES,all_roles)是rac dg的配置

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)才是单节点配置

修改pfile文件，指定这个pfile启动即可