1 Reply Latest reply: Mar 22, 2013 1:39 AM by ktenzer RSS

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

Norbert.Sommer
Currently Being Moderated

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
    ktenzer
    Currently Being Moderated
    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

More Like This

  • Retrieving data ...