Data Backup and Recovery Discussions

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

1 REPLY 1

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
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public