Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-3
Summary of Restoring SQL/MX or OSS Objects
SQL/MX Total Objects Restored Count
The count of the total objects restored does not match the total objects backed up for
the following reasons:

You can backup a catalog with all the schemas and tables, but choose to restore
only a schema, table, index, table partition, or index partition.

Restore does not include the BRIC in the restored objects count. As a result
restoring the backup image to the same location reduces the restored objects
count by 1.

You can choose to restore the backup image to a different location. To restore a
schema to a target catalog, BR2 restores only the schema in the new catalog and
does not include the catalog under the restored objects count. In this scenario the
total restored objects count is reduced by 2.

Restoring a table to a target schema does not restore the new schema and
catalog. In this scenario the restored objects count is reduced by 3 (including the
BRIC). This is applicable for other SQL/MX objects as well.

Restoring the objects by applying filters restores only the objects meeting the
criteria.

Restore with OPEN OFF job option does not restore all the objects that are backed
up. Specifying this option skips all the objects that are OPEN.
The following example shows an object count mismatch during schema backup (6) and
restore (5), as BRIC file is not counted during restore: