Procedure documentationComplete Data Backup to a File Locate this document in the navigation structure

 

You back up all the data in the data area of the database instance to a file.

You can display the status of the backup operation with the DBM command backup_state. When you execute this command, the system displays the progress of the backup.

Scenario

You want to execute a complete data backup to a file.

You have defined a backup template of type FILE with the name DemoDataCompl for the incremental backup.

Prerequisites

You can find the prerequisites under Database Manager CLI, backup_start, backup_state.

Procedure

  1. Call the Database Manager CLI in session mode, log on as operator OLEG with password MONDAY, and connect to database instance DEMODB

    >dbmcli -u OLEG,MONDAY -d DEMODB

    dbmcli on DEMODB>

  2. Open a database session

    dbmcli on DEMODB>db_connect

    OK

  3. Start the backup operation using the backup template DemoDataCompl

    dbmcli on DEMODB>backup_start DemoDataCompl

    OK

    Returncode 0

    Date 20051103

    Time 00083316

    Server GENUA

    Database DB7.6

    Kernel Version Kernel 7.6.00 Build 018-003-000-000

    Pages Transferred 3800

    Pages Left 0

    Volumes 1

    Medianame DemoDataCompl

    Location Backups 2005\Data\completeDataJan

    Errortext

    Label DAT_000000010

    Is Consistent true

    First LOG Page 11934

    Last LOG Page

    DB Stamp 1 Date 20051103

    DB Stamp 1 Time 00083316

    DB Stamp 2 Date

    DB Stamp 2 Time

    Page Count 5667

    Devices Used 1

    Database ID GENUA:DEMODB_20051014_142158

    Max Used Data Page 0

    Converter Page Count 11

    ---

    dbmcli on DEMODB>

Result

After you have executed the DBM command, information about the backup is output. This information is only output when the backup has been completed or interrupted. The response to this DBM command can therefore take a long time.