RAC修改spfile位置

测试环境内存不够用,调整参数存在问题,导致DB无法启动,重新创建好的spfile,修改rac指定的实例位置。

测试环境内存不够用,减少SGA内存大小
SQL>alter system set sga_max_size=600m scope=spfile sid='*';
$ srvctl stop database -d orcl
$ srvctl start database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5017: The resource action "ora.orcl.db start" encountered the following error: 
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u03/app/oracle/product/19.0.0/db_1/dbs/initorcl1.ora'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/d1/crs/trace/crsd_oraagent_oracle.trc".

2020-04-16 19:15:14.302 :CLSDYNAM:3349079808: [ora.orcl.db]{2:15568:806} [check] ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4376
Additional information: -892012805
Process ID: 0
Session ID: 0 Serial number: 0

$ srvctl config database -d orcl
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.277.1036700589

SQL>create pfile='/tmp/pfile.ora' from spfile='+DATA/ORCL/PARAMETERFILE/spfile.277.1036700589';
*.sga_max_size=629145600
#*.sga_target=1130m

SQL>create spfile='+DATA/ORCL/PARAMETERFILE/spfile.ora' from pfile='/tmp/pfile.ora';
ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   APR 16 19:00:00  N    spfile.ora => +DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.277.1037908227

$ srvctl modify database -d orcl -spfile '+DATA/ORCL/PARAMETERFILE/spfile.ora'
$ srvctl config database -d orcl |grep spfile
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.ora
原文地址:https://www.cnblogs.com/lvcha001/p/12711770.html