NetBackup™ for Sybase Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.5)
  1. Introduction to NetBackup for Sybase
    1.  
      About NetBackup for Sybase
    2.  
      Features of NetBackup for Sybase
    3.  
      NetBackup for Sybase terminology
    4. NetBackup for Sybase overview
      1.  
        SQL server and Sybase backup server
      2.  
        NetBackup for Sybase technical overview
      3.  
        Sequence of operation for NetBackup for Sybase backups
  2. Installing NetBackup for Sybase
    1.  
      Planning the installation of NetBackup for Sybase
    2.  
      Verifying the operating system and platform compatibility
    3.  
      NetBackup server and client requirements
    4.  
      Sybase server software requirements
    5.  
      Requirements for using NetBackup for Sybase in a NetBackup cluster
    6.  
      License for NetBackup for Sybase
    7.  
      Copying the NetBackup for Sybase library to each Sybase instance
    8.  
      Running the sybase_config script
    9.  
      Adding new Sybase instances
  3. Configuring NetBackup for Sybase
    1.  
      About NetBackup for Sybase configuration
    2. About configuring a backup policy for Sybase
      1.  
        Adding a NetBackup for Sybase policy
      2.  
        About policy attributes
      3.  
        Schedule properties
      4. NetBackup for Sybase backup types
        1.  
          Configure an application backup schedule
        2.  
          Example application backup schedule
        3.  
          Configure automatic backup schedules
        4.  
          Example automatic backup schedule
      5.  
        Add clients to a policy
      6.  
        Adding NetBackup for Sybase scripts to the backup selections list
      7.  
        Rules for NetBackup for Sybase scripts
    3. About the backup, restore, and load scripts for NetBackup for Sybase on UNIX
      1.  
        Modifying the backup script for NetBackup for Sybase on UNIX
      2.  
        Example sybase_mydb_backup.cmd script for NetBackup
      3.  
        Modifying the restore script for NetBackup for Sybase on UNIX
      4.  
        Example of a sybase_mydb_restore script
    4. About the backup, restore, and load scripts for NetBackup for Sybase on Windows
      1.  
        Modifying the backup script for NetBackup for Sybase on Windows
      2.  
        sybase_mdb_backup.cmd script
      3.  
        Additional information for editing the backup script for NetBackup for Sybase on Windows
      4.  
        Modifying the restore script for NetBackup for Sybase on Windows
      5.  
        sybase_mydb_restore.cmd script example for NetBackup
      6.  
        Additional information for editing the restore script for NetBackup for Sybase on Windows
    5.  
      Modifying the NetBackup for Sybase load script
    6.  
      NetBackup for Sybase environment variables
    7. NetBackup for Sybase configuration or bp.conf file settings
      1.  
        Creating a $SYBASE_HOME/bp.conf file on the UNIX client
      2.  
        Specifying options in /usr/openv/netbackup/bp.conf on the UNIX client
    8.  
      Configuring the logon account for the NetBackup Client Service for NetBackup for Sybase
    9. About striped dumps and loads with NetBackup for Sybase
      1.  
        Example Sybase scripts for striped dumps and loads
      2.  
        NetBackup for Sybase multiplexing considerations - duplicating tapes
      3.  
        NetBackup for Sybase multiplexing considerations - using more than 12 stripes
    10.  
      Reviewing the auto-discovered mappings
    11.  
      About permissions for NetBackup for Sybase log files (UNIX)
    12.  
      Configuring the Maximum jobs per client
    13.  
      Perform a manual backup
  4. Using NetBackup for Sybase
    1. About Sybase database backups
      1.  
        Sybase backup strategy
      2.  
        Automatic backups of a Sybase database
      3.  
        Backing up a Sybase database manually
      4.  
        Performing a user-directed backup for Sybase
    2.  
      Browsing Sybase backups
    3. About restoring a Sybase database
      1.  
        Using isql to restore a Sybase database
      2.  
        Configuring a redirected restore on the NetBackup for Sybase client
  5. Troubleshooting NetBackup for Sybase
    1. NetBackup debug logs and reports
      1.  
        Enabling the debug logs for a NetBackup for Sybase client automatically (Windows)
      2.  
        Enabling the debug logs manually (Windows) (NetBackup for Sybase)
      3.  
        Enabling the debug logs manually (UNIX)
      4.  
        About the bphdb directory on the Windows database client
      5.  
        About the bphdb directory on the UNIX database client
      6.  
        About the sybackup directory on the UNIX database client
      7.  
        About the sybackup directory on the Windows database client
      8.  
        Setting the debug level on a Windows client
      9.  
        Setting the debug level on a UNIX client
    2.  
      Sybase Backup Server log and messages
    3.  
      Minimizing timeout failures on large database restores
    4.  
      Minimizing the loading and unloading of tapes for database backups
  6. Appendix A. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

Reviewing the auto-discovered mappings

In certain scenarios, a NetBackup host shares a particular name with other hosts or has a name that is associated with a cluster. To successfully perform backups and restores with NetBackup for Sybase, you must approve each valid auto-discovered mapping that NetBackup discovers in your environment. Or, manually add the mappings.

See Approve the auto-discovered mappings for a cluster.

See Manually map host names.

Examples of the configurations that have multiple host names include:

  • A host is associated with its fully qualified domain name (FQDN) and its short name or its IP address.

  • If the Sybase server is clustered, the host is associated with its node name and the virtual name of the cluster.

These mappings are configured in the Security > Host mappings node in the NetBackup web UI. You can also use the nbhostmgmt command to manage the mappings. See the NetBackup Security and Encryption Guide and NetBackup Web UI Administrator's Guide for more details.

Auto-discovered mappings for a cluster

In a Sybase cluster environment, you must map the node names to the virtual name of the cluster if the following apply:

  • If the backup policy includes the cluster name (or virtual name)

  • If the NetBackup client is installed on more than one node in the cluster, the virtual name must be mapped to each node.

    If the NetBackup Client is only installed on one node, then no mapping is necessary.

Approve the auto-discovered mappings for a cluster

To approve the auto-discovered mappings for a cluster

  1. In the NetBackup web UI, expand Security > Host mappings.
  2. Click the Mappings to approve tab.

    The list displays the hosts in your environment and the mappings or additional host names that NetBackup discovered for those hosts. A host has one entry for each mapping or name that is associated with it.

    For example, for a cluster with hosts client01.lab04.com and client02.lab04.com, you may see the following entries:

    Host

    Auto-discovered mapping

    client01.lab04.com

    client01

    client01.lab04.com

    clustername

    client01.lab04.com

    clustername.lab04.com

    client02.lab04.com

    client02

    client02.lab04.com

    clustername

    client02.lab04.com

    clustername.lab04.com

  3. Click the name of the host.
  4. Review the mappings for the host and click Approve if you want to use the discovered mappings.

    For example, if the following mappings are valid for client01.lab04.com, then you approve them.

    Auto-discovered mapping

    Valid name for

    client01

    The short name of the client

    clustername

    The virtual name of the cluster

    clustername.lab04.com

    The FQDN of the virtual name of the cluster

  5. When you finish approving the valid mappings for the hosts, click on the Hosts tab.

    For hosts client01.lab04.com and client02.lab04.com, you see entries for Mapped host or IP address that are similar to the following:

    Host

    Mapped host names/IP addresses

    client01.lab04.com

    client01.lab04.com, client01, clustername, clustername.lab04.com

    client02.lab04.com

    client02.lab04.com, client02, clustername, clustername.lab04.com

  6. If you need to add a mapping that NetBackup did not automatically discover, you can add it manually.

Table: Example mapped host names for a Sybase cluster environment

Environment

Host

Mapped host names

Cluster with two nodes

Physical name of Node 1

Virtual name of Sybase server

 

Physical name of Node 2

Virtual name of Sybase server

 

Manually map host names

If you need to add a mapping that NetBackup did not automatically discover, you can add it manually.

To manually map host names

  1. In the NetBackup web UI, expand Security > Host mappings.
  2. Click on the Hosts tab.
  3. Click Add shared or cluster mappings.

    For example, type the name of the virtual name of the cluster. Then click Add to choose the hosts to which you want to map that virtual name.