Oracle RAC pfile 변경

ORACLE RAC pfile 변경 

 

- pfile 생성 

• DB가 Down 된 상태에서도 가능

create pfile='/oracle/product/19c/dbs/spfilebkp_initORCL1.ora' from spfile;
create pfile='/oracle/product/19c/dbs/spfilebkp_initORCL2.ora' from spfile;

 

- Database Config 설정 확인 

• Spfile 항목을 Null 처리
• Spfile 항목을 Null처리하면 $ORACLE_HOME/dbs 경로에 있는 pfile을 바라보게 되므로 pfile로 운용가능

$ su - oracle
$ srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /oracle/product/19c
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.257.1185996883
Password file: +DATA/ORCL/PASSWORD/pwdorcl.265.1185996027
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: DATA
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: dba
Database instances: ORCL1,ORCL2
Configured nodes: test-oradb01,test-oradb02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services: 
Database is administrator managed

 

- pfile 변경 

srvctl modify database -d orcl -p '';

- DB 재기동 

-- Database 중지
srvctl stop database -d orcl

-- Database 기동
srvctl start database -d orcl