Try OpenEdge Now
skip to main content
Database Management
Database Maintenance Job Templates : Creating database maintenance job instances : Setting up a Database Restore job
 

Setting up a Database Restore job

The Database Restore job restores an OpenEdge database backup to the location specified in the existing structure for that database. If the file structure does not exist, then the restore is performed to the existing directory for all of the areas and extents.
To complete the Database Restore Properties page:
1. Provide values for the Name and Description fields.
2. Identify the restore device you are using:
*If you select Tape, you must also define the absolute path for the tape device.
*If you select Disk, you must also specify the directory and file name.
Note: If you used the volume size (-vs) parameter when backing up your database to disk, you must specify the file that contains the names of each volume. The Restore job will pass this file to the OpenEdge Restore (PROUTIL) utility. The name of the file should be <database name>-restore.txt. The contents of the restore file should be the same as the contents of the backup file passed to PROBKUP. See Step 4 in Settingup Database Backup jobs for more information about the backup file.
3. In the Restore to field, select an AdminServer name or type the full path and name of the database to which you want to restore. If you want to overwrite an existing database at this location, select the Overwrite database option.
4. Complete the following fields:
*Partial verify (-vp) — Select this option if you want to ensure that a partial verification of the completed backup occurs. Choosing this option ensures only that the backup can be read.
Choosing this option does notrestore the database.
*Full verify (-vf) — Select this option if you want a full verification of the completed backup which ensures that a block-by-block comparison is performed between the backup and the database.
Choosing this option does notrestore the database.
*List structure (-list) — Select this option to create a structure file from the backup that was completed.
Choosing this option does notrestore the database.
*No verification — Clear this option if you want verification. Note that No verification is the default selection.
5. Verify the name of the command's current working directory in the Working Directory field. If specified, this directory must exist. This property defaults to the working directory defined at installation.
6. To append subsequent messages to the .out or .err files, select the Append option. The Output file field indicates where messages will be retained.
7. Select the Debug log file option to obtain diagnostic details that help debug job properties when setting up a job. For example, you can set this option and use the Run Now feature on the Job Summary page. Once you have submitted the job, OpenEdge Management makes debug data available through the debug log file link on the Job Summary page.
8. Select the Indicate if the job can be used as an action option if you want the job to appear in the list of actions that can be selected for execution from the Alerts and Job completion action page.
9. If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field to display the optional Job Completion Actions and Alerts page. See OpenEdge Management: Resource Monitoring for more information about the Job Completion Actions and Alerts page.
10. Click Save. The Job Summary page appears. You can now schedule the job to run at a later time, or run it immediately. You can also edit advanced information. See Editingadvanced job information for additional details.