How to modify spfile path-优快云博客

本文详细介绍了如何使用Oracle数据库实例配置与参数调整的方法，包括创建SPFILE、修改PFILE、实例启动与关闭等关键步骤，以及通过SQL命令查看与设置参数文件，确保数据库高效运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1

create spfile='+sysdg/ANALYDB/spfileanalydb.ora' from pfile='/oracle/admin/analydb/pfile/init.ora.222014171919';

rm /oracle/product/11.2.0.3/db_1/dbs/spfileanalydb_1.ora

2

SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/product/11.2.0.3/db_1/
dbs/spfileanalydb_1.ora
create pfile='/home/oracle/qq.ora' from spfile;

SQL> startup pfile='/home/oracle/qq.ora' force;
alter system set spfile='+SYSDG/analydb/spfileanalydb.ora';
ORACLE instance started.

Total System Global Area 8.0973E+10 bytes
Fixed Size 2237088 bytes
Variable Size 1.2080E+10 bytes
Database Buffers 6.8719E+10 bytes
Redo Buffers 171511808 bytes
Database mounted.
Database opened.
SQL>
System altered.

SQL> SQL> SQL> SQL> SQL> SQL> SQL>
SQL>
SQL>
SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +SYSDG/analydb/spfileanalydb.o
ra

3
srvctl modify database -d analydb -p '+SYSDG/analydb/spfileanalydb.ora';
grid@ossoipltedb7 oracle]$ srvctl config database -d analydb -a
Database unique name: analydb
Database name: analydb
Oracle home: /oracle/product/11.2.0.3/db_1
Oracle user: oracle
Spfile: +SYSDG/analydb/spfileanalydb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: analydb
Database instances:
Disk Groups: SYSDG,FRADG,DATADG
Mount point paths:
Services: analydbsr
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: analydb
Candidate servers: ossoipltedb7,ossoipltedb8
Database is enabled
Database is administrator managed

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-1150556/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-1150556/