Roll-Forward -- Fields and controls

Roll-Forward page

Table spaces page

Options page

Roll-Forward page

Roll-Forward to the end of the logs

Roll-Forward to a point in time

Overflow directory

Leave in roll-forward pending state

Alternate log path

OK

Cancel

Roll-Forward to the end of the logs

Click on this radio button to have all changes recorded in the logs applied during the roll-forward operation. This is the default.

Note:

If you need to restore a table space on a specific database partition you can perform roll-forward recovery on it to the end of the logs to bring it up to the same level as the table space on the other nodes.

Roll-Forward to a point in time

Click on this radio button to have changes rolled forward to a specific date and time. If you decide not to specify a date and time, the default is the current date and time. The Roll-forward to transaction field displays the date and time of the next transaction that will be reapplied by the roll-forward operation. To determine this date and time, the roll-forward status of all table spaces is checked. The date and time of the table space that has already been rolled forward to the most recent date and time (if any) is displayed.

• Use the Date field to specify the date to which you want to roll forward.

  You can either type the date, or you can click on the arrow to open a calendar on which you select the date. Click on the arrows at the top of the calendar to display the month that you want, then on a date to select it. The calendar closes, and the date you selected will be displayed in the field.

• Use the Time field to specify the time to which you want to roll forward. To change the time, click on the portion of the time that you want to change and either type the value that you want, or use the up and down arrows to adjust the value.

Note:

In a partitioned database environment, if you want to roll forward a table space to a point in time, you must restore the table space partition at each database partition that contains a portion of the table space, and roll forward each table space partition individually to the same point in time. This ensures that the table space is consistent at each node.

Overflow directory

The roll-forward operation checks for logs in the location specified by the logpath database configuration parameter. If you have moved any logs from the location specified by the logpath parameter, use the Overflow directory field to specify the path to the logs that you moved.

To display the list of available directories, click .

Leave in roll-forward pending state

Click on this check box to leave the database or database partition in the roll-forward pending state at the end of the restore operation. This is the default because it allows you to roll forward more changes after the roll-forward operation completes.

A database or database partition in the roll-forward pending state cannot be used. To turn the roll-forward pending state off and make the database or database partition usable, you can:

• Perform roll-forward recovery on it. You can perform roll-forward recovery on the database or the database partition from the Roll-Forward Database notebook.
• For a single-partition database, select Stop Roll-Forward from the pop-up menu for the database.
• For a partitioned database:
  1. Open the Database Partitions view.
  2. Select the database partition that you want.
  3. Select Database Partitions->Stop roll-forward.

Alternate log path

The logpath database configuration parameter specifies the location of logs. The value in the Alternate log path field overwrites the default location of the logs, for the current roll-forward operation and for any subsequent operations.

If you want to overwrite the default location of logs, type a string of up to 242 bytes, or, to search for and select a path, click:

The string can point to either a path name, or to a raw device. If the string points to a path name, it must be a fully qualified path name, not a relative path name.

Note:

In a partitioned database environment, the node number is automatically appended to the path. This is done to maintain the uniqueness of the path in multiple logical node configurations.

To specify a device, specify a string that the operating system identifies as a device. For example:

• On Windows NT, \\.\d: or \\.\PhysicalDisk5

  Note:

  You must have Windows NT Version 4.0 with Service Pack 3 installed to be able to write logs to a device.

• On UNIX-based platforms, /dev/rdblog8

The new setting does not become the value of logpath until both of the following occur:

• The database is in a consistent state, as indicated by the database_consistent parameter.
• All users are disconnected from the database

When the first new connection is made to the database, the database manager will move the logs to the new location specified by logpath.

Table spaces page

Use the Table spaces page of the roll-forward notebook to specify that you want to do roll-forward recovery on a subset of the table spaces. The table spaces must be in the roll-forward pending state (which you can specify when you restore the database or database partition), and you must have the database logs.

Use full database

Use selected table spaces only

Available table spaces

Use table spaces

>>, >, <, <<

OK

Cancel

Use full database

Click on this radio button to roll-forward all table spaces for which there are logged changes. This is the default. When you roll forward all table spaces, you can only perform the operation offline.

Use selected table spaces only

Click on this radio button to roll-forward only those table spaces that you selected in the Available table spaces box. When you roll forward a subset of table spaces, you can do the operation either online, or offline.

Available table spaces

This box displays all the table spaces that are in the database or database partition.

Use table spaces

This box displays all the table spaces that you want to be rolled forward.

>>, >, <, <<

Click on these push buttons to change the list of table spaces in the Available table spaces and Use table spaces list boxes:

>>

All table spaces displayed in the Available table spaces box are moved to the Use table spaces box.

>

Selected table spaces in the Available table spaces box are moved to the Use table spaces box

<

Selected table spaces in the Use table spaces box are moved to the Available table spaces box.

<<

All table spaces displayed in the Use table spaces box are moved to the Available table spaces box.