Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-20
Backup Object
exclude-object spec
is the list of OSS files or directories separated by a comma ‘,’.
Filters for SQL/MX Objects
For SQL/MX objects, the filters are applied only to certain types of objects as shown in
Table 6-3. You cannot filter SQL/MX constraints. For SQL/MX, various filters apply only
to certain object types. Parent objects are backed up if the filter does not apply to
them. For example, WHERE EOF applies only to table partitions. If you specify
BACKUP of a schema WHERE EOF>n, all tables in the schema are backed up, and
only table partitions greater than the indicated size are backed up.
OWNER = user-id
selects a schema based on the user ID. It is a NonStop user ID in one of these
forms:
{ group-name.user-name }
{ group-name.* }
{ group-number, user-number }
{ group-number,* }
group-name
is the group name of the user. Each name can contain from one to eight letters
or digits, and the first character must be a letter.
Note.

Wild cards allowed in the exclude-object spec are *,!,?. EXCLUDE filter is an
exclusion criterion and not an inclusion criterion. Exclusion criterion, if applied and
satisfied, prevents the particular OSS object from being backed up. Any inclusion criterion,
if applied and satisfied, allows an OSS object to be backed up.

The EXCLUDE filter is supported only on systems running J06.10 and later J-series RVUs
and H06.21 and later H-series RVUs.
Table 6-3. SQL/MX Filters
CATALOG SCHEMA TABLE INDEX PARTITIONS
OWNER Ignored Valid Ignored Ignored Ignored
CREATIONTIME Ignored Ignored Valid Ignored Ignored
LASTOPENTIME Ignored Ignored Ignored Ignored Valid
MODTIME Ignored Ignored Ignored Ignored Valid
REDEFINITIONTIME Ignored Ignored Valid Valid Ignored
EOF Ignored Ignored Ignored Ignored Valid
TABLE Valid Valid Valid Valid Valid