You can use this DBM command when you create a database. It enables you to create a new database, which has the same parameter values as an existing database.
For that purpose, you need a complete backup of the existing database. Import the parameter file from this backup to the new database.
The copy of the parameter file is then stored in the <dependent_path> under the name of the current database.
Note
If you use this command when creating a database copy or a standby database, always check whether security reasons make it necessary to create this database on a database computer other than the computer of the original database. If you do create the new database on the same computer as the original database, it is imperative to change the imported parameter values for the run directory and the diagnosis history as well as the paths for the data and log volumes.
You have the server permission Recovery.
You have started a service session (see service_connect).
recover_config <medium_name>
Option |
Description |
---|---|
<medium_name> |
Name of the backup template |
OK
Returncode <value>
...
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 |
In the event of errors, see Reply Format.
Database Administration, Database Parameters