Example 1
The following commands show the use of the Journal qualifier
with the RMU Backup command and the RMU Dump After_Journal
command. The first command creates a binary journal file that
identifies the tapes used in the backup operation. The second
command directs Oracle RMU to read the backup file (using the
tapes identified in the BACKUP_JOURNAL.JNL file) to confirm that
the backup file is structured correctly and the media is readable
for the RMU Restore command. No dump output is generated because
the Option qualifier is not specified.
$ RMU/BACKUP MF_PERSONNEL.RDB -
_$ $222$DUA20:[BCK]MF_PERSONNEL.RBF/LOG/JOURNAL=BACKUP_JOURNAL.JNL
$ RMU/DUMP/BACKUP_FILE $222$DUA20:[BCK]MF_PERSONNEL.RBF -
_$ /JOURNAL=BACKUP_JOURNAL.JNL
Example 2
The following commands show the use of the Journal qualifier with
the RMU Backup command and then with the RMU Dump Backup command.
The first command creates a binary journal file that identifies
the tapes used in the backup operation. The second command dumps
the binary journal file created in the first command in ASCII
format.
$ RMU/BACKUP MF_PERSONNEL.RDB -
_$ $222$DUA20:[BCK]MF_PERSONNEL.RBF/LOG/JOURNAL=BACKUP_JOURNAL.JNL
$ RMU/DUMP/BACKUP_FILE $222$DUA20:[BCK]MF_PERSONNEL.RBF -
_$ /JOURNAL=BACKUP_JOURNAL.JNL/OPTION=JOURNAL
Example 3
The following example demonstrates the use of the Restore_Options
qualifier. The first command performs a dump operation on the
backup file of 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/BACKUP MFP.RBF /RESTORE_OPTIONS=MFP.OPT -
_$ /OPTIONS=NORMAL/OUTPUT=DUMP.LIS
$ TYPE MFP.OPT
! Options file for database DISK1:[DB]MF_PERSONNEL.RDB;1
! Created 17-OCT-1995 13:09:57.56
! Created by DUMP BACKUP command
RDB$SYSTEM -
/file=DISK2:[RDA]MF_PERS_DEFAULT.RDA;1 -
/extension=ENABLED -
/read_write -
/spams -
/snapshot=(allocation=248, -
file=DISK3:[SNAP]MF_PERS_DEFAULT.SNP;1)
EMPIDS_LOW -
/file=DISK3:[RDA]EMPIDS_LOW.RDA;1 -
/blocks_per_page=2 -
/extension=ENABLED -
/read_write -
/spams -
/thresholds=(70,85,95) -
/snapshot=(allocation=10, -
file=DISK4:[SNAP]EMPIDS_LOW.SNP;1)
.
.
.
$ RMU/RESTORE MFP.RBF/OPTIONS=MFP.OPT
Example 4
The following example shows the dump of the page records for page
10 in storage area 4 in the MFP.RBF backup file. Since the /START
and /END qualifiers both specify page 10, only the page records
for that page are dumped. At the start of the dump is the dump
header, followed by the database root parameters which are not
shown to save space, followed by the block header, which begins
with the "HEADER_SIZE" field, for the block which contains the
records for page 10 in storage area 4, followed by the start area
record for area 4 (REC_TYPE = 6), the data page header record
(REC_TYPE = 7) for page 10, the data page data record (REC_TYPE
(REC_TYPE = 11) which ends the dump.
$ RMU/DUMP/BACKUP/AREA=4/START=10/END=10/OPTION=FULL MFP.RBF
*------------------------------------------------------------------------------
* Oracle Rdb V7.2-420 11-JAN-2011 15:50:09.25
*
* Dump of Database Backup Header
* Backup filename: MFP.RBF
* Backup file database version: 7.2
*
*------------------------------------------------------------------------------
Database Parameters:
.
.
.
HEADER_SIZE = 80 OS_ID = 1024 UTILITY_ID = 722
APPLICATION_TYPE = 1 SEQUENCE_NUMBER = 22 MAJ_VER = 1 MIN_VER = 1
VOL_NUMBER = 1 BLOCK_SIZE = 32256 CRC = 0C5D3A78 NOCRC = 00
CRC_ALTERNATE = 00 BACKUP_NAME = MFP.RBF AREA_ID = 4 HIGH_PNO = 259
LOW_PNO = 1 HDR_CHECKSUM = 9B3D
REC_SIZE = 2 REC_TYPE = 6 BADDATA = 00 ROOT = 00
AREA_ID = 4 LAREA_ID = 0 PNO = 0
REC_SIZE = 32 REC_TYPE = 7 BADDATA = 00 ROOT = 00
AREA_ID = 4 LAREA_ID = 0 PNO = 10
REC_SIZE = 28 REC_TYPE = 8 BADDATA = 00 ROOT = 00
AREA_ID = 4 LAREA_ID = 0 PNO = 10
REC_SIZE = 512 REC_TYPE = 11 BADDATA = 00 ROOT = 00
AREA_ID = 4 LAREA_ID = 0 PNO = 0
Example 5
The following example dumps the records for pages 10, 11 and
12 in the RDB$SYSTEM storage area in the MFP.RBF backup file.
Following the block header containing the target records that
starts with "HEADER_SIZE =", are the start area record for
RDB$SYSTEM area 1 (REC_TYPE = 6), then the target ABM page
records for pages 10, 11, and 12 (REC_TYPE = 10), and finally
the end area record for area RDB$SYSTEM area 1 (REC_TYPE = 11)
which ends the dump.
$ RMU/DUMP/BACKUP/AREA=RDB$SYSTEM/START=10/END=12/OPTION=FULL MFP.RBF
*------------------------------------------------------------------------------
* Oracle Rdb V7.2-420 14-JAN-2011 14:40:46.88
*
* Dump of Database Backup Header
* Backup filename: MFP.RBF
* Backup file database version: 7.2
*
*------------------------------------------------------------------------------
Database Parameters:
.
.
.
HEADER_SIZE = 80 OS_ID = 1024 UTILITY_ID = 722
APPLICATION_TYPE = 1 SEQUENCE_NUMBER = 1 MAJ_VER = 1 MIN_VER = 1
VOL_NUMBER = 1 BLOCK_SIZE = 32256 CRC = 8329C24B NOCRC = 00
CRC_ALTERNATE = 00 BACKUP_NAME = MFP.RBF AREA_ID = 1 HIGH_PNO = 178
LOW_PNO = 1 HDR_CHECKSUM = 40DE
REC_SIZE = 2 REC_TYPE = 6 BADDATA = 00 ROOT = 00 AREA_ID = 1
LAREA_ID = 0 PNO = 0
REC_SIZE = 10 REC_TYPE = 10 BADDATA = 00 ROOT = 00 AREA_ID = 1
LAREA_ID = 3 PNO = 10
REC_SIZE = 10 REC_TYPE = 10 BADDATA = 00 ROOT = 00 AREA_ID = 1
LAREA_ID = 4 PNO = 11
REC_SIZE = 10 REC_TYPE = 10 BADDATA = 00 ROOT = 00 AREA_ID = 1
LAREA_ID = 4 PNO = 12
REC_SIZE = 512 REC_TYPE = 11 BADDATA = 00 ROOT = 00 AREA_ID = 1
LAREA_ID = 0 PNO = 0