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

3.2.3 Backup

This section discusses how to backup Oracle databases.

3.2.3.1 Cold backup

You can perform Oracle database cold backup (offline backup) as follows. If there are Oracle database -dependent resources (e.g. SAP R/3), a resource failure might occur during Oracle database stop, so it is necessary to stop them manually in advance.

1. Maintenance mode / Monitoring disruption

   # /opt/SMAW/SMAWRrms/bin/hvutil -m on <userApplication> (Maintenance mode)
   # /opt/FJSVclora/sbin/hvoradisable -a <userApplication>(Monitoring disruption)

2. Confirmation of maintenance mode and stop of monitoring

   Confirm that changing into maintenance mode and stop of monitoring have been successfully done.

   (Refer to note of "4.1 hvoradisable - Discontinue Monitoring Resources".)

3. Oracle database stop

   # su - <Oracle user>
   $ sqlplus /nolog
   SQL> connect / as sysdba
   SQL> shutdown immediate

4. Cold backup

   Perform cold backup of the database.

5. Oracle database startup

   # su - <Oracle user>
   $ sqlplus /nolog
   SQL> connect / as sysdba
   SQL> startup

6. Monitoring restart / Maintenance mode stop

   # /opt/FJSVclora/sbin/hvoraenable -a <userApplication> (Monitoring restart)
   # /opt/SMAW/SMAWRrms/bin/hvutil -m off <userApplication> (Maintenance mode stop)

7. Confirmation of restart of monitoring and maintenance mode

   Confirm that restart of monitoring and changing out of maintenance mode has been successfully done.

   (Refer to note of "4.2 hvoraenable - Restart Monitoring Resources".)

3.2.3.2 Hot backup

You can perform Oracle database hot backup (online backup) as follows.

1. Maintenance mode / Monitoring disruption

   # /opt/SMAW/SMAWRrms/bin/hvutil -m on <userApplication> (Maintenance mode)
   # /opt/FJSVclora/sbin/hvoradisable -a <userApplication> (Monitoring disruption)

2. Confirmation of maintenance mode and stop of monitoring

   Confirm that changing into maintenance mode and stop of monitoring have been successfully done.

   (Refer to note of "4.1 hvoradisable - Discontinue Monitoring Resources".)

3. Hot backup

   Perform hot backup of the database.
   Be sure to check that the Oracle instance and Listener are properly running before going on to the next step.

4. Monitoring restart / Maintenance mode stop

   # /opt/FJSVclora/sbin/hvoraenable -a <userApplication> (Monitoring restart)
   # /opt/SMAW/SMAWRrms/bin/hvutil -m off <userApplication> (Maintenance mode stop)

5. Confirmation of restart of monitoring and maintenance mode

   Confirm that restart of monitoring and changing out of maintenance mode has been successfully done.

   (Refer to note of "4.2 hvoraenable - Restart Monitoring Resources".)