Backup Strategy
The backup is taken using the
built-in database backup feature of SAP HANA DB.
Backup is taken for
Complete Data (Database Full Backup)
Log
Backup
Database full backup is taken using Perl
scripts which is scheduled on each db host
Database log backup is automatically
taken as per the interval configured in global.ini file
Data & log backup location can be
configured in global.ini file
Backup files retention is 5 days on
primary filer & 30 days on secondary filer.
Database Backup Process
Scheduled backup are taken to the
primary filer where it is retained for last 5 successful backups.
After 5 days it is moved to the secondary
filer where the retention is 30 days
Log backups are automatically taken
as per the interval mentioned in global.ini file (default 900 sec)
Archive log backups are moved to the
secondary filer after 5 days
Pre-requisites
and Recommendations:
To perform backups using
backup.pl script, the following requirements must be met:
- Backups
and recoveries can only be executed by users who have the system
privileges BACKUP_ADMIN and CATALOG_READ.
- BACKUP_ADMIN allows you to perform backups
and recoveries.
- CATALOG_READ allows you to
collect the information needed by the backup and recovery wizards
The backup process is executed as operating
system user adm (on Linux)
HDB Client Utility ‘HDBUSERSTORE’ should be
installed and entry key’s must be configured.
Backup.pl Script can be configured as:
Backup.pl Script can be configured as:
•Move latest
version of backup_bkp.pl to xyz/usr/sap/>/ à
•Check
whether
HDBUSERSTORE is installed on the system, if not install the client software.
•Configure
the
script using ‘-i’ option as
adm à xyz/usr/sap//backup_bkp.pl
–i
Below
are the steps which script automatically takes care when you execute the above
command:-
•
Creates
backup user in the database
•
Creates
user keys for backup and SYSTEM user in HDBUSERSTORE
•
If user
key of SYSTEM is configured in hdbuserstore, backup.pl will recognize this and
will not ask for SYSTEM password
Here are some functions
& features of the backup_test.pl
script
- Execute
the script as
ADM user - Using
client ‘HDBUSERSTORE’
- Backup
database command is executed as ‘BKPKEY’ user with BACKUP Admin privileges
- Once
full data backup is complete, script will manually copy all the required
ini files (described in
Configuration Backup) and make a tar file for the same
- Provides
backup history with detailed information
- HIM
team will schedule the backup using NetApp backup tool - snapcreator
·
Check whether any
parallel backup job is running.
Backup Technology (Log & Configuration):
Backup Capabilities
Backup Technology (Log & Configuration):
Log Archive Backups
On-demand
backup of log area is not possible
as of version SP4
and log area will be automatically backed
up as per the configuration in global.ini (default value of this is 900 Seconds)
Log
backup related Parameters
|
Options
|
Log_mode
|
normal / overwrite / legacy
|
Enable_auto_log_backup
|
yes / no
|
log_backup_timeout_s
|
|
basepath_logbackup
|
xyz/hdb/sid
|
Configuration Files Backups
Important Configuration Files are backed up as part of DB full backup which
enables to recover to the available configuration at the time of backup.
Backed-up
Configuration Files
|
From
Location
|
global.ini
indexserver.ini nameserver.ini |
xyz/usr/sap/sid
|
daemon.ini
sapprofile.ini |
xyz/usr/sap/
|
Backup Capabilities
Backup
Types
|
Feature
Availability
|
Remarks
|
Full
Database Backup
|
Y
|
Using ‘Perl’ script ‘backup_bkp.pl’ by means of
DISK based backup database feature of HANA
|
Log
Backup
|
Y
|
Automatic log archive backups using
configuration in global.ini
|
Configuration
Backup
|
Y
|
Using ‘Perl’ script ‘backup_bkp.pl’ by manually
copying important .ini files
|
Incremental/Differential Data Backup
|
N
|
Feature
not available as of version SP4.
|
No comments:
Post a Comment