recover_config

Use

You use this DBM command when you create a database instance. It enables you to create a new database instance with the same parameter values as an existing database instance. To do this, you need a complete backup of the existing database instance. You import the parameter file from this backup to the new database instance.

The copy of the parameter file is then stored in the <dependent_path> under the name of the current database instance.

If you use this command when creating a database copy or a standby instance, you should always check whether security reasons make it necessary to create these database instances on a different database computer than the original instance. If you do create the new instance on the same computer as the original instance, you must change the imported parameter values for the run directory and the diagnosis history and the paths for the data and log volumes as otherwise collisions would take place.

See also:

Database Administration Tutorial, Copying a Parameter File from a Data Backup

Concepts of the Database System, Database Parameters

Prerequisites

You have the server authorization Recovery.

You have opened a service session (see: service session).

Syntax

recover_config <medium_name>

<medium_name>

Name of the backup template

Reply

OK

Returncode              <value>

Date                    [<value>]

Time                    [<value>]

Server                  [<value>]

Database                [<value>]

Kernel Version          [<value>]

Pages Transferred       [<value>]

Pages Left              [<value>]

Volume Count            [<value>]

Mediumname              [<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>]

Database ID             [<value>]

Max Used Data Page      [<value>]

Values for the Reply Fields

Value

Description

Date

Date

Time

Time

Server

Name of the database computer

Database

Name of the database instance

Kernel Version

Version of database software

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:

Documentation, Messages

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

Max Used Data Page

Highest page number assigned (indication of minimum database size when backup is imported)

In the event of errors, see Reply Format.