今天一套环境，发现2个节点的spfile不一致，正好有停机时间就修改spfile配置
SYS@orcl1> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl1.ora
SYS@orcl1> create pfile='/tmp/pfileorcl1.ora' from spfile;
File created.
SYS@orcl1> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
YS@orcl1> startup pfile='/tmp/pfileorcl1.ora'
ORACLE instance started.
Total System Global Area 3.2068E+10 bytes
Fixed Size 2269072 bytes
Variable Size 5301600368 bytes
Database Buffers 2.6642E+10 bytes
Redo Buffers 122351616 bytes
Database mounted.
Database opened.
SYS@orcl1> create spfile='+DATA' from pfile='/tmp/pfileorcl1.ora';
SYS@orcl1> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl1> startup; --无法直接启动
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl1.ora'
SYS@orcl1>
通过asmcmd -p登录环境查看spfile的目录：
+DATA/ORCL/PARAMETERFILE/spfile.430.1170258117
首先把/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl1.ora文件重新命名。用oracle用户修改配置
orcl1:/home/oracle@db1> srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: DATADG,FRA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
orcl1:/home/oracle@db1> srvctl modify database -d orcl -p '+DATA/ORCL/PARAMETERFILE/spfile.430.1170258117'
orcl1:/home/oracle@db1> srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.430.1170258117
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: DATADG,FRA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
orcl1:/home/oracle@db1> srvctl start instance -d orcl -i orcl1
orcl1:/home/oracle@db1> export ORACLE_SID=orcl1
orcl1:/home/oracle@db1> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 29 15:46:09 2024
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@orcl1> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl1> startup;
ORACLE instance started.
Total System Global Area 3.2068E+10 bytes
Fixed Size 2269072 bytes
Variable Size 5301600368 bytes
Database Buffers 2.6642E+10 bytes
Redo Buffers 122351616 bytes
Database mounted.
Database opened.
SYS@orcl1>
节点二直接把/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl2.ora文件重新命名即可启动数据库