重庆思庄Oracle、Redhat认证学习论坛

标题: oracle11g rac 修改spfile [打印本页]

作者: jiawang 时间: 2024-7-18 15:10
标题: oracle11g rac 修改spfile
本帖最后由 jiawang 于 2024-7-18 15:55 编辑

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文件重新命名即可启动数据库

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)