Preview only show first 10 pages with watermark. For full document please download

Catalyst Plug-in For Sap Hana

   EMBED


Share

Transcript

HP StoreOnce Catalyst Plug-in for SAP HANA Version 1.0 installation and user guide Abstract This document provides instructions on using the HP StoreOnce Backup system with systems running SAP HANA. This document is intended for backup administrators and information technology (IT) administrators familiar with the HP StoreOnce Backup system and SAP HANA software. Always check www.hp.com/go/storage/docs for the most current plug-in documentation. (Select your product and then select the “Installation” Information Type.) Refer to the Data Agile BURA Compatibility Matrix on www.hp.com for supported client hardware. HP Part Number: EH990-10564 Published: July 2015 Edition: 1 © Copyright 2015 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein. Links to third-party websites take you outside the HP website. HP has no control over and is not responsible for information outside HP.com. Acknowledgments SAP® and SAP HANA® are registered trademarks of SAP. Revision History Revision 1 July 2015 First edition, part number EH990-10564 for the SAP HANA Plug-in version 1.0 release Contents 1 Overview..................................................................................................4 Prerequisites for the SAP HANA Plug-in........................................................................................4 2 HP StoreOnce Catalyst................................................................................5 What is StoreOnce Catalyst?.....................................................................................................5 Benefits of StoreOnce Catalyst....................................................................................................5 StoreOnce Catalyst Terminology.................................................................................................5 3 Configuring the HP StoreOnce Backup system for the SAP HANA Plug-in...........7 Creating StoreOnce Catalyst and Federated Catalyst stores............................................................7 Configuring StoreOnce Catalyst Store Access Control....................................................................7 Configuring StoreOnce Catalyst over Fibre Channel......................................................................8 Initial configuration..............................................................................................................9 Client configurations.............................................................................................................9 4 Installing the SAP HANA Plug-in.................................................................11 Downloading the SAP HANA Plug-in.........................................................................................11 Opening the SAP HANA Plug-in installer...................................................................................11 Installing and Configuring the SAP HANA Plug-in.......................................................................11 Manually configuring the SAP HANA Plug-in..............................................................................12 5 Uninstalling the SAP HANA Plug-in.............................................................14 6 Configuring SAP HANA Studio..................................................................15 7 Performing SAP HANA Operations using SAP HANA Studio..........................17 SAP HANA Backups...............................................................................................................17 SAP HANA Restores................................................................................................................18 SAP HANA Deletes.................................................................................................................21 8 Using SAP HANA CLI...............................................................................23 Configuring SAP HANA CLI.....................................................................................................23 Performing SAP HANA Backup operations.................................................................................23 Extracting the Backup ID of SAP HANA backup..........................................................................23 Cancelling SAP HANA Backup.................................................................................................24 Checking SAP HANA Backup for Recovery................................................................................24 Checking the integrity of SAP HANA backup objects...................................................................25 Performing SAP HANA restore operations..................................................................................25 Performing SAP HANA delete operations...................................................................................26 9 Performing HP StoreOnce Catalyst Copy Operations.....................................27 10 Troubleshooting......................................................................................29 11 Support and Other Resources...................................................................30 Contacting HP........................................................................................................................30 Related information.................................................................................................................30 Product documentation.......................................................................................................30 Other useful websites.........................................................................................................30 Typographic conventions.........................................................................................................31 12 Documentation feedback.........................................................................32 Index.........................................................................................................33 Contents 3 1 Overview SAP HANA, an in-memory database, provides two primary backup and restore interfaces: file (including NFS) and the more intelligent, third party Backint interface. The HP StoreOnce Catalyst Plug-in for SAP HANA (SAP HANA Plug-in) delivers a Backint integration for backing up and restoring SAP HANA instances directly to HP StoreOnce Catalyst. The plug-in backs up and restores SAP HANA databases or logs in single server, scale out cluster, or cloud SAP HANA deployments. The SAP HANA Plug-in supports HP StoreOnce Catalyst stores as well as Federated Catalyst stores. NOTE: HP StoreOnce software versions 3.13 and later will support the Catalyst over Fibre Channel interface (see StoreOnce supported software versions below). Prerequisites for the SAP HANA Plug-in Supported Operating Systems and StoreOnce software versions Operating system StoreOnce supported software version SUSE Enterprise Linux 11 Service Pack 3 (Catalyst over Ethernet) StoreOnce 3.12.1 and later SUSE Enterprise Linux 11 Service Pack 3 (Catalyst over Fibre Channel) StoreOnce 3.13 and later Red Hat Enterprise Linux 6 Service Pack 5 (Catalyst over Fibre Channel and Ethernet) StoreOnce 3.12.1 and later Supported Database Versions SAP HANA Platform SPS 08 and later (Catalyst over Fibre Channel and Ethernet) IMPORTANT: 4 Overview A SAP HANA instance is required to install the SAP HANA Plug-in. 2 HP StoreOnce Catalyst This chapter provides a brief overview of HP StoreOnce Catalyst. IMPORTANT: For more information, including how to create, edit, and delete StoreOnce Catalyst and Federated Catalyst stores, see the HP StoreOnce Backup system user guide for your product. What is StoreOnce Catalyst? HP StoreOnce Catalyst is a StoreOnce function that allows backup applications to: • back up data to a target store on the HP StoreOnce Backup system. Deduplication may occur on the media server, backup server, or HP StoreOnce Backup system. • copy jobs between HP StoreOnce Backup systems. Configuration occurs within the backup application, making this an attractive alternative to using the replication function on the HP StoreOnce Backup system. StoreOnce Catalyst requires a backup application that supports it. See www.hp.com/go/ebs for a list of supported backup applications. Benefits of StoreOnce Catalyst • The backup application is in full control of data for the full lifecycle of the backup data. • The backup application has full visibility of all items and jobs on the HP StoreOnce Backup system. • Deduplication can occur on either the media server or HP StoreOnce Backup system which ensures efficient use of the available bandwidth. • There is no limiting geometry (for example, cartridges for VTL libraries). • There is no enforced limit on the number of items within a store. • Copy jobs are instigated from the application and have none of the complexities of replication mapping. • Space reclamation is more automated and easier to implement if HP StoreOnce Catalyst devices types are used. StoreOnce Catalyst Terminology Table 1 Terminology Term Description StoreOnce Catalyst the name of the StoreOnce interface StoreOnce Catalyst stores the targets/device types in which backups are stored on the HP StoreOnce Backup system StoreOnce Catalyst Federated stores a group of up to eight service sets within the same cluster that share backup jobs as a federation on the HP StoreOnce Backup system StoreOnce Catalyst items the items stored in the StoreOnce Catalyst stores on the HP StoreOnce Backup system StoreOnce Catalyst clients the generic term for applications that connect using the StoreOnce Catalyst interface Data jobs any backup or restore job StoreOnce Catalyst Optimized Backups backups performed on the media server or backup server (instead of the HP StoreOnce Backup system) so only What is StoreOnce Catalyst? 5 Table 1 Terminology (continued) Term Description unique data is sent to the HP StoreOnce Backup system and a low bandwidth network link is adequate. Actual performance varies depending upon the data and disk I/O speeds. 6 Copy jobs true copies of the data (not mirror images). The backup application specifies the source store (outbound copy job) and target store (inbound copy job). Once copied, the two versions are independent of each other and either version can be deleted, moved, or added to from the backup application. StoreOnce Catalyst Optimized Copy the two stores negotiate so that only unique data is transferred and the copy job is completed in a bandwidth-efficient manner. HP StoreOnce Catalyst 3 Configuring the HP StoreOnce Backup system for the SAP HANA Plug-in Creating StoreOnce Catalyst and Federated Catalyst stores 1. 2. 3. 4. 5. Log onto the HP StoreOnce Management Console (StoreOnce GUI) with administrator privileges. Navigate to HP StoreOnce→StoreOnce Catalyst→Stores. Click Create. If using an HP StoreOnce 6500 or B6200 Backup system, select a service set for the new store and click OK. To create a Federated store, select multiple service sets; these become the Federation members. Change the store details as appropriate. A table describing the store details can be found in the “StoreOnce Catalyst Stores page” section of the HP StoreOnce Backup system user guide for your product. a. Name the StoreOnce Catalyst or Federated Catalyst store to match the values entered during the installer configuration. b. Set the “Primary (Default) Transfer Policy” to Low Bandwidth. IMPORTANT: Selecting Low Bandwidth ensures the best backup performance and deduplication ratio. 6. Click Create. A StoreOnce Catalyst or Federated Catalyst store is created. The store will appear in the top panel. This means the HP StoreOnce Backup system is configured and ready to accept backups. Configuring StoreOnce Catalyst Store Access Control In setting client access control, two modes can be set on StoreOnce Catalyst stores: • No client credential checking – Allows all clients to have access to the StoreOnce Catalyst store. • Client credential checking – Allows a select group of client identifiers to have access to the StoreOnce Catalyst store. To enable this mode, client access permission checking must be enabled on the Settings tab of the StoreOnce GUI. To access this tab, navigate to HP StoreOnce→StoreOnce Catalyst→Settings. Also, an individual StoreOnce Catalyst store must grant access for a client identifier within the Permissions tab of a StoreOnce Catalyst store. Creating StoreOnce Catalyst and Federated Catalyst stores 7 NOTE: Access to StoreOnce Catalyst stores is controlled through client identifiers with optional passwords. Configuring StoreOnce Catalyst over Fibre Channel NOTE: Fibre Channel users are advised to consult the Data Agile BURA Compatibility Matrix (available at www.hp.com) to ensure that client HBAs, switches, Fibre Channel driver, and firmware versions are supported. Before configuring StoreOnce Catalyst over Fibre Channel, ensure that: • Database servers and the HP StoreOnce appliance are connected to the Fibre Channel network. • Media servers can communicate with the HP StoreOnce appliance over a Fibre Channel network. To do so, the storage administrator must ensure that any network segregation, such as zoning, is set up to handle required connectivity between the server and appliance. NOTE: When using StoreOnce Catalyst over Fibre Channel: • Appliance-to-appliance connectivity should be through an Ethernet network. Doing so enables data recovery copies to be made through the HP StoreOnce Catalyst copy function. • Administrator privileges are required to run StoreOnce Catalyst over Fibre Channel because it accesses OS-specific device files associated with StoreOnce Catalyst over Fibre Channel devices. StoreOnce Catalyst over Fibre Channel functions the same way as standard StoreOnce Catalyst (over Ethernet); the backup application will not perceive a difference. However, some configuration is required to set up the backup and restore connections between the ports on the HP StoreOnce Backup system and the ports on the client servers. This is done using the Fibre Channel Settings tab which is available within the StoreOnce GUI only if StoreOnce Catalyst over Fibre Channel is enabled. 8 Configuring the HP StoreOnce Backup system for the SAP HANA Plug-in Initial configuration 1. 2. 3. 4. Locate the Identifier at the top of the screen. This is the Fibre Channel address of the StoreOnce Backup system and is used to identify the StoreOnce Backup system in the backup application. It is in the format COFC-; you may provide an Identifier Alias to make it easier to identify from the backup application. This Catalyst over Fibre Channel Identifier is provided to the backup application where an Ethernet address would otherwise be provided. In the Target Ports section, HP recommends the default values. However, you can edit the speed. On the Fibre Channel Settings tab, in the Devices section, locate the World Wide Port Name for each port on the StoreOnce Backup system. This is the information needed to connect the client with the StoreOnce Backup system. Use this information to zone your client Fibre Channel ports with your StoreOnce Fibre Channel ports. Locate the Number of Logins and Devices per Initiator Port for each port. These values determine the number of concurrent backup and restore connections allowed on each Fibre Channel port on the HP StoreOnce Backup system. • Number of Logins – defines the number of client-side ports that are zoned to connect to that port on the StoreOnce Backup system and cannot be edited. • Devices per Initiator Port – determines the number of backup and restore connections that are allowed for each client login to that port on the StoreOnce Backup system. This value should be increased if multiple concurrent backup streams are required; the maximum allowed is 64 devices per login. The number of paths available to a particular client is calculated as: number of client ports zoned * number of StoreOnce node ports zoned * devices per initiator port Table 2 Example relationships between Device per Initiator Port and Number of Connections on Windows Client-side HP StoreOnce Backup system Devices per Initiator Port Number of concurrent backup and restore sessions (per service set) 1 port zoned to 4 ports 1 4 2 ports zoned to 4 ports 1 8 2 ports zoned to 2 ports 4 16 2 ports zoned to 4 ports 8 64 Once the client has been Fibre Channel zoned with the StoreOnce appliance there are a number of considerations for each operating system. NOTE: Only backup is supported with Catalyst over Fibre Channel. All StoreOnce Catalyst copies must take place over Ethernet. When configuring a StoreOnce Catalyst copy destination, ensure than an Ethernet address is provided instead of a Catalyst over Fibre Channel address. Client configurations Linux Clients StoreOnce Catalyst over Fibre Channel presents a device type of “Processor.” On Linux, these devices files are created in /dev/sg*. By default, /dev/sg* devices are accessible by root users only. If backups are run as a non-root user, first grant the backup user permissions to access these device files using the chmod o+rwx /dev/sg* command. Configuring StoreOnce Catalyst over Fibre Channel 9 For finer grained permissions, determine which /dev/sg* device files relate to Catalyst over Fibre Channel using the lsscsi --generic command and then chmod o+rwx on the appropriate devices. 10 Configuring the HP StoreOnce Backup system for the SAP HANA Plug-in 4 Installing the SAP HANA Plug-in Downloading the SAP HANA Plug-in Plug-in installation files are available at http://software.hp.com by navigating to HP Storage→Storage Software→HP StoreOnce Free Software. (Refer to your sales contact for user ID and password information.) Opening the SAP HANA Plug-in installer IMPORTANT: To ensure the correct file permissions, download the installer file using the SAP HANA operating system user (adm). The SAP HANA Plug-in must also be installed using the adm user; do not install using ‘root’. 1. 2. 3. Download the installer: HPStoreOncePluginForSAPHANA1.0.0.tar. Extract the compressed file using the command tar –xvf . You should now have the installer.sh file. Run installer.sh. The process is shown below. hana:~/installer> tar —xvf HPStoreOncePluginForSAPHANA1.0.0.tar HP-Catalyst_SAP-HANA-Plugin-1.0/ HP-Catalyst_SAP-HANA-Plugin-1.0/installer.sh HP-Catalyst_SAP-HANA-Plugin-1.0/HP StoreOnce Plugin for SAP HANA v1 0_User_Guide.pdf HP-Catalyst_SAP-HANA-Plugin-1.0/plug-in.tar hana:~/installer> cd HP-Catalyst_SAP-HANA-Plugin-1.0 hana:~installer/HP-Catalyst_SAP-HANA-Plugin-1.0> ./installer.sh 4. After the installer begins, the options menu will be displayed as follows: Choose options ------------------------------------| Operation | Option | | Install | 1 | | Remove | 2 | ------------------------------------Press any key to exit Enter Selected Option [exit]: 5. Enter 1 to install or re-install the SAP HANA Plug-in, or enter 2 to remove any existing version of the plug-in. Installing and Configuring the SAP HANA Plug-in IMPORTANT: When configuring a SAP HANA cluster, this installation process must be repeated on all SAP HANA server nodes. 1. 2. 3. Enter the SAP-HANA system ID (for example, HN1). The installer will check for a previous version of the plug-in. Enter y to continue with the installation. Press the Enter key to accept the default installation path (HP recommended), or change to the desired location (only for a specific reason) and press Enter. The Pre-installation Summary screen appears: Continuing installation on default path [/hana/shared/HN1] Pre-installation Summary ---------------------------------Product : HP StoreOnce Catalyst SAP-HANA Plug-in Version : 1.0 Installation Base : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin Downloading the SAP HANA Plug-in 11 Do you wish to continue? 4. (y/n) [n]:y Check the Pre-installation Summary and enter y if the details are correct. The installation process will complete and the following confirmation screen is displayed: HP StoreOnce Catalyst SAP-HANA Plug-in-1.0 installation successful Post-installation Summary ---------------------------------Product : HP StoreOnce Catalyst SAP-HANA Plug-in Version : 1.0 Installation Base : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin Installed binary path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/bin Installed config path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/config Installed log path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/logs Installed documents path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/docs Installed License path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/licensing/EULA 5. 6. 7. 8. Enter y to configure HP StoreOnce Catalyst backup options (HP recommended) or n to exit the setup. If configuring the backup options: a. Enter the HP StoreOnce backup node address. The address can be IPv4, IPv6, FQDN (Fully Qualified Domain Name), or Catalyst over Fibre Channel (CoFC). b. Enter the HP StoreOnce Catalyst store name to which backups will be sent (for example, SAPHANA). Enter y to configure HP StoreOnce Catalyst copy options (HP recommended) or n to exit the setup. If configuring copy options: a. Enter the HP StoreOnce copy destination node address. The address can be IPv4, IPv6, or FQDN. Catalyst over Fibre Channel addresses are not supported for Catalyst copy. b. Enter the HP StoreOnce Catalyst copy destination store name to which copies will be sent (for example, SAP_HANA_COPY). The StoreOnce Catalyst Configuration summary is displayed: StoreOnce Catalyst Configuration ---------------------------------CATALYST_STORE_ADDRESS : 192.12.14.5 CATALYST_STORE_ADDRESS : SAP_HANA CATALYST_COPY1_STORE_ADDRESS : 192.12.14.5 CATALYST_COPY1_STORE_ADDRESS : SAP_HANA_COPY NOTE: HP StoreOnce Catalyst stores are not created automatically by the installer. See “Configuring the HP StoreOnce Backup system for the SAP HANA Plug-in” (page 7) for details on creating and configuring the StoreOnce Catalyst store for backup. Manually configuring the SAP HANA Plug-in HP recommends creating the SAP HANA Plug-in configuration file during the installation process. However, you can manually create and edit a configuration file. • To create a new configuration file, copy and rename the plugin_template.conf file located in the config installation directory. You will edit the copied file. • To edit the existing configuration file, edit plugin.conf. Table 3 (page 13) describes the editable parameters of the configuration file. Any parameters not listed here are considered advanced and should not be edited unless advised by HP Support to do so. 12 Installing the SAP HANA Plug-in Table 3 Parameters of the Configuration File Name Description Mandatory/Optional Basic StoreOnce Catalyst Settings CATALYST_STORE_ADDRESS StoreOnce node address used for backups. Supply the Mandatory address of the StoreOnce service set. Accepts IPv4, FQDN, StoreOnce Catalyst over Fibre Channel, and IPv6. IPv6 addresses should be quoted, for example, “fdca:cd45:5ab0:995::7”. CATALYST_STORE_NAME StoreOnce Catalyst store name used for backups CATALYST_CLIENT_NAME If Client Permission Checking is enabled, provide the Optional StoreOnce Catalyst client identifier defined on the StoreOnce appliance for granting read/write to the primary backup target CATALYST_CLIENT_PASSWORD If Client Permission Checking is enabled, provide the Optional StoreOnce Catalyst client password defined on the StoreOnce appliance for granting read/write to the primary backup target. This is a basic password implementation; passwords are stored in plain text. CATALYST_TAG Identifies the StoreOnce Catalyst images on the StoreOnce Optional appliances associated with the current database server Mandatory StoreOnce Catalyst Copy Targets CATALYST_COPY1_STORE_ADDRESS StoreOnce node address of the first StoreOnce Catalyst Optional copy target. Accepts IPv4, FQDN, and IPv6. IPv6 addresses should be quoted, for example, “fdca:cd45:5ab0:995::7”. CATALYST_COPY1_STORE_NAME StoreOnce Catalyst store name used for the first StoreOnce Optional Catalyst copy target Log File Settings CATALYST_LOGFILE StoreOnce Catalyst log file located under the logs folder Mandatory relative to the installation path (default is Catalyst_SAPHANA.log) CATALYST_LOGLEVEL Specifies the StoreOnce Catalyst client side logging level. Mandatory Accepts ERROR, INFO, DEBUG, EXTENDED_DEBUG. The default (HP recommended) is ERROR; set to INFO for support investigations. CATALYST_LOGSIZE Specifies the StoreOnce Catalyst client side maximum log file size (in MB) APPLICATION_LOGFILE Application-specific log file located under the logs folder Mandatory relative to the installation path (default is Connector_SAPHANA.log) APPLICATION_LOGLEVEL Specifies the Application logging level. Accepts: Mandatory Mandatory • ERROR: Log only error messages • QUIET: Instrumentation logging • INFO: Log function entry/exit points • DEBUG: Detailed logging of operations and related states • EXTENDED_DEBUG: Verbose logging of operations and related states. This will impact performance. APPLICATION_LOGSIZE Specifies the Application maximum log file size (in MB) Mandatory APPLICATION_ROLLUP_LOGS Number of log files for application log rotation (default is 10) Mandatory Manually configuring the SAP HANA Plug-in 13 5 Uninstalling the SAP HANA Plug-in 1. 2. 3. 4. 5. 6. Run installer.sh. After the installer has started, the options menu will be displayed. Enter 2 to uninstall. Enter the SAP-HANA system ID (for example, HN1). The installer will check for a previous version of the plug-in and provide the installation path. Enter y to continue with the installation. Copy the installation path provided and enter it as the installation path to uninstall. The Un-installation Summary screen appears: HP StoreOnce Catalyst SAP-HANA Plug-in-1.0 un-installation summary ---------------------------------Product : HP StoreOnce Catalyst SAP-HANA Plug-in Version : 1.0 Installation Base : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin Installed binary path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/bin Installed config path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/config Installed log path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/logs Installed documents path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/docs Installed License path : /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/licensing/EULA 7. 8. Enter y to continue. Enter y to confirm that you want to proceed. When the plug-in is uninstalled, a confirmation message is displayed. IMPORTANT: 14 You cannot perform SAP HANA backups until the SAP HANA Plug-in is reinstalled. Uninstalling the SAP HANA Plug-in 6 Configuring SAP HANA Studio Before you begin configuring, make sure that the SAP HANA system is added to SAP HANA Studio and you have access to it from the SAP HANA Studio Systems panel. NOTE: steps. You cannot backup, copy, restore, or delete until you successfully complete the following 1. On the Systems panel, right-click your system and select Backup and Recovery→Open Backup Console. The following screen is displayed: 2. 3. Click the Configuration tab. Expand “Backint Settings.” The “Backint Agent” field should display the location of the Backint executable that will be used for backups. If the path is correct, it confirms that the SAP HANA Plug-in was installed and is detected by SAP HANA. IMPORTANT: If the Backint executable path is not displayed, ensure that the installation was successful on all SAP HANA nodes. Also, click Refresh on the Configuration tab. 15 4. In the Data Backup section, in the “Backint Parameter File” field, enter the location of the configuration file (the default is /hana/shared/hp/HP-Catalyst-SAP-HANA-Plugin/ config/plugin.conf). This path is provided in the SAP HANA installation summary. SAP HANA Studio is now successfully configured. IMPORTANT: SAP HANA Backint does not support SAP HANA-managed StoreOnce Catalyst copy. Use the HP StoreOnce Catalyst Copy tool, located in the bin directory of the SAP HANA Plug-in installation, to perform StoreOnce Catalyst copy operations. The tool uses the same configuration file used for backup, restore, and delete operations. See “Performing HP StoreOnce Catalyst Copy Operations” (page 27) for more information. IMPORTANT: You can also perform “Log Backups” using the SAP HANA Plug-in. Use the Data Backup configuration file, or create and assign a dedicated Log Backup configuration file within SAP HANA Studio. You can send Data Backups using Backint and Log backups using “file”, or both can be backed up usnig Backint. 16 Configuring SAP HANA Studio 7 Performing SAP HANA Operations using SAP HANA Studio Before beginning a backup, restore, or delete, make sure that you have completed all the steps in “Configuring SAP HANA Studio” (page 15). SAP HANA Backups 1. On the SAP HANA Studio Systems panel, right-click your system and select Backup and Recovery→Back up System.... The following screen is displayed: 2. Change the Destination Type to “Backint.” Customize the Backup Prefix field as needed. This prefix can be used to identify the StoreOnce Catalyst item created during a backup. Click Next. A backup summary is displayed. 3. SAP HANA Backups 17 4. Click Finish to start the backup. The progress is shown on the screen. At successful completion, the Backup Execution Summary screen is displayed. The SAP HANA system is now backed up to the HP StoreOnce Backup system using Backint. SAP HANA Restores 1. 3. On the SAP HANA Studio Systems panel, right-click your system and select Backup and Recovery→Recover System.... At the Shut Down System window, save your current tasks and click OK. SAP HANA Studio will shut down the SAP HANA system and prepare for the recovery wizard. At the Specific Recovery Type window, select the recovery required. 4. 5. Click Next. The Log location should be listed. If not, add it now. 2. 18 Performing SAP HANA Operations using SAP HANA Studio 6. Click Next. SAP HANA will list the available data backups. 7. Select a backup to restore and click Check Availability to see if the backup is available on the HP StoreOnce appliance. 8. 9. With the desired backup selected, click Next. In the Check Availability of Log Backups section, select Third-Party Backup Tool (Backint) and change other settings as needed. SAP HANA Restores 19 10. Click Next. The screen displays a review of the settings. 11. Click Finish. A progress screen is displayed. When the process is complete, the SAP HANA system will automatically restart and will be restored to the selected backup from the HP StoreOnce Catalyst store. IMPORTANT: To restore from a StoreOnce Catalyst copy, you must modify the CATALYST_STORE_ADDRESS and CATALYST_STORE_NAME parameters in your plug-in configuration file. Modifying the copy-specific parameters is not enough when doing a restore because the CATALYST_STORE_ADDRESS and CATALYST_STORE_NAME parameters are used to determine the location of the Catalyst backups. 20 Performing SAP HANA Operations using SAP HANA Studio SAP HANA Deletes 1. 2. 3. On the SAP HANA Studio Systems panel, right-click your system and select Backup and Recovery→Open Backup Console. Click the Backup Catalog tab. A list of previous backups is displayed. 4. Right-click the backup to delete and select “Delete Data Backup” to delete an individual backup or “Delete Older Backups” to delete all previous backups. Select “Catalog and Backup Location” (HP recommended) to delete the catalog entry and the StoreOnce Catalyst backup objects in the StoreOnce Catalyst store, then check File System and/or Third-Party Backup Tool (Backint). Selecting “Catalog” does not delete the StoreOnce Catalyst items from the StoreOnce Catalyst store. 5. Click Next. The Review Backup Deletion Settings screen is displayed. SAP HANA Deletes 21 6. 7. Click Finish. A confirmation screen is displayed. Click OK to confirm the deletion. The catalog entry, and the associated backup items in the HP StoreOnce Catalyst store if applicable, are now deleted. NOTE: Deleting a backup does not delete the copies made using the HP StoreOnce Catalyst Copy tool; use the same tool to delete StoreOnce Catalyst copied items. See “Performing HP StoreOnce Catalyst Copy Operations” (page 27) for more information. 22 Performing SAP HANA Operations using SAP HANA Studio 8 Using SAP HANA CLI Configuring SAP HANA CLI By default, the SAP HANA Plug-in uses the plugin.conf file for all operations. If the plug-in was installed in the default location, this file is located in /hana/shared//hp/ HP-Catalyst-SAP-HANA-Plugin/config. To change the configuration file that is used by the SAP HANA CLI to perform all operations, you must edit the global.ini file in one of the following locations: • /hana/shared//global/hdb/custom/config/global.ini • /hana/install//global/hdb/custom/config/global.ini The file should include lines for the data_backup_parameter_file and log_backup_parameter_file parameters. For example: [backup] data_backup_parameter_file = log_backup_parameter_file = If these lines are not already in the file, add them and then change the data_backup_parameter_file and log_backup_parameter_file parameters to the desired location of the SAP HANA Plug-in configuration file. The default location of the plugin.conf file is: /hana/shared/HN1/hp/HP-Catalyst-SAS-HANA-Plugin/config/ plugin.conf. For more information, see the SAP article Customer-Specific Configuration Files located here: http://help.sap.com/saphelp_hanaplatform/helpdata/en/c3/ 9a9abbbb57101496d4fade60e43503/content.htm?frameset=/en/c4/ 711ba3bb571014be6ab7c32df3cae3/frameset.htm¤t_toc=/en/00/ 0ca1e3486640ef8b884cdf1a050fbb/plain.htm&node_id=454 NOTE: If you are using the CLI for the first time on this sever, set the configuration file location to the default location because the location might not have already been configured. Performing SAP HANA Backup operations Use the following command and add more options/filters as needed: hdbsql -n -i -u -p "BACKUP DATA USING BACKINT (')" For example: hdbsql -n hanasystem.gbr.hp.com -i 00 -u SYSTEM -p mypassword "BACKUP DATA USING BACKINT ('/usr/sap/HN1/SYS/global/hdb/backint/first_backup')" For more information, see the SAP article Perform a Complete Data Backup (SQL Statements) located here: http://help.sap.com/saphelp_hanaplatform/helpdata/en/c5/ 25379bbb571014a389f09d291909a5/content.htm Extracting the Backup ID of SAP HANA backup Performing a restore, cancel, or to check backups requires the backup ID. Execute the following command to display the backup ID: hdbsql -n -i -u -p " SELECT BACKUP_ID FROM M_BACKUP_CATALOG WHERE ENTRY_TYPE_NAME = 'complete data backup' ORDER BY SYS_START_TIME DESC" Configuring SAP HANA CLI 23 Examples: • To get the backup ID of all running backups: hdbsql -n hanasystem.gbr.hp.com -i 00 -u SYSTEM -p mypassword "SELECT BACKUP_ID FROM M_BACKUP_CATALOG WHERE ENTRY_TYPE_NAME = 'complete data backup' AND STATE_NAME = 'running' ORDER BY SYS_START_TIME DESC" • To get the backup ID of all existing backups: hdbsql -n hanasystem.gbr.hp.com -i 00 -u SYSTEM -p mypassword "SELECT BACKUP_ID FROM M_BACKUP_CATALOG WHERE ENTRY_TYPE_NAME = 'complete data backup' ORDER BY SYS_START_TIME DESC" Cancelling SAP HANA Backup NOTE: Canceling a backup requires the backup ID. Use the following command: hdbsql -n -i -u -p "BACKUP CANCEL " For example: hdbsql -n hanasystem.gbr.hp.com -i 00 -u SYSTEM -p mypassword "BACKUP CANCEL 1429868930854" For more information, see the SAP article Canceling a Running Data Backup (SQL Statements) located here: http://help.sap.com/saphelp_hanaplatform/helpdata/en/c4/ f934abbb571014b5fec3c1121b4dad/content.htm?frameset=/en/c4/ edd463bb571014816ed484e45f82a9/frameset.htm¤t_toc=/en/00/ 0ca1e3486640ef8b884cdf1a050fbb/plain.htm&node_id=462 Checking SAP HANA Backup for Recovery Determine if the last successful backup is available for recovery. NOTE: Checking for a specific backup requires the backup ID. Use the following command: hdbbackupdiag --check --backintDataParamFile --logDirs Examples: • To check the latest backup: hdbbackupdiag --check --backintDataParamFile /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/config/plugin.conf --logDirs /usr/sap/HN1/HDB00/backup/log/ • To check a specific backup: hdbbackupdiag --check --backintDataParamFile /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/config/plugin.conf --logDirs /usr/sap/HN1/HDB00/backup/log/ -i 1429782842461 For more information, see the SAP article Determining and Checking Backups for Recovery (hdbbackupdiag Tool) located here: 24 Using SAP HANA CLI http://help.sap.com/saphelp_hanaplatform/helpdata/en/f6/ 0cd67cd71846a9ae3da198a78f7851/content.htm Checking the integrity of SAP HANA backup objects Check the integrity of a specific StoreOnce Catalyst backup requires the EBID. This ID is available from either HANA Studio under the EBID column for the specific backup or from the HP StoreOnce GUI; see the procedure below. Use the following command: hdbbackupcheck -v --backintParamFile -e For example: hdbbackupcheck -v --backintParamFile /hana/shared/HN1/hp/HP-Catalyst-SAP-HANA-Plugin/config/plugin.conf /usr/sap/HN1/SYS/global/hdb/backint/test_tag_databackup_4_1 -e 1429783549395_52271602 To get the ID from the HP StoreOnce GUI: 1. Log into the HP StoreOnce Management Console. 2. Navigate to HP StoreOnce→StoreOnce Catalyst→Stores. 3. Select the store containing the backups. 4. Select the Catalyst Item Summary tab. 5. Select the appropriate item. For more information, see the SAP article Manual Backup Checks (hdbbackupcheck Tool) located here: http://help.sap.com/saphelp_hanaplatform/helpdata/en/77/ 522ef1e3cb4d799bab33e0aeb9c93b/content.htm#loio0ab1ddd1d95e4b46ad32b7963e7b7e4d Performing SAP HANA restore operations You can restore your SAP HANA database to either the latest version or to an earlier version. Restoring to an earlier version requires the backup ID. IMPORTANT: HP recommends checking the backup before starting a recovery. Use the following command: HDBSettings.sh recoverSys.py --command="RECOVER DATABASE UNTIL TIMESTAMP '' USING DATA PATH ('') USING LOG PATH ('') CHECK ACCESS USING FILE" --wait Examples: • To restore to the latest version: HDBSettings.sh recoverSys.py --command="RECOVER DATABASE UNTIL TIMESTAMP '2015-04-23 15:41:58' USING DATA PATH ('/usr/sap/HN1/SYS/global/hdb/backint/') USING LOG PATH ('/usr/sap/HN1/HDB00/backup/log') CHECK ACCESS USING FILE" --wait • To restore to a specific version: HDBSettings.sh recoverSys.py --command="RECOVER DATABASE UNTIL TIMESTAMP '2015-04-23 15:41:58' USING DATA PATH ('/usr/sap/HN1/SYS/global/hdb/backint/') USING LOG PATH ('/usr/sap/HN1/HDB00/backup/log') USING BACKUP_ID 1429782842461 CHECK ACCESS USING FILE" --wait Checking the integrity of SAP HANA backup objects 25 NOTE: HP recommends using --wait to make the script wait until the recovery has finished before reporting back. Otherwise, you must manually check to find out if the recovery has finished. For more information, see these SAP articles: • Recover the Database Using the Command Line Tool located here: http://help.sap.com/saphelp_hanaplatform/helpdata/en/8f/ 42dffd50b14a3da72f1220cc7b0eaf/content.htm • Parameters for Recovery with Command Line Tool located here: http://help.sap.com/saphelp_hanaplatform/helpdata/en/27/ ee28dd489545aeaec3872ee05a4269/content.htm IMPORTANT: To restore from a StoreOnce Catalyst copy, you must modify the CATALYST_STORE_ADDRESS and CATALYST_STORE_NAME parameters in your plug-in configuration file. Modifying the copy-specific parameters is not enough when doing a restore because the CATALYST_STORE_ADDRESS and CATALYST_STORE_NAME parameters are used to determine the location of the Catalyst backups. Performing SAP HANA delete operations You can delete a specific backup or all backups prior to one you specify. NOTE: • HP recommends verifying that a backup exists before attempting to delete it. Delete a specific backup: hdbsql -n -i -u -p “BACKUP CATALOG DELETE BACKUP_ID [COMPLETE]" For example: hdbsql -n hanasystem.gbr.hp.com -i 00 -u SYSTEM -p mypassword "BACKUP CATALOG DELETE BACKUP_ID 1430230790389 COMPLETE" • Delete all backups prior to a specific one (does not delete the one specified): hdbsql -n -i -u -p "BACKUP CATALOG DELETE ALL BEFORE BACKUP_ID [COMPLETE]" For example: hdbsql -n hanasystem.gbr.hp.com -i 00 -u SYSTEM -p HP1nv3nt "BACKUP CATALOG DELETE ALL BEFORE BACKUP_ID 1430231552343 COMPLETE" NOTE: HP recommends using the COMPLETE option to delete the backup from both the server and the catalog. To delete the backup from the catalog only, omit the COMPLETE option. For more information, see the SAP article SQL Statements for Deleting Backups from the Backup Catalog located here: http://help.sap.com/saphelp_hanaplatform/helpdata/en/88/ 642f787c69409e992cde90a38c3450/content.htm?frameset=/en/8b/ 7ef236687c4abb98a920792d0ee629/frameset.htm¤t_toc=/en/00/ 0ca1e3486640ef8b884cdf1a050fbb/plain.htm&node_id=362 26 Using SAP HANA CLI 9 Performing HP StoreOnce Catalyst Copy Operations NOTE: SAP HANA managed copy is not supported by SAP HANA; use the HP StoreOnce Catalyst Copy tool provided to manage disaster recovery copies. Before starting the HP StoreOnce Catalyst Copy tool, make sure you have configured your source and destination store details in the configuration file either during the installation process or by manually editing the configuration file. The executable file StoreOnceCatalystCopy is located in the bin directory of the SAP HANA Plug-in installation on the SAP HANA appliance; if you used the default installation path, the directory location is /hana/shared//hp/HP-Catalyst-SAP-HANA-Plugin/bin. NOTE: By default, the source and destination StoreOnce Catalyst store details are read from the plugin.config file located in the config folder. This can be modified; see Table 5 (page 28). The HP StoreOnce Catalyst Copy tool supports the following operations: Table 4 StoreOnce Catalyst Copy Operations Command Syntax Description Help Show the help for the HP StoreOnceCatalystCopy tool. ./StoreOnceCatalystCopy --help ./StoreOnceCatalystCopy -h Copy ./StoreOnceCatalystCopy --copy ./StoreOnceCatalystCopy –c Queue a copy job from the origin to the destination StoreOnce Catalyst store. Different options and filters can be user to choose which objects to copy. The configuration file is read, by default, to determine the origin and destination addresses and StoreOnce Catalyst store names. These names can be overridden on the command line if necessary. Copy operations of asynchronous, non-blocking operations: after initiating a copy, the command prompt will return. Use in combination with --list to poll for completed StoreOnce Catalyst copies. List ./StoreOnceCatalystCopy --list ./StoreOnceCatalystCopy -l Cancel ./StoreOnceCatalystCopy --cancel ./StoreOnceCatalystCopy -x Expire-items ./StoreOnceCatalystCopy –expire-items ./StoreOnceCatalystCopy -e Version ./StoreOnceCatalystCopy --version List the status of all running and queued StoreOnce Catalyst copy jobs. Filters can be user to limit or filter the output. Cancel all queued StoreOnce Catalyst copies. Filters can be used to cancel specific copies only. Use --preview with this command to first preview which StoreOnce Catalyst copy jobs will be cancelled. Maintain synchronization between the source and target stores. This command deletes StoreOnce Catalyst items in the destination store that no longer exist in the source Catalyst store but were created by that source store. Filters can be used to delete specific copies only. Use --preview with this command to first preview which StoreOnce Catalyst items jobs will be deleted. Check the version of the HP StoreOnce Catalyst Copy tool. 27 The following options can be used with the commands above. Run ./StoreOnceCatalystCopy --help for more details. Table 5 Options to Modify Copy Operations Option Description filterkey Filter items based on their key/name. filtertagsand Filter items based on their StoreOnce Catalyst tag (exact match only). filtercreateddaterange Only display StoreOnce Catalyst items that were created within a specific date range. The date should use local time in the dd/mm/yyyy-hr:min:sec format. filterqueuedfromaddress Filter jobs according to the client address that queued the copy job. filterstatus Filter jobs according to the current copy status. preview Do not execute the command but preview what will happen if executed. HP recommends always using the --preview option before calling “expire-items” and “cancel.” config Change the configuration file the parameters are read from. IMPORTANT: The configuration file plugin.conf will be used by the HP StoreOnce Catalyst Copy tool to determine the source and destination information. These details can be overridden on the command line or by providing the tool with the name of a different configuration file. Automating the use of the HP StoreOnce Catalyst Copy tool StoreOnceCatalystCopy can be run in a number of ways depending on your needs: • Manually on the command line. Run StoreOnceCatalystCopy manually at the command line. • Automated via script, after running a scripted Data backup. Modify a hdbsql script to call StoreOnceCatalystCopy after a data backup completes. • Automated via Linux Crontab. Using Linux Crontab, StoreOnceCatalystCopy can be scheduled based on needs. For instance, if performing log backups to StoreOnce a Crontab schedule can be created to copy “new” logs once every 30 minutes, or every hour, etc. The same approach can be taken for scheduled data backups. IMPORTANT: HP recommends running StoreOnceCatalystCopy soon after performing a data backup. In cases where multiple data backups are copied in one operation, deduplicaton ratios can be lower compared to copying them sequentially. If you copy lots of data backups in one operation, HP recommends reducing the “Maximum Concurrent Outbound Catalyst Copy Jobs” from the StoreOnce GUI of the origin StoreOnce system. 28 Performing HP StoreOnce Catalyst Copy Operations 10 Troubleshooting Useful log files are located in the following directories if the installation used the default path: • • /hana/shared//hp/HP-Catalyst-SAP-HANA-Plugin/logs ◦ Catalyst_SAPHana.log ◦ Connector_SAPHana.log /hana/shared//HDB//trace ◦ backint.log ◦ backup.log The following table lists common SAP HANA Plug-in setup and installation problems and solutions. Symptom Possible Cause Solutions Error message: No configuration file assigned under “Backint Parameter File.” Provide the path to the configuration file. Could not back up system See “Configuring SAP HANA Studio” (page 15) for more details. backup could not be completed, Backint exited with exit code 1 instead of 0. console output: ERROR: Option "-p=" is required for operation "-f=". Error message: The configuration file assigned does not exist or is in the wrong format. Verify the configuration file exists. If so, compare the file with the template (plugin_template.conf) to check formatting and values. Backint agent is not shown in SAP HANA Studio. The symbolic link to Backint does not exist. Navigate to the /usr/sap// SYS/global/hdb/opt path and ensure a symbolic link to “backint” exists. This path assumes the installation used the default path. If you changed the location of the plug-in, update the path and try again. If running on a scale out SAP HANA appliance, ensure the plug-in is installed on all nodes in the cluster. Error message: The backup ID is not valid. Check if the backup you are trying to restore is valid by using the check backup tool. See “Checking SAP HANA Backup for Recovery” (page 24) for more details. Could not back up system backup could not be completed, Backint exited with exit code 1 instead of 0. console output: Logger not initialized. Message : Unable to read config file '' ERROR RECOVERY RECOVER DATA finished with error: [449] recovery strategy could not be determined, [111014] The backup with backup id '1430' cannot be used for recovery recoverSys failed 29 11 Support and Other Resources Contacting HP For worldwide technical support information, see the HP Support Center: http://www.hp.com/go/hpsc Before contacting HP, collect the following information: • Product model names and numbers • Technical support registration number (if applicable) • Product serial numbers • Error messages • Operating system type and revision level • Detailed questions Related information Product documentation For the most recent user documentation, see the HP Enterprise Storage Information Library website: www.hp.com/go/storage/docs Select HP StoreOnce Backup and then select your product. The following documents provide information about the HP StoreOnce Backup system: • HP StoreOnce 6500 and B6200 Backup system user guide: This guide contains detailed information on using the Web Management Interface. It also contains information on using the HP StoreOnce Catalyst feature. • HP StoreOnce 2700, 2900, 4500, 4700, and 4900 Backup system user guide: This guide contains detailed information on using the Web Management Interface. It also contains information on using the HP StoreOnce Catalyst feature. • HP StoreOnce Backup system Concepts and Configuration Guidelines: This guide advises how to plan the workload being placed on the HP StoreOnce Backup system in order to optimize performance and minimize the impact of deduplication, replication, and housekeeping operations competing for resources. • HP StoreOnce Backup system CLI Reference Guide: This is the complete reference guide for the CLI command set. Some tasks can only be carried out from the CLI. Other useful websites 30 • HP Website: http://www.hp.com • HP Storage Products: http://www.hp.com/go/storage • HP Storage Information Library: http://www.hp.com/go/storage/docs • HP Enterprise Backup Solutions Overview: http://www.hp.com/go/ebs • HP Technical Support website: http://www.hp.com/support • HP Technical Support Downloads website: http://www.hp.com/support/downloads • HP Single Point of Connectivity Knowledge (SPOCK) website: http://www.hp.com/storage/ spock Support and Other Resources • HP partner and store locator: http://www.hp.com/service_locator • White papers and Analyst reports: http://www.hp.com/storage/whitepapers Typographic conventions Table 6 Document conventions Convention Element Blue text: Table 6 (page 31) • Cross-reference links and e-mail addresses • A cross reference to the glossary definition of the term in blue text Blue, bold, underlined text email addresses Blue, underlined text: http://www.hp.com Website addresses Bold text • Keys that are pressed • Text typed into a GUI element, such as a box • GUI elements that are clicked or selected, such as menu and list items, buttons, tabs, and check boxes Italic text Text emphasis Monospace text • File and directory names • System output • Code • Commands, their arguments, and argument values Monospace, italic text • Code variables • Command variables Monospace, bold text WARNING! CAUTION: IMPORTANT: NOTE: TIP: Emphasized monospace text Indicates that failure to follow directions could result in bodily harm or death. Indicates that failure to follow directions could result in damage to equipment or data. Provides clarifying information or specific instructions. Provides additional information. Provides helpful hints and shortcuts. Typographic conventions 31 12 Documentation feedback HP is committed to providing documentation that meets your needs. To help us improve the documentation, send any errors, suggestions, or comments to Documentation Feedback ([email protected]). Include the document title and part number, version number, or the URL when submitting your feedback. 32 Documentation feedback Index A H access control, configuring, 7 help obtaining, 30 HP technical support, 30 HP StoreOnce Catalyst, 5 benefits, 5 defined, 5 terminology, 5 B backup ID extracting with CLI, 23 backups canceling using CLI, 24 checking for recovery, 24 checking object integrity, 25 using CLI, 23 using SAP HANA Studio, 17 benefits of HP StoreOnce Catalyst, 5 I installing SAP HANA Plug-in, 11 C O canceling SAP HANA backups, 24 Catalyst see HP StoreOnce Catalyst CLI, 23 canceling SAP HANA backups, 24 checking backup object integrity, 25 checking backups for recovery, 24 configuring, 23 deletes, 26 extracting backup ID, 23 restores, 25 SAP HANA backups, 23 command line interface see CLI configuration file parameters, 13 configuring access control, 7 SAP HANA Plug-in, 11 SAP HANA Studio, 15 contacting HP, 30 conventions document, 31 text symbols, 31 copy StoreOnce Catalyst, 27 creating Catalyst stores, 7 Federated Catalyst stores, 7 opening SAP HANA Plug-in, 11 operations SAP HANA backups, 17 SAP HANA deletes, 21 SAP HANA restores, 18 StoreOnce Catalyst copy, 27 overview, 4 D deletes using CLI, 26 using SAP HANA Studio, 21 document conventions, 31 documentation providing feedback on, 32 related information, 30 P performing SAP HANA backups, 17 SAP HANA deletes, 21 SAP HANA operations, 17 SAP HANA restores, 18 StoreOnce Catalyst copies, 27 prerequisites, 4 R restores using CLI, 25 using SAP HANA Studio, 18 S SAP HANA backups, 17 CLI, 23 configuring CLI, 23 deletes, 21 operations with SAP HANA Studio, 17 restores, 18 SAP HANA Plug-in configuring, 11 installing, 11 opening, 11 prerequisites, 4 uninstalling, 14 SAP HANA Studio configuring, 15 performing SAP HANA operations, 17 33 StoreOnce Catalyst over Fibre Channel prerequisites, 8 StoreOnce Catalyst copies performing, 27 symbols in text, 31 T technical support HP, 30 terminology of HP StoreOnce Catalyst, 5 text symbols, 31 troubleshooting, 29 typographic conventions, 31 U uninstalling SAP HANA Plug-in, 14 using SAP HANA CLI, 23 W websites, 30 34 Index