What is Oracle Restart?
Oracle Restart contains a lot of components to be restarted automatically. Here we focus on the database.
The default policy of a RAC database is to automatically restore to its previous running condition. More accurately, the policy will try to keep the state of a database before and after reboot. Which means, a shutdown database before reboot will remain shutdown after reboot.
Let's see the current configuration of a RAC database by Oracle 19c Server Control (SRVCTL) Utility.
[oracle@primary01 ~]$ srvctl config database -d orclcdb
Database unique name: ORCLCDB
Database name: ORCLCDB
Oracle home: /u01/app/oracle/product/19.0.0/db_1
Oracle user: oracle
Spfile: +DATA/ORCLCDB/PARAMETERFILE/spfile.275.1053776653
Password file: +DATA/ORCLCDB/PASSWORD/pwdorclcdb.256.1053773741
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: oper
Database instances: ORCLCDB1,ORCLCDB2
Configured nodes: primary01,primary02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
Disable Auto Start
To disable automatic restart of a database, we can change its policy to MANUAL. For example:
[oracle@primary01 ~]$ srvctl modify database -d orclcdb -y manual
Or in long form:
[oracle@primary01 ~]$ srvctl modify database -database orclcdb -policy manual
Let's check the policy again.
[oracle@primary01 ~]$ srvctl config database -d orclcdb
...
Management policy: MANUAL
Please note that, changing policy to MANUAL will also change AUTO_START of the database resource to NEVER.
To revert it back to AUTOMATIC, you can do this:
[oracle@primary01 ~]$ srvctl modify database -d orclcdb -y automatic
Occasionally, you may also want to change the startup option of a RAC database by srvctl.
To make a RAC database in disabled mode for maintenance, you should go for the post: How Srvctl Disable Database?
Thanks for information.
I’m glad the solution is helpful.