The SAP HANA Academy has published a new video in the series SAP HANA SPS 7 Backup and Recovery.
In this video, we briefly introduce you how to work with the Backup Catalog and the monitoring views M_BACKUP_CATALOG and M_BACKUP_CATALOG_FILES.
This query, for examples, get’s you all the data and log backup files needed to recover using the latest backup
- The SAP GUI has a macro recording tool much like Excel does. It records macros in VBScript which is nearly identical to Excel VBA and can usually be copied and pasted into an Excel macro directly. Example Code. Here is a simple example based on a SAP system I have access to.
- SAP Cloud Platformでは、ワンクリックでData Provisioning サーバ(DPサーバ)をアクティブ化でき、HANAシステムにDP delivery unitをインポートする手順が不要です。 設定にはSAP Cloud Platformのサービスとして提供されているSAP Web IDEフルスタックを使用します。オンプレ.
Learning how to export data from SAP to Excel is a helpful skill to have for all users of SAP. If you have been having problems with exporting data from SAP to Excel, then you should know that there are a number of ways to perform this. How to Export Data from SAP to Excel. Exporting Data: Option 1. The first thing is to click on the list menu.
hdbbackupcheck
The main part of the tutorial video is about a new tool introduced with SAP HANA 1.0 SPS 7 (or revision 64 to be exact): hdbbackupcheck.
You can use the hdbbackupcheck tool to check (data or log) backup files for changes, e.g. after the files have been transferred from the database to an external backup tool. The tool imports the backup file, checks the metadata for correctness and consistency, and checks whether contents have changed.
hana:/usr/sap/DB1/HDB01> hdbbackupcheck -h
Usage: hdbbackupcheck [options] <backup> [-i <backupid>] [-e <ebid>]
Options:
-v: display all known information
–backintParamFile <filename>: use parameter file specified for a backint call
hana:/usr/sap/DB1/HDB01>
The tool is called with the data or log backup file as input and, optionally, a -v (erbose) flag for more detailed output. The file can be checked against a backup ID or, when using BACKINT, an external backup id (EBID).
The interesting aspect about this tool is that it can be used outside of the context of a SAP HANA installation on any SUSE Linux host.
hana:/usr/sap/DB1/HDB01/backup/log> cdexe
hana:/usr/sap/DB1/SYS/exe/hdb> hdbbackupcheckpack hdbcheck
a hdbbackupcheck
a libhdbbackup.so
a libhdbbasement.so
a libhdbbasis.so
a libhdbconfig.so
a libhdbcrypto.so
a libhdbcsbase.so
a libhdbdataaccess.so
a libhdblicensing.so
a libhdblttbase.so
a libhdbpersistence.so
a libhdbtransactionmanager.so
a libhdbunifiedtable.so
a libhdbunifiedtypes.so
a libhdbversion.so
a libicudata.so.46
a libicui18n.so.46
a libicuuc.so.46
a libirc.so
a libxmldom.so
hana:/usr/sap/DB1/SYS/exe/hdb> cp hdbcheck $HOME
hana:/usr/sap/DB1/SYS/exe/hdb> cd $HOME
hana:~> mkdir hdbcheckdir
hana:~> mv hdbcheck hdbcheckdir/
hana:~> cp $DIR_INSTANCE/exe/SAPCAR hdbcheckdir/
hana:~> cd hdbcheckdir
hana:~/hdbcheckdir> ll
total 145980
-rw-r—– 1 db1adm sapsys 145155119 2014-01-24 16:36 hdbcheck
-rwxr-x— 1 db1adm sapsys 4170776 2014-01-24 16:39 SAPCAR
hana:~/hdbcheckdir> ./SAPCAR -xvf hdbcheck
SAPCAR: processing archive hdbcheck (version 2.01)
x hdbbackupcheck
x libhdbbackup.so
x libhdbbasement.so
x libhdbbasis.so
x libhdbconfig.so
x libhdbcrypto.so
x libhdbcsbase.so Presspercent serial.
x libhdbdataaccess.so
x libhdblicensing.so
x libhdblttbase.so
x libhdbpersistence.so
x libhdbtransactionmanager.so
x libhdbunifiedtable.so
x libhdbunifiedtypes.so
x libhdbversion.so
x libicudata.so.46
x libicui18n.so.46
x libicuuc.so.46
x libirc.so
x libxmldom.so
SAPCAR: 20 file(s) extracted
hana:~/hdbcheckdir> export LD_LIBRARY_PATH=~/hdbcheckdir:$LD_LIBRARY_PATH
hana:~/hdbcheckdir> ./hdbbackupcheck
Usage: ./hdbbackupcheck [options] <backup> [-i <backupid>] [-e <ebid>]
Options:
-v: display all known information
–backintParamFile <filename>: use parameter file specified for a backint call
hana:~/hdbcheckdir>
The tool hdbbackupcheck is documented in the SAP HANA Administration Guide for SPS 7 and SAP Note 1869119
hdbbackupdiag
The other tool demonstrated, is hdbbackupdiag. In SPS 7 a new flag is introduced, which is somewhat confusingly called check, as it does not do what hdbbackupcheck does.
With flag –check, hdbbackupdiag checks if
- the location (file system) or external backup tool is correct
- the current operating system user has read authorization for the file
- the backup ID corresponds to the backup ID specified in the backup catalog
hana:~/hdbcheckdir> hdbbackupdiag -h
Sap Sapcar Exel File
Usage: hdbbackupdiag [options] [-d <directory>] { -b <backup> | -c <backup catalog> }
Options:
–generate: generates a new backup catalog using data path given by –dataDir and log paths given by –logDirs options
–dump: dumps the content of the backup catalog
NEW in SPS 7
–check: check for files using data path given by –dataDir and log paths given by –logDirs options
–useBackintForCatalog: search backup catalog in backint if –check is given
–backintDataParamFile <filename>: backint parameter file to use if –check is given
–backintLogParamFile <filename>: backint parameter file for log backups to use if –check is given
-i <backup_id>: check files beginning with given backup id
Meth crack back patterns. -f: display filenames only
-v: display all known information
-u “YYYY-MM-DD HH:MM:SS”: defines UNTIL timestamp in UTC
Notes:
if -d is not defined the current directory will be used otherwise the specified directory must be an absolute path
the specified backup_catalog or backup must be relative to current directory or the directory specified with -d
hana:~/hdbcheckdir>
Another usage for the hdbbackupdiag tool is the (re-)generation of the backup catalog (Note 1812057).
The tool hdbbackupidag is documented in the SAP HANA Administration Guide for SPS 7 and SAP Notes 1873247 and 1812057
Sap Sapcar Exel 2017
SAP HANA Academy
Denys van Kempen