oracle集群管理-rac参数文件错误处理

1 从磁盘组中的spfile生成一个pfile

SQL> create pfile from spfile='+DGDATA1/orcl/PARAMETERFILE/spfile.256.1028992457';

2 修改不当得参数

cd $ORACLE_HOME/dbs
vi initorcl.ora
修改操作不当得参数。

3 按照pfile启动数据库到mount并生成新的spfile

[oracle@orclrac01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 20 14:47:06 2020
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount pfile='/u01/app/oracle/product/19.3/db_1/dbs/initorcl1.ora';
ORACLE instance started.

Total System Global Area 3.7581E+11 bytes
Fixed Size                 30159800 bytes
Variable Size            3.7044E+10 bytes
Database Buffers         2.5233E+11 bytes
Redo Buffers              506707968 bytes
In-Memory Area           8.5899E+10 bytes
Database mounted.
SQL> create spfile='+DGDATA1' from pfile;

File created.

SQL> 

4 查看数据库配置信息

[grid@orclrac01 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/19.3/db_1
Oracle user: oracle
Spfile: +DGDATA1/orcl/PARAMETERFILE/spfile.348.1030200507
Password file: +DGDATA1/orcl/PASSWORD/pwdorcl
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: REDO,DGDATA1
Mount point paths: 
Services: orclapp
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2
Configured nodes: orclrac01,orclrac02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services: 
Database is administrator managed‘

5 启动数据库

[grid@orclrac01 ~]$ srvctl start database -d orcl