If standby databases are created with Enterprise Manager, they are not automatically registered to Oracle Restart. So we add it manually as follows.<\/p>\n
\u2022 If the Data Guard Environment is managed by the Broker, then the service is automatically started and the FAN ONS event is broadcast to the applications by the Broker itself, but if the Broker is not used, then this work is done with the help of Triggers.<\/p>\n
\u25cb STARTUP TRIGGER starts the service on the new Primary database.<\/p>\n
\u25cb The ROLE_CHANGE Trigger tells JDBC Clients to connect to the old Physical Standby instead of connecting to the Original Primary database.<\/p>\n
\u2022 In the broker, this process is managed completely automatically. The process steps are as follows.<\/p>\n
\u25cb When the failover process is completed and the old Physical Standby database becomes Primary, the Broker broadcasts the old Primary as down and the new Primary as a FAN event.<\/p>\n
\u25cb In applications using JDBC, OCI or ODP.NET as Oracle Client, clients are automatically connected to the new Primary database with Fast Connection Failover (FCF) configuration.<\/p>\n
\u2022 Let’s take a closer look at the Client Failover components.<\/p>\n
Connect Time Failover:<\/strong> It redirects failed connection requests to secondary listener.<\/p>\n
Transparent Application Failover:<\/strong> Allows the re-executing of failing SELECT statements, rollback of DML operations, and re-execution of ALTER SESSION statements by the application.<\/p>\n
Fast Application Notification:<\/strong> When the original primary database fails, it sends a notification to the applications.<\/p>\n
2. The status of the service is questioned.<\/p>\n
[oracle@primary1 ~]$ srvctl status service -d primary -s prmy\r\nService prmy is not running.\r\n<\/pre>\n
3. Since the service will be started from the operating system, we define the sh script at a location in the operating system.<\/p>\n
\t[oracle@primary1 ~]$ cd $ORACLE_HOME\r\n\t[oracle@primary1 db_1]$ pwd\r\n\t\/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n\t[oracle@primary1 db_1]$ cd bin\/\r\n\t[oracle@primary1 bin]$ vi StartupService.sh\r\n\t#!\/bin\/ksh\r\n\texport ORACLE_BASE=\/u01\/app\/oracle\r\n\texport ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/db_1\r\n\texport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\r\n\texport PATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH\r\n\texport TIMESTAMP=`date '+%y%m%d%H%M%s'`\r\n\texport LOGFILE=\/tmp\/StartupService_${TIMESTAMP}.log\r\n\t\r\n\techo \"Starting $0 at `date`\" > $LOGFILE\r\n\tHOSTNAME=`hostname | awk -F. '{print $1}'`\r\n\t\r\n\techo \"`date` : Starting prmy database service\" >> $LOGFILE\r\n\tsrvctl start service -d $DB_UNIQUE_NAME -s prmy -i $ORACLE_SID >> $LOGFILE 2>&1\r\n\techo \"`date` : Start of prmy database service complete\" >> $LOGFILE\r\n<\/pre>\n
4. We create Trigger that will start the service.<\/p>\n
\t[Primary-1] SQL> CREATE OR REPLACE TRIGGER manage_services_start after startup on database\r\n\t 2 \r\n\t 3 DECLARE\r\n\t 4 role VARCHAR(30);\r\n\t 5 BEGIN\r\n\t 6 SELECT DATABASE_ROLE INTO role FROM V$DATABASE;\r\n\t 7 IF role = 'PRIMARY' THEN\r\n\t 8 dbms_scheduler.create_job(\r\n\t 9 job_name=>'start_dbsvc',\r\n\t 10 job_type=>'executable',\r\n\t 11 job_action=>'<ORACLE_HOME>\/bin\/StartupService.sh',\r\n\t 12 enabled=>TRUE\r\n\t 13 );\r\n\t 14 END IF;\r\n\t 15 END;\r\n\t 16 \/\r\n\t\r\n\tTrigger created.\r\n<\/pre>\n
5. We check whether the trigger occurs on the Primary and Standby sides.<\/p>\n
\t[Primary-1] SQL> select TRIGGER_NAME from dba_triggers where lower(trigger_name) like '%manage_service%';\r\n\t\r\n\tTRIGGER_NAME\r\n\t------------------------------\r\n\tMANAGE_SERVICES_START\r\n\t\r\n\t\r\n\t[Physical-1] SQL> select TRIGGER_NAME from dba_triggers where lower(trigger_name) like '%manage_service%';\r\n\t\r\n\tTRIGGER_NAME\r\n\t------------------------------\r\n\tMANAGE_SERVICES_START\r\n<\/pre>\n
6. We restart the Primary database to see if the service has started in STARTUP.<\/p>\n
\t[oracle@primary1 bin]$ srvctl stop database -d primary\r\n\t\r\n\t[oracle@primary1 bin]$ srvctl status database -d primary\r\n\tInstance primary1 is not running on node primary1\r\n\tInstance primary2 is not running on node primary2\r\n\t\r\n\t[oracle@primary1 bin]$ srvctl start database -d primary\r\n\t\r\n\t[oracle@primary1 bin]$ srvctl status database -d primary\r\n\tInstance primary1 is running on node primary1\r\nInstance primary2 is running on node primary2<\/pre>\n
7. It is checked whether the service starts automatically or not.<\/p>\n
\t[oracle@primary1 bin]$ srvctl status service -d primary -s prmy\r\n\tService prmy is running on instance(s) primary1,primary2\r\n<\/pre>\n
8. It is checked whether the service is running in Physical Standby.<\/p>\n
\t[oracle@standby1 ~]$ srvctl status service -d standby -s physcl\r\n\tService physcl is not running.\r\n<\/pre>\n
9. We check whether the service starts automatically in Stanby by performing the switchover operation.<\/p>\n
10. We check the status of the services on the Primary and Standby side.<\/p>\n
\t[oracle@primary1 ~]$ srvctl status service -d primary -s prmy\r\n\tService prmy is not running.\r\n\t\r\n\t[oracle@standby1 ~]$ srvctl status service -d standby -s physcl\r\nService physcl is not running.<\/pre>\n
Could not understand why the service did not start. Will look again later.<\/p>\n