Veritas NetBackup™ for SAP Administrator's Guide
- Introduction to NetBackup for SAP
- New features in NetBackup 8.1.2
- About NetBackup for SAP
- Features of NetBackup for SAP
- Technical overview of NetBackup for SAP
- Sequence of operation for NetBackup for SAP
- Using NetBackup for SAP on Oracle databases without RMAN
- Using NetBackup for SAP on Oracle databases with RMAN
- SAP tools overview
- NetBackup for SAP on MaxDB databases
- Introduction to NetBackup SAP HANA
- Installing NetBackup for SAP
- Planning the installation of NetBackup for SAP
- Verifying the operating system and platform compatibility
- NetBackup server and client requirements
- SAP server software requirements
- Requirements for using NetBackup for SAP MaxDB, SAP Oracle, and SAP HANA in a NetBackup cluster
- Configuration and licensing requirements for NetBackup for SAP with Snapshot Client
- About the license for NetBackup for SAP
- Copying the SAP binary file (Windows Oracle databases without RMAN only)
- Linking NetBackup for SAP with backint (UNIX or Linux Oracle databases without RMAN only)
- Linking the Oracle instances with the SBT library (UNIX or Linux Oracle databases with RMAN only)
- Installing NetBackup for SAP HANA
- Configuring NetBackup for SAP
- About configuring NetBackup for SAP
- About configuring a backup policy for SAP
- Adding a new NetBackup for SAP policy
- About policy attributes
- NetBackup for SAP backup types
- Configuring an application backup schedule
- Example application backup schedule
- Configuring automatic backup schedules
- Example automatic backup schedule
- About schedule properties
- Adding clients to a policy
- Adding NetBackup for SAP scripts to the backup selections list
- Rules for NetBackup for SAP scripts
- NetBackup for SAP backup scripts
- Configuring the logon account for the NetBackup Client Service for NetBackup for SAP
- About SAP configuration files
- Relationships between SAP database configuration files
- Modifying the initSID.utl file for NetBackup for SAP
- Example NetBackup for SAP initSID.utl file
- Modifying the initSID.sap file (NetBackup for SAP Oracle databases only)
- Example initSID.sap file (NetBackup for SAP on Oracle databases only)
- Modifying the bsi.env file (NetBackup for SAP on MaxDB databases)
- Backing up files mounted with LOFS with NetBackup for SAP (UNIX or Linux)
- About permissions for NetBackup for SAP log files (UNIX)
- Reviewing the auto-discovered mappings in Host Management
- Configuring the Maximum jobs per client for NetBackup for SAP
- Performing a manual backup
- Testing multiple concurrent backup jobs for NetBackup for SAP for Oracle (without RMAN)
- Configuring NetBackup for SAP HANA
- Performing backups and restores of SAP
- Using NetBackup for SAP to perform a backup
- Using BRTools to start an SAP backup (for Oracle database only)
- Performing an SAP archive
- Performing SAP restores using the SAPDBA utility (SAP on Oracle databases only)
- Redirecting a restore to a different client (SAP on Oracle databases only)
- SAP redirected restore sample environment (UNIX)
- Disaster recovery using BRRECOVER
- Restarting failed NetBackup for SAP backups and restores
- Performing backups and restores of SAP HANA
- NetBackup for SAP with Snapshot Client
- NetBackup for SAP with Snapshot Client overview
- Using NetBackup for SAP with Snapshot Client to back up large databases
- How the NetBackup for SAP Snapshot Client works
- Configuration requirements for snapshot backups with NetBackup for SAP
- About configuring Snapshot Client with NetBackup for SAP
- Configuring a snapshot policy for NetBackup for SAP
- About NetBackup for SAP backup types
- Prerequisites for instant recovery backups (UNIX or Linux)
- Configuring a snapshot policy with Instant Recovery for NetBackup for SAP
- Additional configuration required for NetBackup for SAP with Network Attached Storage (NAS) on UNIX or Linux
- Configuring a NAS snapshot policy for NetBackup for SAP on UNIX/Linux
- About configuring NetBackup for SAP block-level incremental backups on UNIX
- How BLI works with NetBackup for SAP (UNIX)
- About Nodata Storage Checkpoint and NetBackup for SAP
- About Fulldata Storage Checkpoint and NetBackup for SAP
- Storage Checkpoint configuration on the NetBackup for SAP client
- Configuration requirements for BLI backups with NetBackup for SAP
- Configuring policies for BLI backups with NetBackup for SAP
- About restoring individual files from a NetBackup for SAP snapshot backup
- About NetBackup for SAP restores of volumes and file systems using snapshot rollback
- About NetBackup for SAP sample backup scripts (UNIX or Linux)
- About NetBackup for SAP sample backup scripts (Windows)
- Mixing RMAN stream and RMAN proxy NetBackup for SAP backups
- Performing user-directed snapshot backups with NetBackup for SAP
- NetBackup for SAP on MaxDB databases
- Troubleshooting NetBackup for SAP and SAP HANA
- About troubleshooting NetBackup for SAP
- NetBackup debug logs and reports
- Enabling the debug logs for a NetBackup for SAP client automatically (Windows)
- Enabling the debug logs manually (UNIX)
- About the bphdb directory on the Windows database client
- About the bphdb directory on the UNIX database client
- About the backint directory on the UNIX database client
- Setting the debug level on a Windows client
- Setting the debug level on a UNIX client
- About NetBackup server reports
- sapdba logs and messages (Oracle-based SAP environments only)
- Minimizing timeout failures on large database restores
- About troubleshooting NetBackup for SAP HANA
- Disaster recovery of an SAP Hana database
- Appendix A. backint command line interface
- Appendix B. Input and output files for SAP HANA
- Appendix C. backint -i in_file contents
- Appendix D. backint -o out_file contents
- Appendix E. NetBackup for SAP environment variables for backint
- Appendix F. NetBackup for SAP configuration or bp.conf file settings
- Appendix G. Parameters used in initSID.utl
- About parameters used in initSID.utl
- initSID.utl parameter summary
- backup_stream_buffersize <size>
- client <client_name>
- custom_sort_file <file_path>
- drives <number_of_drives>
- inquiry_query_period <months>
- master_time_offset <minutes> (UNIX or Linux)
- multistream_restore
- policy <policy_name>
- policy2 <policy_name>
- restore_stream_buffersize <size>
- retry_backup <number_of_retries>
- schedule <schedule_name>
- schedule2 <schedule_name>
- server <server_name>
- sort_backup_type <value>
- sort_restore_type <value>
- switch_list <control_file_path>
- switch_log <control_file_path>
- switch_sem <control_file_path>
- Appendix H. Configuring split mirror backups
- About configuring split mirror backups
- Local-host snapshot method: nbu_snap (Solaris SPARC platform only)
- Local-host snapshot method: VxVM (Solaris SPARC, HP-UX, Windows)
- Local-host snapshot method: VxFS_Checkpoint (UNIX or Linux)
- Off-host alternate client, FlashSnap method
- Off-host alternate client, VVR method (Solaris SPARC, HP-UX)
- Hardware array-based snapshot method: Hitachi Shadow Image, EMC TimeFinder, HP Business Copy (UNIX or Linux)
- Appendix I. Register authorized locations
- Index
Off-host alternate client, VVR method (Solaris SPARC, HP-UX)
Based on this VVR configuration, the typical flow during the Snapshot Client backup for SAP:
The database shuts down or tablespaces are put in backup mode in the production host.
Replication is stopped between primary disk D1 and replication disk D2.
The alternate client off-host takes the snapshot of the replication database from disk D2 to mirror disk D3.
The production database in primary disk D1 is created online.
The mirror disk D3 is split to perform backup from the snapshot to the backup media.
The snapshot from the mirror disk D3 is then joined back to the volume in replication disk D2.
Then the storage replication log (SRL) resync happens in primary disk D1 and secondary disk D2.
Finally, replication resumes.
Before configuring this method, install and configure the following:
Install and configure the following on the production database host:
Install NetBackup Client, NetBackup Snapshot Client, and the NetBackup for SAP Agent
Configure the production database (Oracle).
You can install the NetBackup master server on a separate host
Install the following on the alternate client (off-host):
Install NetBackup Client and NetBackup Snapshot Client. The NetBackup for SAP Agent is not required.
The NetBackup media server. You can install the media server on the same host or on separate host where you want to attach the backup media.
The following procedures describe how to configure both the volume replicator primary and the volume replicator secondary.
To configure the volume replicator primary (production database host)
- Attach the external primary disk D1 to the volume replicator primary, and create a VM disk group using the following command:
root@primary# vxdg init diskgroup [cds=on|off] diskname=devicename
- Create a data volume in primary disk D1 using the following command:
root@primary# vxassist -g diskgroup make volume size
By default, it creates two copies that require two disks in one group. To override the default, enter the following command:
root@primary # vxassist -g diskgroup addlog volume logtype=dcm nlog=1
- Create the VxFS file system on this volume and mount it using the following commands:
root@primary# mkfs -F vxfs /dev/vx/rdsk/diskgroup/volume root@primary# mount -F vxfs /dev/vx/dsk/diskgroup/volume mnt
- Create the SAP production database on this volume.
- Create a Storage Replicator Log (SRL) volume in primary disk D1 using the following command:
root@primary# vxassist -g diskgroup make volume_srl size
To configure the volume replicator secondary (alternate client off-host)
- Attach the external replication disk D2 to the volume replicator secondary and create the VM disk group using the following command:
root@secondary# vxdg init diskgroup [cds=on|off] diskname=devicename
- Create a data volume in replication disk D2 using the following command:
root@secondary # vxassist -g diskgroup make volume size
By default, it creates two copies that require two disks in one group. To override the default, enter the following command:
root@secondary# vxassist -g diskgroup addlog volume logtype=dcm nlog=1
- Create a Storage Replicator Log (SRL) volume in the replication disk D2 using the following command:
root@secondary# vxassist -g diskgroup make volume_srl size
- Create the primary replicated volume group (RVG) specifying the data volume(s) and the SRL volume. On the volume replicator primary (production database host), run the following command:
The names of the disk group and volumes must be same as on the primary host.
root@primary# vradmin -g diskgroup createpri rvg_name data_volumes(s) srl_volume
- Ensure that authentication can complete.
Before you add a new secondary host (by using the addsec) or overwrite data on a remote host (by using the syncvol), vradmin performs some authentication. This process checks that the /etc/vx/vras/.rdg file on the remote host contains an entry for the primary disk group ID. The vradmin addsec or syncvol command fails if the /etc/vx/vras/.rdg file on the remote host does not have such an entry.
If authentication cannot complete, do the following:
Add the primary disk group ID to the /etc/vx/vras/.rdg file on the remote host.
To find disk group ID, run the vxprint -l diskgroup_name command on the primary.
Ensure that the /etc/hosts file has entries of primary and secondary host names in both hosts.
- Add the secondary RVG to form the replicated data set (RDS) using the following command:
root@primary# vradmin -g diskgroup addsec rvg_name primary_hostname secondary_hostname
- Start replication between the volume replicator primary and secondary using the following command:
root@primary# vradmin -g group_1 -a startrep v1_rvg
- Attach the external mirror disk D3 to the alternate client for taking a snapshot mirror.
- On the volume replicator secondary (alternate client off-host), start the snap for the data volume using the following command:
root@secondary# vxassist - g diskgroup -b snapstart volume