F.2 Oracle Environment Setting

This section explains construction procedures the primary site and the standby site of Oracle Data Guard/Oracle Active Data Guard on the cluster system by using PRIMECLUSTER Wizard for Oracle.

Configuration Procedure

Configuration procedures depend on whether Oracle ASM is used. Configure it by the following procedures according to your environment.

Primary Site
Configure the primary site referring to "2.2 Standby Operation".
Standby Site
Configure the primary site referring to "2.2 Standby Operation". Configuration of the standby database depend on whether Oracle ASM is used.
- Oracle ASM not used
  Configure the standby database from the primary database referring to "2.2.6 Oracle Database Creation and Setting" and Oracle Database manual.
- Oracle ASM used
  Configure the standby database from the primary database referring to the step "8" of "Appendix C Oracle Grid Infrastructure Installation and Oracle ASM instance, Oracle Database Creation" and Oracle Database manual.

Setting of REDO Apply

Setting of REDO Apply on the standby database can be set at the step "7" of "2.2.7.1 Oracle Resource Creation and Registration". This setting is disregarded in the Oracle ASM instance resource and Oracle instance resource of primary database and Oracle instance resource without Oracle Data Guard. The setting of redo apply can be set at the attributes of "REDOApply". The default of "REDOApply" is "NormalApply".

The setting of attributes "REDOApply"	Description
ReceiveOnly	The standby database is started, and the REDO apply is not started.
NormalApply *Default	In the case of physical standby database, the physical standby database is started, and the REDO apply is started. In the case of logical standby database, the logical standby database is started, and the SQL apply is started. In the case of snapshot standby database, this setting is disregarded. (It is similar to ReceiveOnly.)
RealTimeApply	In the case of physical standby database, the physical standby database is started, and the REDO apply with the real-time apply feature is started. In the case of logical standby database, the logical standby database is started, and the SQL apply with the real-time apply feature is started. In the case of snapshot standby database, this setting is disregarded. (It is similar to ReceiveOnly.)
ReadOnlyOPEN	In the case of physical standby database, the physical standby database is started to "READ ONLY OPEN" status, and the REDO apply is not started. In the case of logical standby database and snapshot standby database, this setting is disregarded. (It is similar to ReceiveOnly.)
RealTimeQueryN	In the case of physical standby database, the physical standby database is started to "READ ONLY OPEN" status, and the real-time query feature is enabled. (The REDO apply is started.) In the case of logical standby database and snapshot standby database, this setting is disregarded. (It is similar to ReceiveOnly.) This setting is enabled in Oracle Active Data Guard environment.
RealTimeQueryR	In the case of physical standby database, the physical standby database is started to "READ ONLY OPEN" status, and the real-time query feature is enabled. (The REDO apply with the real-time apply feature is started.) In the case of logical standby database and snapshot standby database, this setting is disregarded. (It is similar to ReceiveOnly.) This setting is enabled in Oracle Active Data Guard environment.

The setting of attributes "REDOApply" can be set on the "Detail setting for Oracle instance" screen.

Setting menu : Detail setting for Oracle instance
1) HELP                                10) Interval=30
2) NO-SAVE+RETURN                      11) WatchTimeout=300
3) SAVE+RETURN                         12) REDOApply=NormalApply
4) OracleUser=oracle                   13) (PreOnlineScript=)
5) StartTimeout=600                    14) (PostOnlineScript=)
6) StopTimeout=180                     15) (PreOfflineScript=)
7) AbortTimeout=60                     16) (PostOfflineScript=)
8) StopModeStop=immediate              17) (FaultScript=)
9) StopModeFail=abort                  18) (Flags=)
Choose the setting to process: 12