G.3.2 Oracle database Control (Scalable Operation with Oracle RAC)

This section describes startup, shutdown and monitoring of Oracle resources in scalable operation with Oracle RAC using Oracle Data Guard/Oracle Active Data Guard.

Oracle RAC instance startup

Startup procedure of an Oracle RAC instance is as follows:

su - <Oracle user>
srvctl stop instance -d $DB_NAME -i $ORACLE_SID
srvctl start instance -d $DB_NAME -i $ORACLE_SID -o mount
The procedure according to the database role is executed.
- Primary Database
  ALTER DATABASE OPEN;
- Physical Standby Database
  - ReceiveOnly
    No procedure.
  - NormalApply
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING ARCHIVED LOGFILE DISCONNECT;
  - RealTimeApply
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
  - ReadOnlyOPEN
    ALTER DATABASE OPEN;
  - RealTimeQueryN
    ALTER DATABASE OPEN;
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING ARCHIVED LOGFILE DISCONNECT;
  - RealTimeQueryR
    ALTER DATABASE OPEN;
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
- Logical Standby Database
  The procedure according to the REDOApply of the Oracle instance resource is executed.
  - ReceiveOnly, ReadOnlyOPEN, RealTimeQueryN, RealTimeQueryR
    ALTER DATABASE OPEN;
  - NormalApply
    ALTER DATABASE OPEN;
    ALTER DATABASE START LOGICAL STANDBY APPLY;
  - RealTimeApply
    ALTER DATABASE OPEN;
    ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
- Snapshot Standby Database
  ALTER DATABASE OPEN;

Oracle RAC instance shutdown

Shutdown procedure of an Oracle RAC instance is as follows:

Shutdown procedure of an Oracle RAC instance by user operation is as follows:
1. su - <Oracle user>
2. When the roll is PHYSICAL STANDBY or LOGICAL STANDBY, stop REDO apply.
  - Physical Standby Database
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
  - Logical Standby Database
    ALTER DATABASE ABORT LOGICAL STANDBY APPLY;
3. srvctl stop instance -d $DB_NAME -i $ORACLE_SID
Shutdown procedure of an Oracle instance by resource failure or failover is as follows:
1. su - <Oracle user>
2. srvctl stop instance -d $DB_NAME -i $ORACLE_SID

Monitoring Oracle RAC instance

Monitoring of the Oracle RAC is same as that of Oracle instance in the standby operation, except for the following points. For details, see "G.3.1 Oracle database Control (Standby Operation)"

Monitoring interval (Interval)
The default value of monitoring interval for the background processes (PMON, SMON, DBWn, LGWR, CKPT) is 60 seconds.
Oracle RAC instance errors and recovery
- If Oracle RAC instance errors are detected, PRIMECLUSTER Wizard for Oracle notifies RMS of the warning state and waits for Oracle RAC resources to be restarted by Oracle Clusterware.
- Oracle Clusterware automatically restart Oracle RAC resources if they fail.
- If Oracle Clusterware cannot restart them within a set time of "Interval", PRIMECLUSTER Wizard for Oracle notifies RMS of the Fault state and stops Oracle RAC instances. For details about "Interval", see "2.3.5 userApplication with Oracle RAC Instances and Listeners".
Monitoring PDB
PDB is not monitored.

Listener startup, shutdown and monitoring

Startup, shutdown and monitoring of listeners are same as does not use Oracle Data Guard. For details, see "3.1.2 Scalable Operation with Oracle RAC".