Library /sys$common/syshlp/helplib.hlb  —  RMU72  Dump  Database  Examples
    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
Close Help