Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-55
Backing Up Both OSS and SQL/MX Objects
Backing Up Both OSS and SQL/MX Objects
You can back up both OSS and SQL/MX objects in the same command. For example:
BR> BACKUP =mytape,(OSS ((/usr/bin, /home/sv/myfile,
BR+> /usr/local/bin) WHERE (EOF > 200000 AND OWNER =
BR+> super.super), (/etc/rc, /var/x) WHERE MODTIME AFTER
BR+> JAN 17 1999)), (MX (CATALOG cat1, TABLE cat2.sch.tab1,
BR+> TPART cat2.sch.tab2 PARTITION (TPART5, TPART1)) WHERE
BR+> (CREATIONTIME BEFORE 12 DEC 2000)), CONSTRAINTS
BR+> EXCLUDED,FOLLOWMOUNTPTS ON, TAPEDISPOSITION NOREWIND,
BR+> VERIFYTAPE ON, INDEXES EXCLUDED, PARTONLY ON ;
The example filters both OSS and SQL/MX objects and excludes indexes and
constraints.
The same example is formatted to show the different parts of the same command:
BACKUP =mytape,
(OSS
(
(/usr/bin,/home/sv/myfile,/usr/local/bin)
WHERE (EOF > 200000 AND OWNER super.super),
(/etc/rc,/var/x)
WHERE MODTIME AFTER JAN 17 1999)
),
(MX
(CATALOG cat1,
TABLE cat2.sch.tab1,
TPART cat2.sch.tab2 PARTITION (TPART5, TPART1))
WHERE (CREATIONTIME BEFORE 12 DEC 2000)
),
CONSTRAINTS EXCLUDED,
INDEXES EXCLUDED,
PARTONLY ON,
FOLLOWMOUNTPTS ON,
TAPEDISPOSITION NOREWIND,
VERIFYTAPE ON ;