# Performing a SAP MaxDB Full Backup

After you configure the instance, BACKINT interface, and parameter file, perform your first backup.

A full backup contains the backup of an entire database. The full backup becomes a baseline to which subsequent incremental backups are applied should data restoration be requested.

The SAP MaxDB iDataAgent backs up the following types of data:

- All the database files

- Log Files

- Configuration Files which include the parameter files (param file)

The SAP MaxDB iDataAgent does not backup the SAP MaxDB application files associated with the SAP MaxDB installation.

## Procedure

### Offline (Cold)

1. Open the DBM command line interface and verify the status of the database. Type the following command:

       #> dbmcli -d $[CERT1] -u $[dbm,dbm] -uUTL
        dbmcli on CERT1>db_state
        OK
        State
        ADMIN

2. The SAP MaxDB database must be in the admin (cold) state. If the database is not in this mode, type the following command.

       #> dbmcli -d $[CERT1] -u $[dbm,dbm] db_cold

3. Type the following command to execute the offline full backup.

       #> dbmcli -d $[CERT1] -u $[dbm,dbm] -uUTL -c backup_start BackData2 Migration

4. A return code of 0 means the backup was successful.

       ok
        Return Code 0

### Online (Warm)

1. Open the DBM command line interface and verify the status of the database. Type the following command:

       #> dbmcli -d $[CERT1] -u $[dbm,dbm] -uUTL
        dbmcli on CERT1>db_state
        OK
        State
        ONLINE

2. The SAP MaxDB database must be in the online (warm) state. If the database is not in this mode, type the following command.

        #> dbmcli -d $[DBsid] -u $[dbm,dbm] db_warm

3. Type the command to run the online full backup.

       # dbmcli -d $[CERT1] -u $[dbm,dbm] -uUTL -c backup_Start BackData2 Recovery

4. A return code of 0 means the backup was successful.

       ok
        Return Code 0

×

Loading...