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 |
Time stamp for first page of log backup |
DB Stamp 2 Date |
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.