Log Backup to a Pipe

Use

You back up the data in the log area of the database system to a pipe.

It is not possible to back up the data in the log area to a pipe with automatic log backup.

You can display the status of the backup operation with the DBM command backup_state. Each time you execute this DBM command, the system displays the current status of the backup.

To read the prerequisites, see Database Manager CLI, backup_start, backup_state

See also:

Defining a Backup Template for Log Backup to a Pipe

Displaying the Backup Status

Concepts of the Database System, Backing Up Data

Scenario

You want to back up the log area to a pipe. You have already executed a data backup and have defined a backup template of type PIPE with the name DemoPipeLog for the log backup.

For testing purposes, DEMODB was configured so that the log area is overwritten as soon as it is full. To back up the log area, you first have to switch off overwrite mode.

The database instance is in the ONLINE or the ADMIN operational state.

Procedure

...

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

>dbmcli –u OLEG,MONDAY –d DEMODB

dbmcli on DEMODB>

       2.      Switch off overwrite mode for the log area:

dbmcli on DEMODB>db_execute SET LOG AUTO OVERWRITE OFF

       3.      Open a database session:

dbmcli on DEMODB>db_connect

OK

       4.      Start the backup operation using the backup template named DemoPipeLog.

dbmcli on DEMODB>backup_start DemoPipeLog

Result

The data is read from the Database Manager to the pipe. You now need to start the backup tool in order to transfer the data from the pipe to the data carrier of the backup tool.

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