Example 1
The following example displays the header information for the
mf_personnel database on the terminal screen:
$ RMU/DUMP MF_PERSONNEL
Example 2
The following example generates a list of unresolved transactions
for the mf_personnel database:
$ RMU/DUMP/USERS/STATE=BLOCKED MF_PERSONNEL
Example 3
The following example shows the command you might use to view the
SPAM pages associated with the area EMPIDS_LOW:
$ RMU/DUMP/NOHEADER/AREAS=(EMPIDS_LOW)/SPAMS_ONLY -
_$ MF_PERSONNEL/OUTPUT=DUMP.LIS
Example 4
The following example demonstrates the use of the Restore_Options
qualifier. The first command performs a dump operation on the mf_
personnel database and creates a Restore_Options file. The second
command shows a portion of the contents of the options file. The
last command demonstrates the use of the options file with the
RMU Restore command.
$ RMU/DUMP MF_PERSONNEL.RDB /RESTORE_OPTIONS=MF_PERS.OPT -
_$ /OUTPUT=DUMP.LIS
$ TYPE MF_PERS.OPT
! Options file for database USER1:[DB]MF_PERSONNEL.RDB;1
! Created 19-JUL-1995 14:55:17.80
! Created by DUMP command
RDB$SYSTEM -
/file=USER2:[STO]MF_PERS_DEFAULT.RDA;1 -
/extension=ENABLED -
/read_write -
/spams -
/snapshot=(allocation=100, -
file=USER2:[SNP]MF_PERS_DEFAULT.SNP;1)
DEPARTMENTS -
/file=USER3:[STO]DEPARTMENTS.RDA;1 -
/blocks_per_page=2 -
/extension=ENABLED -
/read_write -
/spams -
/thresholds=(70,85,95) -
/snapshot=(allocation=100, -
file=USER3:[SNP]DEPARTMENTS.SNP;1)
.
.
.
$ RMU/RESTORE MF_PERSONNEL.RBF/OPTIONS=MF_PERS.OPT
Example 5
The following command generates a detailed display of backup,
recovery, RUJ, and AIJ information for the mf_personnel database.
$ RMU/DUMP/HEADER=(BACKUP,JOURNALING) MF_PERSONNEL.RDB
See the Oracle Rdb Guide to Database Maintenance and the Oracle
Rdb7 Guide to Distributed Transactions for more examples showing
the RMU Dump command and the output.
Example 6
The following example dumps all ABM pages contained in all
uniform storage areas in the specified Rdb database.
$ RMU/DUMP/ABMS_ONLY/OUT=DMP.OUT MF_PERSONNEL
Example 7
In the following example, only the ABM pages contained in the
named uniform storage area in the specified Rdb database are
dumped.
$ RMU/DUMP/ABMS_ONLY/AREA=RDB$SYSTEM MF_PERSONNEL
Example 8
In the following example, only the ABM pages contained in the
named logical area in a uniform storage area in the specified Rdb
database are dumped.
$ RMU/DUMP/ABMS_ONLY/LAREA=RDB$RELATIONS MF_PERSONNEL
Example 9
In the following example, only the ABM pages contained within
the specified page range in the named uniform storage area in the
specified Rdb database are dumped.
$ RMU/DUMP/ABMS_ONLY/AREA=RDB$SYSTEM/START=1/END=5 MF_PERSONNEL