3 Tools and Utilities

NetBackup Client Setup

The following tasks describe how to set up a NetBackup Client.

1. Create a new class on the VERITAS NetBackup server to back up the Oracle E-Business Suite Certified Configuration server file systems.

2. Create a schedule for the Oracle E-Business Suite Certified Configuration server file system backup.

3. Log in as the root user.

4. Open the /usr/openv/netbackup/bp.conf file using the following commands:

   # cd /usr/openv/netbackup
   # vi bp.conf
   
   

5. Add the following lines to specify the values for the client:

   VERBOSE=99
   BPBACKUP_CLASS=BPBACKUP_CLASS
   BPBACKUP_SCHED=BPBACKUP_SCHED
   FSBACKUP_CLASS=FSBACKUP_CLASS
   FSBACKUP_SCHED=FSBACKUP_SCHED
   SERVER=SERVER
   CLIENT_NAME=CLIENT_NAME
   
   

   The values are the variables that were determined for the environment. The following is an example:

   VERBOSE=99
   BPBACKUP_CLASS=Oracle_tst
   BPBACKUP_SCHED=Oracle
   FSBACKUP_CLASS=Appl_tst
   FSBACKUP_SCHED=Appliance
   SERVER=bkupsrv.us.oracle.com
   CLIENT_NAME=ebizcc.us.oracle.com
   
   

Hot Backup Script

The /mount_point/oracle/admin/SID/scripts/hbk directory contains the oracle_hot_backup.sh script. You must run the script as the oracle user, ormount_point.

If any errors occur, then the script sends an e-mail message to the system administrator. In order for the system administrator to receive e-mail messages, update the e-mail address in the oracle_hot_backup.sh script with the system administrator’s e-mail address. The default e-mail address is System.Administrator@oracle.com, and it occurs seven times in the script.

This script performs a hot backup of the data files, redo logs, control files, archive logs, and initSID.ora file of the 11i database in the mount_point environment to the /mount_point/backup directory. It will generate the error and log files in the /mount_point/oracle/admin/SID/scripts/hbk directory.

You can schedule the hot backups to run on a regular basis. The following tasks describe how to setup the schedule:

1. Log in as the root user.

2. Open the crontab file in an editor.

3. Add the following line to the crontab file:

   0 0 * * * /mount_point/oracle/admin/SID/scripts/hbk/oracle_hot_backup.sh
   
   

   In the preceding command, the hot backup is scheduled to run at midnight.

VERITAS NetBackup for Oracle Recovery Manager

The following tasks describe how to run an Oracle Recovery Manager (RMAN) script to perform a database backup on the Oracle E-Business Suite Certified Configuration:

1. Set the following the environment variables for the client that will run the backup:

   NB_ORA_SERV=backup server
   NB_ORA_CLASS=Oracle class
   NB_ORA_SCHED=Oracle schedule
   
   

   An example of the settings is as follows:

   NB_ORA_SERV=congee.us.oracle.com
   NB_ORA_CLASS=Oracle_tst
   NB_ORA_SCHED=Oracle
   
   

2. Run a few file system backups to ensure the client is properly registered on the server.

3. Verify that you set the following environment variables:

   • ORACLE_HOME

   • ORACLE_SID

   • NB_ORA_CLASS

   • NB_ORA_SCHED

   • NB_ORA_SERV

4. Perform a database backup using the RMAN script. The following is an example of the rman script:

        run {
                allocate channel t1 type 'SBT_TAPE';
                backup database;
               }
   
   

   The preceding example backs up the entire database to the VERITAS Netbackup server.

   
   

   Note: Specify the channel type as SBT_TAPE or tape in order to send the backups to the server.

   
   

5. Save the script as x.rman.

6. Run the x.rman script using the following command:

   $ORACLE_HOME/bin/rman nocatalog target user/password with sysdba \
   privs cmdfile path/x.rman