MAX DB CLI backup

[Former Member]

Dear All,

I'm new to max db and we have SAP DMS server in AIX 7.1 with

7.8.02.26 /sapdb/SDB/db

7.8.02.26 /sapdb/CDB/db

I created a backup template using HowTo - SAP MaxDB Backup with Database Manager CLI guide and

managed to take the SDB & CDB backup to a external NAS.But the backup file is 3.5 MB .

This is same for Dev,Qty, and production.

Our production DMS aserver SDB db is around 40 GB, backup is 3.5 MB.

What's wrong with this backup...?

Please help...

backup_template_create SDB_backup to FILE

/mnt/backup/BACKUP/SDB_prd_backup CONTENT DATA

dbmcli on SDB>backup_start SDB_backup

OK

Returncode 0

Date 20150202

Time 00140829

Server bobjdms2

Database SDB

Kernel Version Kernel 7.8.02 Build 026-121-243-456

Pages Transferred 432

Pages Left 0

Volumes 1

Medianame SDB_backup

Location /mnt/backup/BACKUP/SDB_dev_backup

Errortext

Label DAT_000000003

Is Consistent true

First LOG Page 420

Last LOG Page

DB Stamp 1 Date 20150202

DB Stamp 1 Time 00140829

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 409

Devices Used 1

Database ID bobjdms2:SDB_20150130_155905

Max Used Data Page 0

Converter Page Count 10

[thorsten_zielke]

Hi,

from the attached backup log I do not see any error, although I agree that there has not been much backed up. What was the exact backup statement - maybe you have performed just a 'save pages'?

Have you tried to do a recovery test on a different system with that backup?

If you want me to look further, please create a 'diagpack' archive of the MaxDB log files (dbmcli -d <db_name> -u <user,pwd> diag_pack) and upload it via:

https://mdocs.sap.com/mcm/public/v1/open?shr=wEwYg_VA7dJZKVw5BjzSBij_AXYayoChNHmP26TExog

Thorsten