Configuring Oracle Database Services Through Role Based Services
You can automatically control the startup of Oracle database services on both the primary and standby Oracle databases by assigning a database role to each service.
An Oracle database service automatically starts when the Oracle database
starts if the Oracle database policy is set to AUTOMATIC
and if the
service role matches the current role of the database. In this case, the role for
the Oracle database is either in the primary or standby role as part of the Active
Data Guard configuration.
Configure services with the srvctl
utility identically on all
Oracle databases in the Data Guard configuration. The following example shows two
services created identically on both the primary and the standby Oracle databases.
See srvctl
add service in the Oracle Database Administrator's Guide.
The following steps add the primaryrole
and standbyrole
database services to both the primary and standby Oracle databases when the primary Oracle database is located in Austin and the standby Oracle database is located in Houston.