Background documentationarchive_stage_repeat Locate this document in the navigation structure

 

You can create multiple copies of the original log backup files on different data carriers. The system then checks whether the copying was successful.

With the help of options, you can control whether the copied files should be compared with the original files for security reasons, and whether the original files should be deleted after copying.

You can only execute this DBM command immediately after the DBM command for creating a single copy of the log backup files (archive_stage command), and in the same DBM server session. When you execute the archive_stage_repeat command, exactly the same log backup files are copied again as were copied using the archive_stage command.

Once you specify the KEEP option, you can repeat the command any number of times while also specifying backup templates for various data carriers.

Only if you do not specify this option are the original log backup files deleted after the copying is performed, and information about the archived log backup files is displayed for you.

The archived log backup files are assigned their own external backup IDs and are entered in the backup history.

See also:

Prerequisites

  • You have the server permission Backup.

  • You have executed the DBM command for creating a single copy of the log backup files using the KEEP option, and you are still within the same DBM server session (see: archive_stage).

  • The backup templates for the data carriers are defined for the backup type LOG (see: medium_put).

Structure

archive_stage_repeat <ext_backup_medium> [NOVERIFY] [KEEP]

Options

Option

Description

<ext_backup_medium>

Name of the backup template

NOVERIFY

The system only performs the standard checks to determine whether the backup was successful. The system displays error messages where appropriate, and the output of the backup tools.

If you do not specify this option, then the system additionally compares the content of the archived files with the content of the original files (system default).

KEEP

The original files are archived but are not deleted afterwards.

If you do not specify this option, then the original files are deleted after they have been successfully archived on the data carrier (system default).

Result

OK

Processed Stage Files <number>

Bytes Processed <number>

Deleted Stage Files <number>

Remaining Stage Files <number>

Values for the Reply Fields

Value

Description

Processed Stage Files

Processed log backup files

Bytes Processed

Processed bytes

Deleted Stage Files

Deleted log backup files

Remaining Stage Files

Remaining log backup files

<number>

Number

Example

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

>dbmcli -u OLEG,MONDAY -d DEMODB

dbmcli on DEMODB>

The backup files were created using the backup template DemoFileLog. You first want to archive them on the LOCATION_1 data carrier. The system should perform the standard checks to determine whether the backup was successful. The content of the archived files should also be compared with the content of the original log backup files (system default). The original files should not be deleted afterwards:

dbmcli on DEMODB>archive_stage LOCATION_1 DemoFileLog KEEP

OK

Processed Stage Files 9

Bytes Processed 12845056

Deleted Stage Files 0

Remaining Stage Files 2

You then want to archive the log backup files on the LOCATION_2 data carrier. Only the usual system checks are to be performed. The original files should be deleted afterwards (system default):

dbmcli on DEMODB>archive_stage_repeat LOCATION_2 NOVERIFY

OK

Processed Stage Files 9

Bytes Processed 12845056

Deleted Stage Files 9

Remaining Stage Files 0

More Information

Database Administration, Archiving Backup Files