Veritas NetBackup™ for Informix Administrator's Guide

Last Published:
Product(s): NetBackup (8.3.0.1, 8.3, 8.2, 8.1.2)
  1. Introduction to NetBackup for Informix
    1.  
      Features of NetBackup for Informix
    2.  
      About NetBackup for Informix
    3.  
      About NetBackup for Informix terms
    4.  
      Example NetBackup for Informix configuration
    5.  
      About the Informix ON-bar utility and library
    6.  
      How NetBackup for Informix works
  2. Installing NetBackup for Informix
    1.  
      Planning the installation of NetBackup for Informix
    2.  
      Verifying the operating system and platform compatibility
    3.  
      NetBackup server and client requirements
    4.  
      Informix server software requirements
    5.  
      About the license for NetBackup for Informix
    6.  
      Specifying the Informix home path
    7.  
      Adding new Informix instances
  3. Configuring NetBackup for Informix
    1.  
      About configuring NetBackup for Informix
    2. About configuring a backup policy for Informix
      1.  
        Adding a new NetBackup for Informix policy
      2.  
        About policy attributes
      3.  
        Configuring an application backup schedule
      4.  
        Configuring automatic backup schedules
      5. About schedule properties
        1.  
          NetBackup for Informix backup types
        2.  
          Example application backup schedule
        3.  
          Example automatic backup schedule
      6.  
        Adding clients to a policy
      7.  
        Adding NetBackup for Informix scripts to the backup selections list
      8.  
        Rules for NetBackup for Informix scripts
      9.  
        Configuring a Standard policy for backup of the $INFORMIXDIR/etc files
    3. About NetBackup for Informix scripts
      1.  
        Modifying NetBackup for Informix scripts
      2.  
        About NetBackup for Informix environment variables
    4.  
      Configuring an additional bp.conf file
    5.  
      About permissions for NetBackup for Informix log files
    6.  
      Reviewing the auto-discovered mappings in Host Management
    7.  
      Configuring the Maximum jobs per client
    8.  
      Performing a manual backup
  4. Performing backups and restores of Informix
    1.  
      About using NetBackup for Informix
    2.  
      About Informix ON-Bar backup types
    3.  
      Example Informix backup strategy
    4.  
      Automatic backup policy for Informix
    5.  
      Manual backup policy for Informix
    6.  
      Using the onbar command to perform a user-directed backup
    7.  
      About browsing Informix backups
    8.  
      Restoring files to the original client
    9.  
      Redirecting an Informix restore to a different client
    10.  
      Example restore of an Informix database
  5. Troubleshooting
    1.  
      Verifying the NetBackup for Informix configuration
    2.  
      Verifying NetBackup for Informix log files
    3.  
      Enabling the debug logs manually
    4. About the NetBackup for Informix log files
      1.  
        About the bphdb directory on the database client
      2.  
        About the infxbsa directory on the database client
    5.  
      About NetBackup server reports
    6.  
      Setting the debug level
    7.  
      Minimizing timeout failures on large database restores
    8.  
      Minimizing the loading and unloading of tapes for database backups
    9.  
      Deleting expired backups from the Informix backup database
    10.  
      Delays in completion of backup jobs
  6. Appendix A. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

Modifying NetBackup for Informix scripts

The following procedure shows how to modify a script. Repeat this procedure for each script that you modify.

To modify NetBackup for Informix scripts

  1. Copy the example scripts from /usr/openv/netbackup/ext/db_ext/informix/scripts to a different location on your client.

    The Informix scripts can reside anywhere on the client. Do not store your scripts in the sample directory because your modifications are lost if you upgrade or reinstall. Always relocate your scripts to a safe location. In a NetBackup cluster, the script must be available after a failover.

  2. Enable proper permissions on the script files so NetBackup can access the script files.

    Set the access permissions of the scripts to 775. For example:

    chmod 775 script_name
  3. Open the script file with a text editor.

    For example, use the following command to modify the informix_onbar_backup_of_rootdbs script:

    vi informix_onbar_backup_of_rootdbs
  4. Modify the script according to the instructions in the file.

    Customize the scripts to reflect your Informix installation. Refer to the comments in the scripts that indicate "Replace ....". The scripts need to be modified to have the correct Informix home path and Informix server name. The scripts also must include the policy that you want to use to back up the files and the name of the Informix configuration file.

    For example, the informix_onbar_backup_of_rootdbs script contains the following lines:

    #!/bin/sh
    
    # Replace xxxxx below with the extention used for your onconfig file.
    ONCONFIG=onconfig.xxxxx
    
    # Replace yyyyy below with the Informix home path. 
    INFORMIXDIR=/yyyyy/informix
    
    # Replace zzzzz below with the name of the Informix server. 
    INFORMIXSERVER=zzzzz
    
    # Replace informix_etc below with the name of the NetBackup server policy 
    # to be used to back up the $INFORMIXDIR/etc directory. 
    INFX_ETC_POLICY=informix_etc
    
    
    echo "Started 'date'"
    
    export ONCONFIG
    echo "exported ONCONFIG"
    
    export INFORMIXDIR
    echo "exported INFORMIXDIR"
    
    export INFORMIXSERVER
    echo "exported INFORMIXSERVER"
    
    echo "INFXBSA_SERVER = $INFXBSA_SERVER"
    echo "INFXBSA_SCHEDULED = $INFXBSA_SCHEDULED"
    echo "INFXBSA_USER_INITIATED = $INFXBSA_USER_INITIATED"
    echo "INFXBSA_FULL = $INFXBSA_FULL"
    echo "INFXBSA_INCR = $INFXBSA_INCR"
    echo "INFXBSA_POLICY = $INFXBSA_POLICY"
    
    RETURN_STATUS=0
    
    if [ "${INFXBSA_INCR}" = "1" ]
    then
        # NetBackup has started an incremental backup. 
        echo "$INFORMIXDIR/bin/onbar -b -L 1 rootdbs"
        $INFORMIXDIR/bin/onbar -b -L 1 rootdbs
        RETURN_STATUS=$?
    else
    
        echo "$INFORMIXDIR/bin/onbar -b -L 0 rootdbs"
        $INFORMIXDIR/bin/onbar -b -L 0 rootdbs
        RETURN_STATUS=$?
    
    fi
    
    if  [ "$RETURN_STATUS" -eq "0" ]
    then
    
        # Initiate a backup of the directory that contains the onconfig, 
        # sqlhosts, oncfg_$INFORMIXSERVER.SERVERNUM, and ixbar.SERVERNUM 
        # files after doing the backup. 
    
        echo "bpbackup -p $INFX_ETC_POLICY -w 0 $INFORMIXDIR/etc"
        /usr/openv/netbackup/bin/bpbackup -p $INFX_ETC_POLICY -w 0 $INFORMIXDIR/etc
        BPBACKUP_STATUS=$?
    
        if [ "$BPBACKUP_STATUS" -ne "0" ]
        then
            echo ""
            echo "bpbackup of $INFORMIXDIR/etc returned $BPBACKUP_STATUS"
        fi
    fi
    
    echo "Finished 'date'"
    
    echo "exit $RETURN_STATUS"
    echo ""
    
    exit $RETURN_STATUS
  5. Test the scripts that you created.

    More information is available on how to test your configuration.