PRIMECLUSTER Wizard for Oracle (PRIMEQUEST) 4.3 Configuration and Administration Guide

F.4.4 Converting a Physical Standby Database into a Snapshot Standby Database

The transition figure that converting a physical standby database into a snapshot standby database on standby site is as follows.

Note

• This operation is executed only on the standby site. The operation on the primary site is not necessary.

1. Initial status.

   

2. Start maintenance mode of PRIMECLUSTER.

   To prevent the failover that userApplication does not intend, start the maintenance mode of PRIMECLUSTER on the operation node of standby site.

   # /opt/SMAW/SMAWRrms/bin/hvutil -M on

   Confirm that the state of userApplication becomes “Maintenance".

   

3. Monitoring disruption of Oracle resource.

   To kill the session to Oracle, stop monitoring the Oracle instance and Listener resources on the both nodes of standby site.

   # /opt/FJSVclora/sbin/hvoradisable -a <userApplication>

   Confirm that stop of monitoring have been successfully done.
   (Refer to note of "4.1 hvoradisable - Discontinue Monitoring Resources".)

   

4. Converting roll of Oracle Data Guard.

   The procedure that converting roll of Oracle Data Guard is as follows.

   See

   For further details, refer to the Oracle Database manual.

   1. Stop Redo Apply, if it is active.

      SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

   2. Mount the standby database, if it is not mounted.

      SQL> SHUTDOWN IMMEDIATE
      SQL> STARTUP MOUNT

   3. Perform the conversion.

      SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

   4. Restart the standby database.

      SQL> SHUTDOWN IMMEDIATE
      SQL> STARTUP

      After the roll is converted, it becomes the following.

      

5. Restart Oracle resource monitoring.
   Start monitoring the Oracle instance and Listener resources on the both nodes of standby site.

   # /opt/FJSVclora/sbin/hvoraenable -a <userApplication>

   Confirm that restart of monitoring have been successfully done on standby site.
   (Refer to note of "4.2 hvoraenable - Restart Monitoring Resources".)

   

6. Stop maintenance mode of PRIMECLUSTER.

   Stop the maintenance mode of PRIMECLUSTER on the operation node of standby site.

   # /opt/SMAW/SMAWRrms/bin/hvutil -M off

   Confirme the state of userApplication becomes "Online" or "Offline".