To Next Page

To Previous Page

Table 16 Interaction Between RESTORE and TMF (continued)

What RESTORE DoesConditionsRESTORE Command Used

File is restored nonaudited.File exists but is not auditedAUDITED and TURNOFFAUDIT

If TMF is running, the file is restored nonaudited.

Otherwise, RESTORE issues Purge Error 82 and

does not restore the file.

File exists and is auditedAUDITED and TURNOFFAUDIT

CAUTION: Restoring any audited file backed up in a WRITE OPEN state can make TMF bring

down the whole volume. If you restore these audited files, use them in nonaudited mode.

AUTOCREATECATALOG

The AUTOCREATECATALOG ON option specifies that SQL catalogs are created at the time of the

RESTORE process. Otherwise, SQL catalogs are not created.

AUTOCREATECATALOG [ ON | OFF ]

directs RESTORE to automatically create each SQL catalog that you need (that does not already

exist on disk). ON is the default when you specify this option.

OFF

specifies that RESTORE does not create the SQL catalogs. OFF is the same as omitting the

AUTOCREATECATALOG option from the RESTORE command.

Guidelines

• When you use AUTOCREATECATALOG ON, an SQL catalog is created and RESTORE inserts

appropriate entries with the first instance of an SQL object.

• If you provide a user ID (MYID), specify the AUTOCREATECATALOG ON option, and run

RESTORE, you become the catalog owner (and its security). This ensures that the entire SQL

object is restored successfully.

• The name of each automatically created catalog is reported in the listing created by RESTORE.

Any errors that occur while trying to create a catalog are reported in the same way that other

SQL errors are reported.

CATALOGS

The CATALOGS option describes where to register SQL objects that are restored.

CATALOG[S] (catalog-name FOR fileset-list

[ , catalog-name FOR fileset-list ] ... )

catalog-name

specifies the name and location of the catalog as [\node.][$ volume.]subvolume.

fileset-list

specifies the files whose SQL objects are to be registered in catalog-name. These files are

on the backup tape that is being restored. If you used the MAP NAMES option to change the

name of a file, fileset-list should be the new name assigned by this option (MAP NAMES).

130 RESTORE

HP BACKCOPY User Manual

Questions and Answers: