Community

Subscribe
Highlighted

MaxDB 7.8 "backup_template <..> to external snapshot" command

Hi all,

snapshot backups would normally not be visible in the MaxDB GUI tools but
MaxDB 7.8 has a new feature mentioned in SAP documents about "New Features in MaxDB 7.8"

which seems to be able to do exactly that:

backup_template_create <template_name> to external snapshot

backup_start <template_name>
<create snapshot>
backup_finish <template_name> ExternalBackupID <Returned ID>. | <template_name> as failed with error <tool_rc> .

Haven't been able to find much documentation about this feature yet.

I think with a slightly more complicated command set this was also possible with MaxDB 7.7.

Any examples of this working in a Netapp environment ?

Would be too much to ask if this would work in reverse for a restore as the the SnapCreator client would need to
tell the sc server to restore sc backup set ?

 

Thanks and Kind Regards, Norbert

Re: MaxDB 7.8 "backup_template <..> to external snapshot" command

Hi Nobert,
First you need to create a backup template
                  1) Create Media-Template for archive logs if it doesnt exist
dbmcli –d <DB> -u <user>,<password> medium_put autosave /sapdb/<DB>/saparch/<DB>LOG FILE AUTO
2) Create Fullbackup-Template for snapshots
dbmcli –d <DB> -u <user>,<password> backup_template_create na_snap to EXTERNAL SNAPSHOT
3) Run a full backup
dbmcli –d <DB> -u <user>,<password> util_connect backup_start na_snap backup_finish na_snap ExternalBackupID first_full_fake_backup exit
4) Activate MaxDB archive logging if not active
dbmcli –d <DB> -u <user>,<password> autolog_on
Deactivate any other templates or delete them
MaxDB settings in SC configuration:
XUSER_ENABLE=N
HANDLE_LOGWRITER=Y
DBMCLICMD=/sapdb/programs/bin/dbmcli
SQLCLICMD=/sapdb/programs/bin/sqlcli
MAXDB_UPDATE_HIST_LOG=Y
MAXDB_DATABASES=<database>:<user>/<password>
MAXDB_BACKUP_TEMPLATES=<database>:na_snap  
Archive log settings in SC configuration:
ARCHIVE_LOG_ENABLE=Y
ARCHIVE_LOG_RETENTION=4
ARCHIVE_LOG_DIR=/sapdb/<database>/saparch
ARCHIVE_LOG_EXT=*
Regards,
Keith