Restore Database SmartGuide -- Fields and controls

Restore Status page
Backup History page
Roll Forward page
Figure pbullet not displayed. Back
Figure pbullet not displayed. Rest
Figure pbullet not displayed. Done
Figure pbullet not displayed. Show Command
Figure pbullet not displayed. Cancel



Restore Status page

Figure pbullet not displayed. Database
Figure pbullet not displayed. Database Status

Figure pbullet not displayed. Database

Displays the system, instance and name of the currently selected database. Click on the Browse push button to select a different database.

Figure pbullet not displayed. Database Status

Displays the current status of the database. Any status other than "Available" indicates that you must either wait for an operation to complete or take some recovery action.

Available
The database is available for use.

Backup Pending
You must do a full backup of the database before accessing it. This state occurs after either LOGRETAIN has been enabled (or set to RECOVERY) and accepted, or USEREXIT has been enabled and accepted.

Restore Pending
The database must be restored from a backup image. The restore must complete before you can access the database.

Roll Forward Enabled
The database is enabled for roll-forward recovery.

Roll Forward Pending
The database must be rolled forward from the contents of the database log files. The roll-forward must complete before you can access the database.

Table Space Roll Forward Pending
This state indicates that the changes to a single table space must be rolled forward from the contents of the database log files. The roll-forward must complete before you can access the table space.

Unknown
This state indicates that a connection cannot be established to the database. The connection may be faulty, or the database may not be started.

Inconsistent
A transaction is pending or some other task is pending on the database and the data is not consistent at this point. If the system "crashes" while the database is not consistent, you will need to restart the database to make it usable. If this does not work you will need to restore the database from a backup image.



Backup History page

Figure pbullet not displayed. Table

Figure pbullet not displayed. Table

Displays the list of database backup images that you may want to restore.



Roll Forward page

Figure pbullet not displayed. Roll-forward (reapply the logs)
Figure pbullet not displayed. Roll-forward to the end of the logs
Figure pbullet not displayed. Roll-forward to a point in time
Figure pbullet not displayed. Roll forward to transaction

Figure pbullet not displayed. Roll-forward (reapply the logs)

Use this check box to roll forward the changes to your database since the last backup.

Figure pbullet not displayed. Roll-forward to the end of the logs

Click on this radio button to roll forward the changes to your database to the end of the logs.

Figure pbullet not displayed. Roll-forward to a point in time

Click on this radio button to roll forward the changes to your database to a specified point-in-time.

Figure pbullet not displayed. Roll forward to transaction

Use the Date box and the Time box to roll forward to a specific date and time for the transaction.