Restore Database SmartGuide -- Fields and controls

Restore Status page
Backup History page
Roll Forward page
" " Back
" " Rest
" " Done
" " Show Command
" " Cancel



Restore Status page

" " Database
" " Database Status

" " Database

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

" " 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

" " Table

" " Table

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



Roll Forward page

" " Roll-forward (reapply the logs)
" " Roll-forward to the end of the logs
" " Roll-forward to a point in time
" " Roll forward to transaction

" " Roll-forward (reapply the logs)

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

" " 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.

" " 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.

" " Roll forward to transaction

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