RAC ORA-16019 报错

报错信息:

[ grid@dominic1 ~]$ srvctl start database -d dominic 
PRCR-1079 : Failed to start resource ora.dominic.db 
CRS-5017: The resource action "ora.dominic.db start" encountered the following error: 
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST 
. For details refer to "(:CLSN00107:)" in "/dba/app/11.2/grid/log/dominic2/agent/crsd/oraagent_oracle/oraagent_oracle.log". 

CRS-5017: The resource action "ora.dominic.db start" encountered the following error: 
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST 
. For details refer to "(:CLSN00107:)" in "/dba/app/11.2/grid/log/dominic1/agent/crsd/oraagent_oracle/oraagent_oracle.log". 

CRS-2674: Start of 'ora.dominic.db' on 'dominic2' failed 
CRS-2674: Start of 'ora.dominic.db' on 'dominic1' failed 
CRS-2632: There are no more servers to try to place resource 'ora.dominic.db' on that would satisfy its placement policy

通过此报错可以知道, 是归档路径出现错误:

 

  查看LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST 是不能共存的.  

  但是log_archive_dest_n  和 log_archive_dest  在一次迁移的时候,确实可以的.  估计是当时归档路径的时候 设置了错误.引起, 最后解决的方法是:

1 :  在oracle 用户的家目录下$ORACLE_HOME/dbs 找到参数文件,查看 对应共享存路径位置:

oracle@dominic1 dbs]$ cat initdominic1.ora 
SPFILE='+DATA/dominic/spfiledominic.ora'

2 :  到处spfile 文件到本地目录 编辑:

 通过CP 命令 

3 :  创建 spfile参数到共享存储 (  在这里,如果建在某个节点本地, 那么另一个节点是不能共享,打不开的)

create spfile='+DATA/dominic/spfiledominic.ora' from pfile='/dba/app/oracle/pfile_s'

4 : 启动库:  srvctl start database -d dominic

5 : ok 了!