Example 1

    If a storage area is on a disk that is logging error messages,
    you can move the storage area to another disk by using the RMU
    Move_Area command. The following command moves the DEPARTMENTS
    storage area (departments.rda) and the DEPARTMENTS snapshot
    file (departments.snp) of the mf_personnel database to the
    DDV21:[RICK.SQL] directory:

    $ RMU/MOVE_AREA MF_PERSONNEL DEPARTMENTS /DIRECTORY=DDV21:[RICK.SQL]

    Example 2

    The following command moves the EMPIDS_LOW, EMPIDS_MID, and
    EMPIDS_OVER storage areas for the mf_personnel database to the
    DISK2:[USER2] directory. The Extension=Disable qualifier disables
    automatic file extensions for the EMPIDS_LOW, EMPIDS_MID, and
    EMPIDS_OVER storage area (.rda) files when they are moved to the
    DISK2:[USER2] directory:

    $ RMU/MOVE_AREA/EXTENSION=DISABLE/DIRECTORY=DISK2:[USER2]  -
    _$ mf_personnel EMPIDS_LOW,EMPIDS_MID,EMPIDS_OVER

    Example 3

    The following RMU Move_Area command uses an options file to
    specify that the storage area files and snapshot files be moved
    to different disks. Note that storage area snapshot (.snp)
    files are located on different disks from one another and from
    their associated storage area (.rda) files; this is recommended
    for optimal performance. (This example assumes that the disks
    specified for each storage area file in options_file.opt are
    different from those where the storage area files currently
    reside.)

    $ RMU/MOVE_AREA/OPTIONS=OPTIONS_FILE.OPT MF_PERSONNEL

    The following command displays the contents of the options file:

    $ TYPE options_file.opt

    EMPIDS_LOW /FILE=DISK1:[CORPORATE.PERSONNEL]EMPIDS_LOW.RDA -
         /SNAPSHOT=(FILE=DISK2:[CORPORATE.PERSONNEL]EMPIDS_LOW.SNP)

    EMPIDS_MID /FILE=DISK3:[CORPORATE.PERSONNEL]EMPIDS_MID.RDA -
         /SNAPSHOT=(FILE=DISK4:[CORPORATE.PERSONNEL]EMPIDS_MID.SNP)

    EMPIDS_OVER /FILE=DISK5:[CORPORATE.PERSONNEL]EMPIDS_OVER.RDA -
         /SNAPSHOT=(FILE=DISK6:[CORPORATE.PERSONNEL]EMPIDS_OVER.SNP)

    DEPARTMENTS /FILE=DISK7:[CORPORATE.PERSONNEL]DEPARTMENTS.RDA -
         /SNAPSHOT=(FILE=DISK8:[CORPORATE.PERSONNEL]DEPARTMENTS.SNP)

    SALARY_HISTORY /FILE=DISK9:[CORPORATE.PERSONNEL]SALARY_HISTORY.RDA -
         /SNAPSHOT=(FILE=DISK10:[CORPORATE.PERSONNEL]SALARY_HISTORY.SNP)

    JOBS /FILE=DISK7:[CORPORATE.PERSONNEL]JOBS.RDA -
         /SNAPSHOT=(FILE=DISK8:[CORPORATE.PERSONNEL]JOBS.SNP)

    EMP_INFO /FILE=DISK9:[CORPORATE.PERSONNEL]EMP_INFO.RDA -
         /SNAPSHOT=(FILE=DISK10:[CORPORATE.PERSONNEL]EMP_INFO.SNP)

    RESUME_LISTS /FILE=DISK11:[CORPORATE.PERSONNEL]RESUME_LISTS.RDA -
         /SNAPSHOT=(FILE=DISK12:[CORPORATE.PERSONNEL]RESUME_LISTS.SNP)

    RESUMES /FILE=DISK9:[CORPORATE.PERSONNEL]RESUMES.RDA -
         /SNAPSHOT=(FILE=DISK10:[CORPORATE.PERSONNEL]RESUMES.SNP)

    Example 4

    The following RMU Move_Area command moves the database root for
    the mf_personnel database and defines a new after-image journal
    configuration, using the Aij_Options qualifier:

    $ RMU/MOVE_AREA/ROOT=DISK1:[DATABASE.PERSONNEL]MF_PERSONNEL -
    _$ /AIJ_OPTIONS=aij_config.opt MF_PERSONNEL/NOONLINE

    The aij_config.opt file contains the following clauses:

    JOURNAL IS ENABLED -
        RESERVE 2 -
        ALLOCATION IS 512 -
        EXTENT IS 512 -
        OVERWRITE IS DISABLED -
        SHUTDOWN_TIMEOUT IS 120 -
        NOTIFY IS DISABLED -
        BACKUPS ARE MANUAL -
        CACHE IS DISABLED
    ADD AIJ1 -
        FILE DISK2:[MFPERS_AIJ1]AIJ_ONE
    ADD AIJ2 -
        FILE DISK3:[MFPERS_AIJ2]AIJ_TWO

    Example 5

    The following example moves all the mf_personnel database storage
    areas to the DISK3:[db] directory:

    $ RMU/MOVE_AREA MF_PERSONNEL.RDB /ALL_AREAS/DIR=DISK3:[DB]

    Example 6

    The following example demonstrates the use of the Directory,
    File, and Root qualifiers. In this example:

    o  The default directory is specified as DISK2:[DIR].

    o  The target directory and file name for the database root file
       is specified with the Root qualifier. The target directory
       specified with the Root qualifier overrides the default
       directory specified with the Directory qualifier. Thus, Oracle
       RMU moves the database root to DISK3:[ROOT] and names it
       MOVEDRDB.RDB.

    o  The target directory for the EMPIDS_MID storage area is
       DISK4:[FILE]. Oracle RMU moves EMPIDS_MID to DISK4:[FILE].

    o  The target file name for the EMPIDS_LOW storage area is
       EMPIDS. Thus, Oracle RMU moves the EMPIDS_LOW storage area
       to the DISK2 default directory (specified with the Directory
       qualifier), and names the file EMPIDS.RDA.

    o  The target for the EMPIDS_LOW snapshot file is
       DISK5:[SNAP]EMPIDS.SNP Thus, Oracle RMU moves the EMPIDS_LOW
       snapshot file to DISK5:[SNAP]EMPIDS.SNP.

    o  All the other storage area files and snapshot files in the
       mf_personnel database are moved to DISK2:[DIR]; the file names
       for these storage areas remain unchanged.

    $ RMU/MOVE_AREA DISK1:[DB]MF_PERSONNEL.RDB /ALL-
    _$ /DIRECTORY=DISK2:[DIR] -
    _$ /ROOT=DISK3:[ROOT]MOVEDRDB.RDB -
    _$ EMPIDS_MID/FILE=DISK4:[FILE], -
    _$ EMPIDS_LOW/FILE=EMPIDS -
    _$ /SNAPSHOT=(FILE=DISK5:[SNAP]EMPIDS.SNP)