<<Back to Oracle RAC Main Page
How to Modify Database Startup Option Using srvctl
In this post I will show you, how you can modify the database startup option / Database startup mode in clusterware registry using srvctl.There are some time requirement to change the startup option (from default OPEN) to MOUNT, or "READ ONLY" eg if in case of Physical Standby Configuration
Let us Check the Current Configuration
$ srvctl config database -d ORCL
Database unique name: ORCL
Database name:
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_2
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfileORCL.ora
Password file: +DATA/ORCL/PASSWORD/pwORCL
Domain:
Start options: open
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: ORCL1,ORCL2,ORCL3
Configured nodes: node1,node2,node3
Database is administrator managed
Note:- In this case whenever I will restart my database (ORCL) by default it will try to open, being standby it will open in read_only. Which of course requires Active DataGuard License and we can definitely deactivate it by setting parameter "_query_on_physical"=FALSE. But still whenever will try to start the database by default it will try to open and through an error in case _query_on_physical is FALSE and leave the database in mount mode.
Modify the Database Startup Option from open to Mount
$ srvctl modify database -db ORCL -startoption MOUNT
Lets Check the Configuration Again
$ srvctl config database -d ORCL
Database unique name: ORCL
Database name:
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_2
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfileORCL.ora
Password file: +DATA/ORCL/PASSWORD/pwORCL
Domain:
Start options: mount
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: ORCL1,ORCL2,ORCL3
Configured nodes: node1,node2,node3
Database is administrator managed
Database unique name: ORCL
Database name:
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_2
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfileORCL.ora
Password file: +DATA/ORCL/PASSWORD/pwORCL
Domain:
Start options: mount
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: ORCL1,ORCL2,ORCL3
Configured nodes: node1,node2,node3
Database is administrator managed
Comments
Post a Comment