Automatic Storage Management (hereafter ASM) can be used for standby operation.
Standby operation
Create an ASM instance resource.
The ASM instance will not be monitored, but only started or stopped. If the ASM instance fails, an Oracle instance resource error will be detected, so userApplication will be switched to the standby node, and ongoing operations will never be disrupted.
For Oracle 11g R1, refer to "2.3.2.1 Environment configuration with Oracle 11g R1" and for Oracle 11g R2, refer to "2.3.2.2 Environment configuration with Oracle 11g R2".
Notes in the case of using ASM of Oracle 11g R1 in standby operation are as follows.
Creation and configuration of ASM instances
Operation node
The ASM instance and database are only created on the operating node. The standby nodes will only operate the database on the shared disk of the operating node.
Note
ASM instance name must begin with "+". The default name is "+ASM".
If multiple ASM instances are configured on one server, a different ASM instance name must be assigned for each ASM instance.
If multiple Oracle homes are configured on one server, a different Oracle instance name must be assigned for each Oracle home.
Create the Oracle ASM instance and the Oracle database. The relation between the ASM instance and the database should become 1:1.
ASM instance : database = 1:1
ASM instance : database = 1:n
The following figure shows an example that ASM instance : database = 1:2.
In mutual standby operation and N:1 standby operation, the relation between ASM instance and database should become 1:1 or 1:n on each userApplication.
Mutual standby
The following figure shows an example that ASM instance : database = 1:1 on each userApplication.
N:1 standby
The following figure shows an example that ASM instance : database = 1:2 on each userApplication.
See
Refer to the Oracle manual.
Standby node
Set up the standby nodes in the same configuration (directory creation, file copy, and links) as the operating node where the AMS instance and database are created.
Under $ORACLE_HOME/dbs
Under $ORACLE_BASE/admin/$ORACLE_SID
$ORACLE_BASE/admin/<ASM instance name>
$ORACLE_BASE/diag/asm
The access privilege to the directories and files must be also the same as that on the operating node.
If you set where archive log is output on the operating node, it is necessary to set the same on the standby nodes.
CSS on the standby node must be set and started by manually, though CSS on the operating node is set and started automatically while Oracle database is being created.
Note
If required files on the operating node are backed up in the tar format with "cloracpy"(refer to "4.4 cloracpy - Create Backup File for Oracle Database Setup") command, configuration information of the ASM instance will not be backed up. Copy the following file manually in the tar format:
$ORACLE_BASE/admin/<ASM instance name>
ASM initialization parameter check
Check if the disk group in which the Oracle database is created is set for the ASM instance initialization parameter "ASM_DISKGROUPS".
See
For the initialized parameter of the ASM instance, refer to the Oracle manual.
userApplication creation
When creating userApplication, create an ASM instance resource and Oracle instance resource. Register them in the same Oracle resource.
Information
For information on how to create ASM instance resource, refer to "2.2.7.1 Oracle Resource Creation and Registration".
The NULLDETECTOR attribute is automatically set to the flag of the ASM instance resource. This value cannot be changed.
Notes in the case of using ASM of Oracle 11g R2 in standby operation are as follows.
Supported Configurations
In order to use ASM of Oracle 11g R2, it is necessary to install Oracle Grid Infrastructure. When installing Oracle Grid Infrastructure, the composition which separates the installation user of Oracle Database and the installation user of Oracle Grid Infrastructure is supported. The composition which creating one user is not supported.
A different directory must be assigned respectively for an ORACLE_BASE of the installation user of Oracle Database and an ORACLE_BASE of the installation user of Oracle Grid Infrastructure.
Oracle Grid Infrastructure Installation and ASM instance, Oracle Database Creation
See "Appendix C Oracle Grid Infrastructure Installation and ASM instance, Oracle Database Creation" to install Oracle Grid Infrastructure and create ASM instance, Oracle Database.
Note
ASM instance name must begin with "+". The default name is "+ASM".
If multiple Oracle homes are configured on one server, a different Oracle instance name must be assigned for each Oracle home.
The relation between ASM instance and database should become 1:1 or 1:n.
ASM instance : database = 1:1
ASM instance : database = 1:n
The following figure shows an example that ASM instance : database = 1:2.
The following configuration of standby operation using Oracle ASM 11g R2 is supported.
1:1 standby
The following configuration of standby operation using Oracle ASM 11g R2 is not supported.
Cascade
Mutual standby
N:1 standby
Priority transfer
N:M standby
When using ASM of Oracle 11g R2 in standby operation, Oracle service resource is not available.
See
Refer to the Oracle manual.
Change Oracle Restart Settings
Execute the following command on each node with Grid user access privileges to set for Oracle Restart and the CSS(Cluster Services Synchronization) daemon to start when OS starts, and disable automatic startup of Oracle instances, Oracle listener, and ASM.
Component | Command |
Oracle Restart | crsctl enable has |
CSS | crsctl modify resource ora.cssd -attr "AUTO_START=always" |
ASM | srvctl disable asm |
Oracle listener | srvctl disable listener [-l <listener_name>] |
Oracle instance | srvctl disable database -d <db_unique_name> |
userApplication Create
When creating userApplication, create an ASM instance resource and Oracle instance resource. Register them in the same Oracle resource.
Information
For further details of registering ASM instance in a Oracle resource, refer to step 5 of "2.2.7.1 Oracle Resource Creation and Registration"
The NULLDETECTOR attribute is automatically set to the flag of the ASM instance resource. This value cannot be changed.
Note
Set up Grid user to ASM instance resource and Oracle listener resource, Oracle user to Oracle instance resource.
Set up the following script in PreOnlineScript of the ASM instance resource to start ASM after CSS started.
/opt/FJSVclora/sbin/cloracsswait <Grid user>
A disk group that is used for the ASM instance must not be mounted or unmounted manually. For the disk group is mounted, the following message might be output to the console when the ASM resource is activated, but no action needs to be taken.
ORA-15032: not all alterations performed
ORA-15017: diskgroup "diskgroup name" cannot be mounted
ORA-15030: diskgroup name "diskgroup name" is in use by another diskgroup