编辑位于 asm 里面的spfile

如果因为参数设置不正确造成根据 spfile 里面的错误参数不能启动, 根据alert log 里面启动的提示信息,编辑一个pfile,然后启动

SQL> startup pfile='/u01/app/oracle/product/19.0.0/db_1/dbs/initorcl.ora';
ORACLE instance started.

Total System Global Area 5.3687E+10 bytes
Fixed Size		   30395824 bytes
Variable Size		 6576668672 bytes
Database Buffers	 4.6976E+10 bytes
Redo Buffers		  103821312 bytes
Database mounted.
Database opened.
SQL> 

创建一个spfile,位置根据alert log 里面的信息

SQL> create spfile='+data3/orcl/parameterfile/spfile' from pfile='/u01/app/oracle/product/19.0.0/db_1/dbs/initorcl.ora';

File created.

使用新的spfile进行启动

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 5.3687E+10 bytes
Fixed Size		   30395824 bytes
Variable Size		 6576668672 bytes
Database Buffers	 4.6976E+10 bytes
Redo Buffers		  103821312 bytes
Database mounted.
Database opened.
SQL> 

如果路径需要改变,使用下面的命令:
srvctl modify database -d racdb -p +<New_DiskGRP>//spfile.ora

姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页