If your FILE MODE backup tape contains both format 1 and format 2 files, you will need the fallback
SPR to restore files to a system that does not support format 2 files. The fallback SPR will restore
the format 1 files, skip the format 2 files, and issue an error message.
Do not use an older version of RESTORE to process a tape containing format 2 files. When a format
2 file is encountered, the results are unpredictable. BACKUP might abort or create an unusable
file. If you encounter this problem, purge the unusable file.
Using Qualified File-Set Lists
These examples display a variety of qualifiers and file attributes:
•
To back up all of the files on $SYSTEM (except those on $SYSTEM.SYSTEM):
1> BACKUP $TAPE, $SYSTEM.*.* EXCLUDE $SYSTEM.SYSTEM.*
•
To back up all audited files on $SQL that are owned by SOFTWARE.JNP and are SQL files
or EDIT files (file code 101), with a resulting tape file blocksize of 28:
1> BACKUP $TAPE, ($SQL.*.* WHERE OWNER=SOFTWARE.JNP &
1> &AND (SQL OR FILECODE=101) ), LISTALL, AUDITED, &
1> &BLOCKSIZE 28
•
To back up all files except object files (file code 100) from all subvolumes whose names match
the form T9???D46 on volume $SPECIAL:
1> BACKUP $TAPE, $SPECIAL.T9???D46.* &
1> &WHERE FILECODE <> 100, LISTALL
•
To back up all files in the system that are licensed and not owned by the super ID (255,255)
except those in the $SYSTEM.SYSTEM subvolume or any subvolume of the form
$SYSTEM.SYS??:
1> BACKUP $TAPE, *.*.* &
1> &EXCLUDE ($SYSTEM.SYSTEM.*, $SYSTEM.SYS??.*) &
1> &WHERE LICENSED AND NOT (OWNER = 255,255), LISTALL
•
To back up only those files on volumes $BASE and $LADY that are owned by a user in the
group SOFTWARE and were modified since May 4, 2000 at 1:30 p.m.:
1> BACKUP $TAPE, ($BASE.*.*, $LADY.*.*) &
1> &WHERE OWNER = SOFTWARE.* &
1> &AND MODTIME AFTER 04 MAY 2000 13:30
•
To back up all files except those that are audited:
1> BACKUP $TAPE, *.*.* WHERE NOT AUDITED, LISTALL
•
To back up all files for which the FLTrustFlags is set to ME:
1> BACKUP $TAPE, *.*.* WHERE TRUSTME, LISTALL
NOTE:
The FLTrustFlags attribute is supported only on systems running H-series RVUs or J-series
RVUs.
Backing Up SQL Files
The types of SQL files that can be explicitly named in
backup-files
or backed up using the
FROM CATALOG qualifier include: base tables, catalog tables, indexes on base tables and catalog
tables, individual partitions of base tables and indexes, SQL shorthand views, and SQL object
program files.
74
BACKUP
Содержание BACKCOPY
Страница 113: ...Format of the Permanent Work File 1 13 ...
Страница 114: ...1 14 Disk Space Analysis Program DSAP ...