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

[Norbert_Sommer]

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

[ktenzer]

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