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博客

How to modify spfile path

最新文章