HP Serviceguard Toolkits for Database Replication Solutions manual

The Oracle database is started using the ECMT Oracle toolkit. The Data Guard processes are then started using the ODG toolkit, after which, the application is monitored.

If either the Oracle database or any of the Data Guard processes fail, the package fails over because the Oracle database and the Data Guard are integrated in a single package.

NOTE: You must create separate packages for each primary and standby database because the primary database and all the standby databases are configured in separate clusters.

Configuring an ODG toolkit involves two scenarios:

1.If a customer already has an existing ECMT Oracle toolkit package configured and wants to convert the Oracle database into a Data Guard setup:

•If the ECMT Oracle package is a legacy-style package, halt and discard the package. Create a new package using both ECMT Oracle toolkit module and ODG toolkit module. This is because the ODG toolkit does not support Legacy packaging.

cmmakepkg –m ecmt/oracle/oracle –m tkit/dataguard/dataguard <pkg_file_name>

•If the ECMT Oracle package is a modular-style package, first halt the package, and then insert Data Guard module using the following command:

cmmakepkg –i <pkg_ascii_file> -m <module_file_name> <output_file_name>

where:

◦pkg_ascii_file is the package file of the existing ECMT Oracle package. This can be generated using the command cmgetconf –p <pkg_name> <pkg_ascii_file>

◦module_file_name is the name of the module to be included in the running package. In case of Data Guard package, it's value is tkit/dataguard/ dataguard.

◦output_file_name is the template file that gets generated with the values of the ECMT Oracle database module populated in it. The user must edit this file and enter values for the Data Guard specific package attributes, and then apply the package using the cmapplyconf command.

•Re-apply the package after editing the Package Configuration file, and then run the newly applied package using cmrunpkg command.

2.If you do not have an ECMT Oracle package running and want to create a fresh Data Guard package, use the following command to create a package:

cmmakepkg –m ecmt/oracle/oracle –m tkit/dataguard/dataguard <pkg_file_name>

where:

•ecmt/oracle/oracle is the Oracle toolkit module shipped with ECMT Oracle toolkit.

•tkit/dataguard/dataguard is the Data Guard toolkit module shipped with the ODG toolkit.

•pkg_file_name is the template file that is generated. You must edit this file and enter values for the ECMT Oracle specific package attributes and the Data Guard specific package attributes. To create the package apply the file using cmapplyconf command.

8Serviceguard toolkit for Oracle Data Guard