SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Performing Recovery Operations

HP NonStop SQL/MX Installation and Management Guide—523723-004

12-22

Restoring Catalogs

When you restore a catalog, all its dependent objects (for example, schemas, tables,

and indexes) are also restored.

Specify the CATALOG object to restore one or more catalogs:

BR> RESTORE $tape-drive, MX CATALOG mycat1;

BR> RESTORE $tape-drive, MX CATALOG mycat1, CATALOG mycat2;

You can also specify every catalog that was backed up:

BR> RESTORE $tape-drive, MX CAT *;

For more information about restoring catalogs, see the Backup and Restore 2 Manual.

Restoring Schemas

When you restore a schema, all its dependent objects are restored as well.

Restore one or more schemas either implicitly, by restoring the associated catalogs, or

explicitly, by using the SCHEMA restore object:

BR> RESTORE $tape-drive, MX SCHEMA CAT3.SCH;

BR> RESTORE $tape-drive, MX SCHEMA CAT2.SCH, SCHEMA CAT3.SCH;

For more information about restoring schemas, see the Backup and Restore 2 Manual.

Restoring Tables and Partitions

When you restore a table, all its dependent objects, including partitions, are also

restored. Similarly, when you restore a table partition, all its dependent objects (for

example, indexes and constraints) are restored.

You can restore one or more tables, either implicitly, by restoring associated schemas

or catalogs, or explicitly, by using the TABLE restore object:

BR> RESTORE $tape-drive, MX TABLE cat1.sch1.table1;

BR> RESTORE $tape-drive, MX TABLE cat1.sch1.t1, TABLE

cat2.sch.t2;

Note. Hash-partitioned tables must be restored in their entirety. Individual hash partitions

cannot be restored.