Procedure documentationDisplaying the Backup Status Locate this document in the navigation structure

 

After you have started a backup, you can display its status using the Database Manager.

In addition to the open command line window in which you started the backup operation, open a second command line window in which you log on to the same database instance.

Scenario

You have started a complete backup to a tape. You now want to display the backup status.

Prerequisites

You can find the prerequisites under Database Manager CLI, backup_state

Procedure

In the following example, explanations of the output are displayed in bold and marked as comments with the number sign (#).

  1. Open a new command line window.

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

    >dbmcli –u OLEG,MONDAY –d DEMODB

    dbmcli on DEMODB>

  3. Execute the DBM command for displaying the backup status:

    dbmcli on DEMODB>backup_state

    OK

    Returncode 0

    Date 20051101

    Time 00113310

    Server GENUA

    Database DEMODB

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

    Pages Transferred 0

    Pages Left 0

    # The values for Pages Transferred and Pages Left tell you that the database system has started the backup and is trying to access the tape.

    Volumes

    Medianame

    Location

    Errortext

    Label

    Is Consistent

    First LOG Page

    Last LOG Page

    DB Stamp 1 Date

    DB Stamp 1 Time

    DB Stamp 2 Date

    DB Stamp 2 Time

    Page Count 0

    Devices Used 1

    Database ID GENUA:DEMODB_20051014_142158

    Max Used Data Page 0

    Converter Page Count

    Redo Transactions Read 0

    Redo Transactions Done 0

  4. Execute the DBM command for displaying the backup status again:

    dbmcli on DEMODB>backup_state

    OK

    Returncode 0

    Date 20051101

    Time 00113310

    Server GENUA

    Database DEMODB

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

    Pages Transferred 216

    Pages Left 3559

    # The values for Pages Transferred and Pages Left tell you that the database system is writing the data to the tape.

    Volumes

    Medianame

    Location

    Errortext

    Label

    Is Consistent

    First LOG Page

    Last LOG Page

    DB Stamp 1 Date

    DB Stamp 1 Time

    DB Stamp 2 Date

    DB Stamp 2 Time

    Page Count 3775

    Devices Used 1

    Database ID GENUA:DEMODB_20051014_142158

    Max Used Data Page 0

    Converter Page Count 11

    Redo Transactions Read 0

    Redo Transactions Done 0

  5. Execute the DBM command for displaying the backup status again:

    dbmcli on DEMODB>backup_state

    OK

    Returncode 0

    Date 20051101

    Time 00113310

    Server GENUA

    Database DEMODB

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

    Pages Transferred 3800

    Pages Left 0

    # The values for Pages Transferred and Pages Left tell you that the database system has finished writing data to the tape and is rewinding the tape.

    Volumes 1

    Medianame

    Location

    Errortext

    Label

    Is Consistent

    First LOG Page

    Last LOG Page

    DB Stamp 1 Date

    DB Stamp 1 Time

    DB Stamp 2 Date

    DB Stamp 2 Time

    Page Count 3800

    Devices Used 1

    Database ID GENUA:DEMODB_20051014_142158

    Max Used Data Page 0

    Converter Page Count 11

    Redo Transactions Read 0

    Redo Transactions Done 0

  6. Execute the DBM command for displaying the backup status again:

    dbmcli on DEMODB>backup_state

    OK

    Returncode 0

    Date

    Time

    Server

    Database

    Kernel Version

    Pages Transferred 0

    Pages Left 0

    # The values for Pages Transferred and Pages Left tell you that the backup operation has finished.

    Volumes

    Medianame

    Location

    Errortext

    Label

    Is Consistent

    First LOG Page

    Last LOG Page

    DB Stamp 1 Date

    DB Stamp 1 Time

    DB Stamp 2 Date

    DB Stamp 2 Time

    Page Count 0

    Devices Used

    Database ID

    Max Used Data Page

    Converter Page Count

    Redo Transactions Read 0

    Redo Transactions Done 0