autorecover

Use

You start the automatic recovery of the database instance.

The system uses the backup history to determine which backups to use for the recovery. If the backups are files or were created with third-party backup tools, the system also checks whether the corresponding backups can be accessed.

See also:

Concepts of the Database System, Backing Up and Restoring

Prerequisites

?     You have the server authorization Recovery.

?     You have opened a database session (see: db_connect).

Syntax

autorecover [LOG] [UNTIL <date> <time>] [<backup_spec>]

<backup_spec> :: = <key_label_spec> | IBID <backup_ID>

<key_label_spec> :: = KEY <key> LABEL <label>

Options

Option

Description

LOG

Only log backups are used to recover the database instance.

The Database Manager default value uses data and log backups.

UNTIL <date> <time>

<date> ::= <yyyymmdd>

<time> ::= <hhmmss>

All database system content up to this point in time will be recovered.

<date>: year, month, day

<time>: hours, minutes, seconds

If you do not specify this option, the Database Manager uses all available data and log backups and the content of the log volume to restore the most recent possible state.

KEY <key>

Key of the first backup to be read

You can find this value in the backup history

LABEL <label>

Backup ID of the first backup to be read

You can find this value in the backup history

IBID <backup_ID>

Backup ID consisting of a <key> and a <label>, separated by a vertical slash (|)

This notation refers to the output in the backup history and makes it possible to simply copy this specification from the backup history to the DBM command.

Reply

OK

Returncode              <value>

Date                    [<value>]

Time                    [<value>]

Server                  [<value>]

Database                [<value>]

Kernel Version          [<value>]

Pages Transferred       [<value>]

Pages Left              [<value>]

Volume Count            [<value>]

Medianame               [<value>]

Location                [<value>]

Errortext               [<value>]

Label                   [<value>]

Is Consistent           [<value>]

First LOG Page          [<value>]

Last LOG Page           [<value>]

DB Stamp 1 Date         [<value>]

DB Stamp 1 Time         [<value>]

DB Stamp 2 Date         [<value>]

DB Stamp 2 Time         [<value>]

Page Count              [<value>]

Devices Used            [<value>]

Values for the Reply Fields

Field

Description

Date

Date

Time

Start time of backup

Server

Name of the database computer

Database

Name of the database instance

Kernel Version

Version of the database kernel

Pages Transferred

Number of pages transferred

Pages Left

Number of pages still to be transferred

Volumes

Number of data carriers used

Medianame

Name of the backup template.

Location

File or device name

Errortext

Error message text

Label

Backup ID

Is Consistent

For data backup only: backup is internally consistent

First LOG Page

For data backup: first page of log backup to be imported

For log backup: first page saved in log

Last LOG Page

For log backup only: last page saved in log

DB Stamp 1 Date
DB Stamp 1 Time

Time stamp for first page of log backup

DB Stamp 2 Date
DB Stamp 2 Time

Time stamp for last page of log backup

Page Count

Total number of pages backed up

Devices Used

Number of backup devices used

Database ID

Database ID used to identify data and log backups that belong together

In the event of errors, see Reply Format.