How to Prevent Automatic Restart of a Database by SRVCTL

  • by

Oracle Automatic Restart contains a lot of components to be restarted. 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

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

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.

Leave a Reply

Your email address will not be published. Required fields are marked *