oracle11g rac 修改spfile

jiawang

RAC环境下发现2个节点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文件重新命名即可启动数据库