Example 1
The following command performs a full backup operation on the mf_
personnel database and displays a log of the session:
$ RMU/BACKUP MF_PERSONNEL -
_$ DISK2[USER1]MF_PERS_FULL_BU.RBF /LOG
Example 2
To perform an incremental backup operation, include the
Incremental qualifier. Assume a full backup operation was done
late Monday night. The following command performs an incremental
backup operation on the database updates only for the following
day:
$ RMU/BACKUP/INCREMENTAL MF_PERSONNEL.RDB -
_$ $222$DUA20:[BCK]TUESDAY_PERS_BKUP/LOG
Example 3
To back up the database while there are active users, specify the
Online qualifier:
$ RMU/BACKUP/ONLINE MF_PERSONNEL.RDB -
_$ $222$DUA20:[BACKUPS]PERS_BU.RBF /LOG
Example 4
The following RMU Backup command includes only the EMPIDS_
LOW and EMPIDS_MID storage areas in the backup file of the
mf_personnel database. All the other storage areas in the mf_
personnel database are excluded from the backup file:
$ RMU/BACKUP/INCLUDE=(EMPIDS_LOW,EMPIDS_MID) -
_$ MF_PERSONNEL.RDB $222$DUA20:[BACKUPS]MF_PERS_BU.RBF
Example 5
The following command backs up the mf_personnel database but not
the root file ACL for the database:
$ RMU/BACKUP/NOACL MF_PERSONNEL MF_PERS_NOACL
Example 6
The following command backs up the mf_personnel database without
waiting for a quiet point in the database:
$ RMU/BACKUP/NOQUIET_POINT MF_PERSONNEL MF_PERS_NQP
Example 7
The following command creates a journal file, pers_journal.jnl,
and a backup file, pers_backup.rbf.
$ RMU/BACKUP/JOURNAL=PERS_JOURNAL MF_PERSONNEL PERS_BACKUP
Example 8
The following example backs up all the storage areas in the mf_
personnel database except for the read-only storage areas.
$ RMU/BACKUP/NO_READ_ONLY MF_PERSONNEL MF_PERSONNEL_BU
Example 9
The following example assumes that you are using multiple tape
drives to do a large backup operation. By specifying the Loader_
Synchronization qualifier, this command does not require you to
load tapes as each becomes full. Instead, you can load tapes on a
loader or stacker and RMU Backup will wait until all concurrent
tape operations have concluded for one set of tape volumes before
assigning the next set of tape volumes.
Using this example, you:
1. Verify the database.
2. Allocate each tape drive.
3. Manually place tapes BACK01 and BACK05 on the $111$MUA0:
drive.
4. Manually place tapes BACK02 and BACK06 on the $222$MUA1:
drive.
5. Manually place tapes BACK03 and BACK07 on the $333$MUA2:
drive.
6. Manually place tapes BACK04 and BACK08 on the $444$MUA3:
drive.
7. Mount the first volume.
8. Perform the backup operation.
9. Dismount the last tape mounted. (This example assumes it is on
the $444$MUA3: drive.)
10. Deallocate each tape drive.
$ RMU/VERIFY DB_DISK:[DATABASE]MF_PERSONNEL.RDB
$
$ ALLOCATE $111$MUA0:
$ ALLOCATE $222$MUA1:
$ ALLOCATE $333$MUA2:
$ ALLOCATE $444$MUA3:
$
$ MOUNT/FOREIGN $111$MUA0:
$
$ RMU/BACKUP /LOG/REWIND/LOADER_SYNCHRONIZATION -
_$ /LABEL=(BACK01, BACK02, BACK03, BACK04, BACK05, -
_$ BACK06, BACK07, BACK08) -
_$ DB_DISK:[MFPERS]MF_PERSONNEL.RDB -
_$ $111$MUA0:PERS_FULL_MAR30.RBF/Master, $222$MUA1: -
_$ $333$MUA1:/MASTER, $444$MUA3
$
$ DISMOUNT $444$MUA3:
$
$ DEALLOCATE $111$MUA0:
$ DEALLOCATE $222$MUA1:
$ DEALLOCATE $333$MUA2:
$ DEALLOCATE $444$MUA4:
Example 10
The following example generates a parallel backup plan file, but
does not execute it. The result is a backup plan file. See the
next example for a description of the plan file.
$ RMU/BACKUP/PARALLEL=(EXEC=4, NODE=(NODE1, NODE2)) -
_$ /LIST_PLAN=(PARTIAL.PLAN)/NOEXECUTE/INCLUDE=(RDB$SYSTEM, EMPIDS_LOW, -
_$ EMPIDS_MID, EMPIDS_OVER, SALARY_HISTORY, EMP_INFO) -
_$ /LABEL=(001, 002, 003, 004, 005, 006, 007, 008, 009) -
_$ /CHECKSUM_VERIFICATION -
_$ MF_PERSONNEL TAPE1:MF_PARTIAL.RBF, TAPE2:, TAPE3:, TAPE4:
Example 11
The following display shows the contents of the plan file,
PARTIAL.PLAN created in the preceding example. The following
callouts are keyed to this display:
1 The Plan Parameters include all the parameters specified
on the RMU BACKUP command line and all possible command
qualifiers.
2 Command qualifiers that are not specified on the command line
are represented as comments in the plan file. This allows you
to edit and adjust the plan file for future use.
3 Command qualifiers that are explicitly specified on the
command line are represented in the plan file as specified.
4 Executor parameters are listed for each executor involved in
the backup operation.
! Plan created on 28-JUN-1996 by RMU/BACKUP.
Plan Name = PARTIAL
Plan Type = BACKUP
Plan Parameters: 1
Database Root File = DISK1:[DB]MF_PERSONNEL;1
Backup File = PARTIAL.RBF
! Journal = specification for journal file 2
! Tape_Expiration = dd-mmm-yyyy
! Active_IO = number of buffers for each tape
! Protection = file system protection for backup file
! Block_Size = bytes per tape block
! Density = tape density
![No]Group_Size = number of blocks between XOR blocks
! Lock_Timeout = number of second to wait for locks
! Owner = identifier of owner of the backup file
!Page_Buffers = number of buffers to use for each storage area
Checksum_Verification 3
CRC = AUTODIN_II
NoIncremental
! Accept_labels preserves all tape labels
Log
! Loader_synchronization labels tapes in order across drives
! Media_loader forces support of a tape media loader
NoOnline
Quiet_Point
NoRewind
Statistics
ACL
![No]Scan_Optimization
Labels = (-
001 -
002 -
003 -
004 -
005 -
006 -
007 -
008 -
009 )
End Plan Parameters
Executor Parameters :
Executor Name = COORDINATOR
Executor Type = Coordinator
End Executor Parameters
Executor Parameters : 4
Executor Name = WORKER_001
Executor Type = Worker
Executor Node = NODE1
Start Storage Area List
EMPIDS_LOW,
SALARY_HISTORY
End Storage Area List
Tape Drive List
Tape Drive = TAPE1:
MASTER
End Tape Drive List
End Executor Parameters
Executor Parameters :
Executor Name = WORKER_002
Executor Type = Worker
Executor Node = NODE2
Start Storage Area List
EMPIDS_MID,
RDB$SYSTEM
End Storage Area List
Tape Drive List
Tape Drive = TAPE2:
MASTER
End Tape Drive List
End Executor Parameters
Executor Parameters :
Executor Name = WORKER_003
Executor Type = Worker
Executor Node = NODE1
Start Storage Area List
EMPIDS_OVER
End Storage Area List
Tape Drive List
Tape Drive = TAPE3
MASTER
End Tape Drive List
End Executor Parameters
Executor Parameters :
Executor Name = WORKER_004
Executor Type = Worker
Executor Node = NODE2
Start Storage Area List
EMP_INFO
End Storage Area List
Tape Drive List
Tape Drive = TAPE4
MASTER
End Tape Drive List
End Executor Parameters
Example 12
The following example demonstrates the use of the Restore_Options
qualifier. The first command backs up selected areas of the
mf_personnel database and creates an options file. The second
command shows the contents of the options file. The last command
demonstrates the use of the options file with the RMU Restore
command.
$ RMU/BACKUP MF_PERSONNEL.RDB MF_EMPIDS.RBF/INCLUDE=(EMPIDS_LOW, -
_$ EMPIDS_MID, EMPIDS_OVER) /RESTORE_OPTIONS=MF_EMPIDS.OPT
%RMU-I-NOTALLARE, Not all areas will be included in this backup file
$ !
$ !
$ TYPE MF_EMPIDS.OPT
! Options file for database USER1:[MFDB]MF_PERSONNEL.RDB;1
! Created 18-JUL-1995 10:31:08.82
! Created by BACKUP command
EMPIDS_LOW -
/file=USER2:[STOA]EMPIDS_LOW.RDA;1 -
/blocks_per_page=2 -
/extension=ENABLED -
/read_write -
/spams -
/thresholds=(70,85,95) -
/snapshot=(allocation=100, -
file=USER2:[SNP]EMPIDS_LOW.SNP;1)
EMPIDS_MID -
/file=USER3:[STOA]EMPIDS_MID.RDA;1 -
/blocks_per_page=2 -
/extension=ENABLED -
/read_write -
/spams -
/thresholds=(70,85,95) -
/snapshot=(allocation=100, -
file=USER3:[SNP]EMPIDS_MID.SNP;1)
EMPIDS_OVER -
/file=USER4:[STOA]EMPIDS_OVER.RDA;1 -
/blocks_per_page=2 -
/extension=ENABLED -
/read_write -
/spams -
/thresholds=(70,85,95) -
/snapshot=(allocation=100, -
file=USER4:[SNP]EMPIDS_OVER.SNP;1)
$ !
$ !
$ !
$ RMU/RESTORE MF_EMPIDS.RBF /AREA/OPTIONS=MF_EMPIDS.OPT
Example 13
The following example uses a density value with compression:
$RMU/BACKUP/DENSITY=(TK89,COMPACTION)/REWIND/LABEL=(LABEL1,LABEL2) -
_$ MF_PERSONNEL TAPE1:MFP.BCK, TAPE2:
Example 14
The following example shows how to perform a multidisk backup
operation.
$ RMU/BACKUP/DISK MF_PERSONNEL DEVICE1:[DIRECTORY1]MFP.RBF, -
_$ DEVICE2:[DIRECTORY2]
.
.
.
%RMU-I-COMPLETED, BACKUP operation completed at 1-MAY-2001 17:40:53.81
Example 15
The following example shows the use of the Librarian qualifier
with a plan file.
$RMU/BACKUP/PARALLEL=EXECUTOR=3/LIBRARIAN=WRITER_THREADS=3 -
_$ /LIST_PLAN=FILENAME.PLAN/NOEXECUTE/LOG DATABASE FILENAM.RBF
$RMU/BACKUP/PLAN FILENAME.PLAN
$RMU/RESTORE/LIBRARIAN=(READER_THREADS=9)/LOG FILENAME.RBF
The first backup command creates the plan file for a parallel
backup, but does not execute it. The second backup command
executes the parallel backup using the plan file. Three worker
processes are used; each process uses the three writer threads
specified with the Librarian qualifier. Each writer thread in
each process writes one stream of backup data to the Librarian
utility; a total of nine streams is written.
Example 16
This example shows the use of the Compression qualifier ZLIB.
$ RMU /BACKUP /COMPRESS=ZLIB:9 /LOG=FULL FOO BCK
.
.
.
BACKUP summary statistics:
Data compressed by 53% (9791 KB in/4650 KB out)
Example 17
The following example shows the use of the Norecord qualifier.
This would be used to backup a Hot Standby database without
modifying the database files.
$ RMU /BACKUP /NORECORD FOO BCK