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)
-
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
-
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
-
Type the following command to execute the offline full backup.
#> dbmcli -d CERT1 -u dbm,dbm -uUTL -c backup_start BackData2 Migration
-
A return code of 0 means the backup was successful.
ok Return Code 0
Online (Warm)
-
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
-
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
-
Type the command to run the online full backup.
# dbmcli -d CERT1 -u dbm,dbm -uUTL -c backup_Start BackData2 Recovery
-
A return code of 0 means the backup was successful.
ok Return Code 0