autorecover
With this command you start the automatic recovery of the database.
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.
-
You have the server permission Recovery.
-
You have opened a database session (see: db_connect).
autorecover [LOG] [UNTIL <date> <time>] [<backup_spec>]
<backup_spec> :: = <key_label_spec> | IBID <backup_ID>
<key_label_spec> :: = KEY <key> LABEL <label>
|
Option |
Description |
|---|---|
|
LOG |
Only log backups should be imported to recover the database. As per the default value, Database Manager imports data backups 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, Database Manager imports all available data backups, log backups, and the content of the log volume to restore the most recent possible state of the database system. |
|
KEY <key> |
Key of the first backup to be imported You can find this value in the backup history. |
|
LABEL <label> |
Backup ID of the first backup to be imported You can find this value in the backup history. |
|
IBID <backup_ID> |
Backup ID consisting of a <key> and <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 into the DBM command line. |
OK
...
...
|
Value |
Description |
|---|---|
|
Date |
Date |
|
Time |
Start time of the backup |
|
Server |
Name of the database computer |
|
Database |
Name of the database |
|
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 See also: Messages documentation |
|
Label |
Backup ID |
|
Is Consistent |
Only for data backup: Backup is internally consistent |
|
First LOG Page |
For data backup: First page of the log backup to be read For log backup: First page saved in the log area |
|
Last LOG Page |
For log backup only: Last page saved in the log area |
|
DB Stamp 1 Date DB Stamp 1 Time |
Time stamp for the first page of the log backup |
|
DB Stamp 2 Date DB Stamp 2 Time |
Time stamp for the last page of the 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 |
|
Max Used Data Page |
Page number, use this number to compute the amount of space that should be at least available in the target system for the data pages (page number * 8 KB) |
|
Converter page count |
Converter page count, use this number to count the converter size |
|
Redo Transactions Read |
|
|
Redo Transactions Done |
In the event of errors, see Reply Format.
Database Administration, Restoring Databases