1 – Accept Label
Accept_Label
Specifies that Oracle RMU should keep the current tape label it
finds on a tape during a backup operation even if that label
does not match the default label or that specified with the
Label qualifier. Operator notification does not occur unless
the tape's protection, owner, or expiration date prohibit writing
to the tape. However, a message is logged (assuming logging is
enabled) and written to the backup journal file (assuming you
have specified the Journal qualifier) to indicate that a label is
being preserved and which drive currently holds that tape.
This qualifier is particularly useful when your backup operation
employs numerous previously used (and thus labeled) tapes and you
want to preserve the labels currently on the tapes.
If you do not specify this qualifier, the default behavior
of Oracle RMU is to notify the operator each time it finds a
mismatch between the current label on the tape and the default
label (or the label you specify with the Label qualifier).
See the description of the Labels qualifier under this command
for information on default labels. See How Tapes are Relabeled
During a Backup Operation in the Usage_Notes help entry under
the Backup Database help entry for a summary of which labels are
applied under a variety of circumstances.
2 – Active IO
Active_IO=max-writes
Specifies the maximum number of write operations to a backup
device that the RMU Backup After_Journal command attempts
simultaneously. This is not the maximum number of write
operations in progress; that value is the product of active
system I/O operations and the number of devices being written
to simultaneously.
The value of the Active_IO qualifier can range from 1 to 5. The
default value is 3. Values larger than 3 can improve performance
with some tape drives.
3 – Block Size
Block_Size=integer
Specifies the maximum record size for the backup file. The size
can vary between 2048 and 65,024 bytes. The default value is
device dependent. The appropriate block size is a compromise
between tape capacity and error rate.
4 – Compression
Compression=LZSS
Compression=Huffman
Compression=ZLIB=level
Nocompression
Allows you to specify the compression method to use before
writing data to the AIJ backup file. This reduces performance,
but may be justified when the AIJ backup file is a disk file,
or is being backed up over a busy network, or is being backed
up to a tape drive that does not do its own compression. You
probably do not want to specify the Compression qualifier when
you are backing up an aIJ file to a tape drive that does its
own compression; in some cases doing so can actually result in a
larger file.
This feature only works for the new backup file format and you
have to specify /FORMAT=NEW_TAPE if you also use /COMPRESSION.
If you specify the Compression qualifier without a value, the
default is COMPRESSION=ZLIB=6.
The level value (ZLIB=level) is an integer between 1 and 9
specifying the relative compression level with one being the
least amount of compression and nine being the greatest amount
of compression. Higher levels of the compression use increased
CPU time while generally providing better compression. The
default compression level of 6 is a balance between compression
effectiveness and CPU consumption.
OLDER ORACLE RDB 7.2 RELEASES AND COMPRESSED RBF FILES
Prior releases of Oracle Rdb are unable to read RBF files
compressed with the ZLIB algorithm. In order to read
compressed backups with Oracle Rdb 7.2 Releases prior
to V7.2.1, they must be made with /COMPRESSION=LZSS or
/COMPRESSION=HUFFMAN explicitly specified (because the
default compression algorithm has been changed from LZSS to
ZLIB). Oracle Rdb Version 7.2.1 is able to read compressed
backups using the LZSS or HUFFMAN algorithms made with prior
releases.
5 – Continuous
Continuous=(n)
Nocontinuous
Specifies whether the .aij backup process operates continuously.
You specify termination conditions by specifying one or both of
the following:
o The Until qualifier
Specifies the time and date to stop the continuous backup
process.
o The value for n
Specifies the number of iterations Oracle RMU should make
through the set of active .aij files before terminating the
backup operation.
When you use the Continuous qualifier, you must use either the
Until or the Interval qualifier or provide a value for n (or
both) to specify when the backup process should stop. You can
also stop the backup process by using the DCL STOP command when
backing up to disk.
If you specify the Continuous qualifier, Oracle Rdb does not
terminate the backup process after truncating the current .aij
file (when an extensible journal is used) or after switching to
a new journal (when fixed-size journals are used). Instead, the
backup process waits for the period of time that you specify in
the argument to the Interval qualifier. After that time interval,
the backup process tests to determine if the threshold has been
reached (for an extensible journal) or if the journal is full
(for fixed-size journals). It then performs backup operations
as needed and then waits again until the next interval break,
unless the number of iterations or the condition specified with
the Until qualifier has been reached.
If you specify the Continuous qualifier, the backup process
occupies the terminal (that is, no system prompt occurs) until
the process terminates. Therefore, you should usually enter the
command through a batch process.
If you specify the default, the Nocontinuous qualifier, the
backup process stops as soon as it completely backs up the .aij
file or files. The default value for the number of iterations (n)
is 1.
If you specify both the Until qualifier and the Continuous=n
qualifier, the backup operation stops after whichever completes
first. If you specify the Until=12:00 qualifier and the
Continuous=5 qualifier, the backup operation terminates at 12:00
even if only four iterations have completed. Likewise, if five
iterations are completed prior to 12:00, the backup operation
terminates after the five iterations are completed.
The Continuous qualifier is not recommended when you are backing
up to tape, particularly when the Format=New_Tape qualifier is
used. If your tape operations complete successfully, you do not
want the backup operation to continue in an infinite loop.
Using the DCL STOP command to terminate a backup operation to
tape might result in an incomplete or corrupt backup file.
However, do not delete this backup file; it is extremely
important that you preserve all .aij backup files, even
those produced by failed or terminated backup processes. If
the resultant .aij backup file is discarded, the next .aij
backup file could contain a "gap" in transactions, so that no
transactions would ever be rolled forward from that point on.
6 – Crc[=Autodin II]
Crc[=Autodin_II]
Uses the AUTODIN-II polynomial for the 32-bit CRC calculation and
provides the most reliable end-to-end error detection. This is
the default for NRZ/PE (800/1600 bits/inch) tape drives.
Typing Crc is sufficient to select the Crc=Autodin_II qualifier.
It is not necessary to type the entire qualifier.
7 – Crc=Checksum
Crc=Checksum
Uses one's complement addition, which is the same computation
used to do a checksum of the database pages on disk. This is the
default for GCR (6250 bits/inch) tape drives and for TA78, TA79,
and TA81 tape drives.
The Crc=Checksum qualifier allows detection of errors.
8 – Nocrc
Nocrc
Disables end-to-end error detection. This is the default for TA90
(IBM 3480 class) drives.
NOTE
The overall effect of the Crc=Autodin_II, Crc=Checksum, and
Nocrc qualifier defaults is to improve tape reliability so
that it is equal to that of a disk. If you retain your tapes
longer than 1 year, the Nocrc default might not be adequate.
For tapes retained longer than 1 year, use the Crc=Checksum
qualifier.
If you retain your tapes longer than 3 years, you should
always use the Crc=Autodin_II qualifier.
Tapes retained longer than 5 years could be deteriorating
and should be copied to fresh media.
See the Oracle Rdb Guide to Database Maintenance for details
on using the Crc qualifiers to avoid underrun errors.
9 – Density
Density=(density-value,[No]Compaction)
Specifies the density at which the output volume is to be
written. The default value is the format of the first volume (the
first tape you mount). You do not need to specify this qualifier
unless your tape drives support data compression or more than one
recording density.
The Density qualifier is applicable only to tape drives. Oracle
RMU returns an error message if this qualifier is used and the
target device is not a tape drive.
If your systems are running OpenVMS versions prior to 7.2-1,
specify the Density qualifier as follows:
o For TA90E, TA91, and TA92 tape drives, specify the number in
bits per inch as follows:
- Density = 70000 to initialize and write tapes in the
compacted format.
- Density = 39872 or Density = 40000 for the noncompacted
format.
o For SCSI (Small Computer System Interface) tape drives,
specify Density = 1 to initialize and write tapes using the
drive's hardware data compression scheme.
o For other types of tape drives, you can specify a supported
Density value between 800 and 160000 bits per inch.
o For all tape drives, specify Density = 0 to initialize and
write tapes at the drive's standard density.
Do not use the Compaction or NoCompaction keyword for systems
running OpenVMS versions prior to 7.2-1. On these systems,
compression is determined by the density value and cannot be
specified.
Oracle RMU supports the OpenVMS tape density and compression
values introduced in OpenVMS Version 7.2-1. The following table
lists the added density values supported by Oracle RMU.
DEFAULT 800 833 1600
6250 3480 3490E TK50
TK70 TK85 TK86 TK87
TK88 TK89 QIC 8200
8500 8900 DLT8000
SDLT SDLT320 SDLT600
DDS1 DDS2 DDS3 DDS4
AIT1 AIT2 AIT3 AIT4
LTO2 LTO3 COMPACTION NOCOMPACTION
If the OpenVMS Version 7.2-1 density values and the previous
density values are the same (for example, 800, 833, 1600, 6250),
the specified value is interpreted as an OpenVMS Version 7.2-1
value if the tape device driver accepts them, and as a previous
value if the tape device driver accepts previous values only.
For the OpenVMS Version 7.2-1 values that accept tape compression
you can use the following syntax:
/DENSITY = (new_density_value,[No]Compaction)
In order to use the Compaction or NoCompaction keyword, you must
use one of the following density values that accepts compression:
DEFAULT 3480 3490E 8200
8500 8900 TK87 TK88
TK89 DLT8000 SDLT SDLT320
AIT1 AIT2 AIT3 AIT4
DDS1 DDS2 DDS3 DDS4
SDLT600 LTO2 LTO3
Refer to the OpenVMS documentation for more information about
density values.
10 – Edit Filename
Edit_Filename=(Options)
Noedit_Filename
When the Edit_Filename=(options) qualifier is used, the specified
backup file name is edited by appending any or all of the values
specified by the following options to the backup file name:
o Day_Of_Week
The current day of the week expressed as a 1-digit integer (1
to 7). Sunday is expressed as 1; Saturday is expressed as 7.
o Day_Of_Year
The current day of the year expressed as a 3-digit integer
(001 to 366).
o Hour
The current hour of the day expressed as a 2-digit integer (00
to 23).
o Julian_Date
The number of days passed since 17-Nov-1858.
o Minute
The current minute of the hour expressed as a 2-digit integer
(00 to 59).
o Month
The current month expressed as a 2-digit integer (01 to 12).
o Sequence
The journal sequence number of the first journal in the backup
operation.
o Vno
Synonymous with the Sequence option. See the description of
the Sequence option.
o Year
The current year (A.D.) expressed as a 4-digit integer.
If you specify more than one option, place a comma between each
option.
The edit is performed in the order specified. For example, the
file backup.aij and the qualifier /EDIT_FILENAME=(HOUR, MINUTE,
MONTH, DAY_OF_MONTH, SEQUENCE) creates a file with the name
backup_160504233.aij when journal 3 is backed up at 4:05 P.M.
on April 23rd.
You can make the name more readable by inserting quoted strings
between each Edit_Filename option. For example, the following
qualifier adds the string "$30_0155-2" to the .aij file name
if the day of the month is the 30th, the time is 1:55 and the
version number is 2:
/EDIT_FILENAME=("$",DAY_OF_MONTH,"_",HOUR,MINUTE,"-",SEQUENCE)
This qualifier is useful for creating meaningful file names for
your backup files and makes file management easier.
The default is the Noedit_Filename qualifier.
11 – Encrypt
Encrypt=({Value=|Name=}[,Algorithm=])
The Encrypt qualifier encrypts the backup file of the after image
journal.
Specify a key value as a string or, the name of a predefined
key. If no algorithm name is specified the default is DESCBC.
For details on the Value, Name and Algorithm parameters see HELP
ENCRYPT.
This feature requires the OpenVMS Encrypt product to be installed
and licensed on this system.
This feature only works for a newer format backup file which
has been created using /FORMAT=NEW_TAPE. Therefore you have
to specify /FORMAT=NEW_TAPE with this command if you also use
/ENCRYPT.
Synonymous with Format=Old_File and Format=New_Tape qualifiers.
See the description of those qualifiers.
12 – Format
Format=Old_File
Format=New_Tape
Specifies the format in which the backup file is to be written.
Oracle Corporation recommends that you specify the Format=Old_
File qualifier (or accept the default) when you back up your .aij
file to disk and that you specify the Format=New_Tape qualifier
when you back up your .aij file to tape.
If you specify the default, the Format=Old_File qualifier, the
RMU Backup command writes the file in a format that is optimized
for a file structured disk. If you specify the Format=New_Tape
qualifier, the Oracle RMU command writes the file in a format
that is optimized for tape storage, including ANSI/ISO labeling
and end-to-end error detection and correction. When you specify
the Format=New_Tape qualifier and back up the .aij file to tape,
you must mount the backup media by using the DCL MOUNT command
before you issue the RMU Backup After_Journal command. The tape
must be mounted as a FOREIGN volume. If you mount the tape as an
OpenVMS volume (that is, you do not mount it as a FOREIGN volume)
and you specify the Format=New_Tape qualifier, you receive an
RMU-F-MOUNTFOR error.
When you back up your .aij file to tape and specify the
Format=New_Tape qualifier you can create a backup copy of the
database (using the RMU Backup command) and a backup of the
.aij file (using the RMU Backup After_Journal command) without
dismounting your tape.
The following tape qualifiers have meaning only when used in
conjunction with the Format=New_Tape qualifier:
Active_IO
Block_Size
Crc
Density
Group_Size
Label
Owner
Protection
Rewind
Tape_Expiration
The Format=New_Tape and the Noquiet_Point qualifiers cannot be
used on the same Oracle RMU command line. See the Usage Notes
Help entry for an explanation.
The default file specification, when you specify the Format=New_
Tape qualifier is .aij_rbf. The default file specification, when
you specify the Format=Old_File qualifier is .aij.
Although Oracle Corporation recommends that you specify the
Format=New_Tape qualifier for .aij backup operations to tape
and the Format=Old_File qualifier for .aij backup operations to
disk, Oracle RMU does not enforce this recommendation. This is to
provide compatibility with prior versions of Oracle Rdb. See the
Usage Notes Help entry for issues and problems you can encounter
when you do not follow this recommendation.
13 – Group Size
Group_Size[=interval]
Nogroup_Size
Specifies the frequency at which XOR recovery blocks are written
to tape. The group size can vary from 0 to 100. Specifying a
group size of zero or specifying the Nogroup_Size qualifier
results in no XOR recovery blocks being written. The Group_Size
qualifier is only applicable to tape, and its default value is
device dependent. Oracle RMU returns an error message if this
qualifier is used and the target device is not a tape device.
14 – Interval=n
Interval=number-seconds
Nointerval
Specifies the number of seconds for which the backup process
waits. Use this qualifier in conjunction with the Continuous
qualifier and the extensible journaling method. The interval
determines how often to test the active .aij file to determine
if it contains more blocks than the value of the Threshold
qualifier.
If you specify the Interval qualifier without specifying the
number of seconds, or if you omit this qualifier, the default
number of seconds is 60.
Oracle Corporation recommends using the default (Interval=60)
initially because the interval that you choose can affect the
performance of the database. In general, you can arrive at a
good interval time on a given database only by judgment and
experimentation.
If you specify the Nointerval qualifier, the active .aij file is
tested repeatedly with no interval between finishing one cycle
and beginning the next.
You must specify the Continuous qualifier if you specify either
the Interval or Nointerval qualifier.
If you specify both the Interval and Nocontinuous qualifiers, the
Interval qualifier is ignored.
15 – Label
Label=(label-name-list)
Specifies the 1- to 6-character string with which the volumes
of the backup file are to be labeled. The Label qualifier is
applicable only to tape volumes. You must specify one or more
label names when you use the Label qualifier.
You can specify a list of tape labels for multiple tapes. If you
list multiple tape label names, separate the names with commas
and enclose the list of names within parentheses.
If you do not specify the Label (or Accept_Label) qualifier,
Oracle RMU labels the first tape used for a backup operation
with the first 6 characters of the backup file name. Subsequent
default labels are the first 4 characters of the backup file name
appended with a sequential number. For example, if your backup
file is my_backup.rbf, the default tape labels are my_b, my_b01,
my_b02, and so on.
When you reuse tapes, Oracle RMU compares the label currently
on the tape to the label or labels you specify with the Label
qualifier. If there is a mismatch between the existing label and
a label you specify, Oracle RMU sends a message to the operator
asking if the mismatch is acceptable (unless you also specify the
Accept_Labels qualifier).
If desired, you can explicitly specify the list of tape labels
for multiple tapes. If you list multiple tape label names,
separate the names with commas and enclose the list of names
within parentheses. If you are reusing tapes be certain that
you load the tapes so that the label Oracle RMU expects and the
label on each tape will match, or be prepared for a high level of
operator intervention.
If you specify fewer labels than are needed, Oracle RMU generates
labels based on the format you have specified. For example, if
you specify Label=TAPE01, Oracle RMU labels subsequent tapes as
TAPE02, TAPE03, and so on up to TAPE99. Thus, many volumes can
be preloaded in the cartridge stacker of a tape drive. The order
is not important because Oracle RMU relabels the volumes. An
unattended backup operation is more likely to be successful if
all the tapes used do not have to be mounted in a specific order.
Once the backup operation is complete, externally mark the tapes
with the appropriate label so that the order can be maintained
for the restore operation. Be particularly careful if you are
allowing Oracle RMU to implicitly label second and subsequent
tapes and you are performing an unattended backup operation.
Remove the tapes from the drives in the order in which they
were written. Apply labels to the volumes following the logic
of implicit labeling (for example, TAPE02, TAPE03, and so on).
Oracle Corporation recommends you use the Journal qualifier when
you employ implicit labeling in a multidrive, unattended backup
operation. The journal file records the volume labels that were
written to each tape drive. The order in which the labels were
written is preserved in the journal. Use the RMU Dump Backup
command to display a listing of the volumes written by each tape
drive.
You can use an indirect file reference with the Label qualifier.
See the Indirect-command-files help entry for more information.
See How Tapes are Relabeled During a Backup Operation in the
Usage_Notes help entry under this command for a summary of which
labels are applied under a variety of circumstances.
16 – Librarian
Librarian=options
Use the Librarian qualifier to back up files to data archiving
software applications that support the Oracle Media Management
interface. The backup file name specified on the command line
identifies the stream of data to be stored in the Librarian
utility. If you supply a device specification or a version number
it will be ignored.
The Librarian qualifier accepts the following options:
o Trace_file=file-specification
The Librarian utility writes trace data to the specified file.
o Level_Trace=n
Use this option as a debugging tool to specify the level of
trace data written by the Librarian utility. You can use a
pre-determined value of 0, 1, or 2, or a higher value defined
by the Librarian utility. The pre-determined values are :
- Level 0 traces all error conditions. This is the default.
- Level 1 traces the entry and exit from each Librarian
function.
- Level 2 traces the entry and exit from each Librarian
function, the value of all function parameters, and the
first 32 bytes of each read/write buffer, in hexadecimal.
o Logical_Names=(logical_name=equivalence-value,...)
You can use this option to specify a list of process logical
names that the Librarian utility can use to specify catalogs
or archives where Oracle Rdb backup files are stored,
Librarian debug logical names, and so on. See the specific
Librarian documentation for the definition of logical names.
The list of process logical names is defined by Oracle RMU
prior to the start of any Oracle RMU command that accesses the
Librarian utility.
The following OpenVMS logical names must be defined for use with
a Librarian utility before you execute an Oracle RMU backup or
restore operation. Do not use the Logical_Names option provided
with the Librarian qualifier to define these logical names.
o RMU$LIBRARIAN_PATH
This logical name must be defined so that the shareable
Librarian image can be loaded and called by Oracle RMU backup
and restore operations. The translation must include the file
type (for example, .exe), and must not include a version
number. The shareable Librarian image must be an installed
(known) image. See the Librarian utility documentation for
the name and location of this image and how it should be
installed.
o RMU$DEBUG_SBT
This logical name is not required. If it is defined, Oracle
RMU will display debug tracing information messages from
modules that make calls to the Librarian shareable image.
You cannot use device specific qualifiers such as Rewind,
Density, or Label with the Librarian qualifier because the
Librarian utility handles the storage meda, not Oracle RMU.
17 – Lock Timeout
Lock_Timeout=seconds
Determines the maximum time the .aij file backup operation
will wait for the quiet-point lock and any other locks needed
during online backup operations. When you specify the Lock_
Timeout=seconds qualifier, you must specify the number of seconds
to wait for the quiet-point lock. If the time limit expires, an
error is signaled and the backup operation fails.
When the Lock_Timeout=seconds qualifier is not specified, or if
the value specified is 0, the .aij file backup operation waits
indefinitely for the quiet-point lock and any other locks needed
during an online operation.
The Lock_Timeout=seconds qualifier is ignored if the Noquiet_
Point qualifier is specified.
18 – Log
Log
Nolog
Specifies whether the processing of the command is reported to
SYS$OUTPUT. Specify the Log qualifier to request log output and
the Nolog qualifier to prevent it. If you specify neither, the
default is the current setting of the DCL verify switch. (The DCL
SET VERIFY command controls the DCL verify switch.)
19 – Media Loader
Media_Loader
Nomedia_Loader
Use the Media_Loader qualifier to specify that the tape device
receiving the backup file has a loader or stacker. Use the
Nomedia_Loader qualifier to specify that the tape device does
not have a loader or stacker.
By default, if a tape device has a loader or stacker, Oracle
RMU should recognize this fact. However, occasionally Oracle RMU
does not recognize that a tape device has a loader or stacker.
Therefore, when the first backup tape fills, Oracle RMU issues a
request to the operator for the next tape, instead of requesting
the next tape from the loader or stacker. Similarly, sometimes
Oracle RMU behaves as though a tape device has a loader or
stacker when actually it does not.
If you find that Oracle RMU is not recognizing that your tape
device has a loader or stacker, specify the Media_Loader
qualifier. If you find that Oracle RMU expects a loader or
stacker when it should not, specify the Nomedia_Loader qualifier.
Synonymous with Owner qualifier. See the description of the Owner
qualifier.
20 – Owner
Owner=user-id
Specifies the owner of the tape volume set. The owner is the
user who will be permitted to restore the database. The user-
id parameter must be one of the following types of OpenVMS
identifier:
o A user identification code (UIC) in [group-name,member-name]
alphanumeric format
o A UIC in [group-number,member-number] numeric format
o A general identifier, such as SECRETARIES
o A system-defined identifier, such as DIALUP
The Owner qualifier cannot be used with a backup operation to
disk. When used with tapes, the Owner qualifier applies to
all continuation volumes. Unless the Rewind qualifier is also
specified, the Owner qualifier is not applied to the first
volume. If the Rewind qualifier is not specified, the backup
operation appends the file to a previously labeled tape, so
the first volume can have a protection different from the
continuation volumes.
21 – Prompt
Prompt=Automatic
Prompt=Operator
Prompt=Client
Specifies where server prompts are to be sent. When you specify
Prompt=Automatic, prompts are sent to the standard input device,
and when you specify Prompt=Operator, prompts are sent to the
server console. When you specify Prompt=Client, prompts are sent
to the client system.
22 – Protection
Protection=file-protection
Specifies the system file protection for the backup file produced
by the RMU Backup After_Journal command.
The default file protection varies, depending on whether you
backup the file to disk or tape. This is because tapes do not
allow delete or execute access and the SYSTEM account always
has both read and write access to tapes. In addition, a more
restrictive class accumulates the access rights of the less
restrictive classes.
If you do not specify the Protection qualifier, the default
protection is as follows:
o S:RWED,O:RE,G,W if the backup is to disk
o S:RW,O:R,G,W if the backup is to tape
If you specify the Protection qualifier explicitly, the
differences in protection applied for backups to tape or disk
as noted in the preceding paragraph are applied. Thus, if you
specify Protection=(S,O,G:W,W:R), that protection on tape becomes
(S:RW,O:RW,G:RW,W:R).
23 – Quiet Point
Quiet_Point
Noquiet_Point
Specifies whether the quiet-point lock will be acquired when an
.aij backup operation is performed. The default is the Quiet_
Point qualifier. Use of the Quiet_Point qualifier is meaningful
only for a full backup operation; that is, a backup operation
that makes a complete pass through all .aij files ready for
backup as opposed to one which is done by-sequence (specified
with the Sequence qualifier). A full .aij backup operation can
be performed regardless of whether an extensible or a fixed-size
.aij journaling mechanism is being employed.
Each .aij backup operation is assigned an .aij sequence number.
This labeling distinguishes each .aij backup file from previous
.aij backup files. During a recovery operation, it is important
to apply the .aij backup files in the proper sequence. The RMU
Recover command checks the database root file structure and
displays a message telling you the .aij sequence number with
which to begin the recovery operation.
The quiet point is a state where all write transactions
have either been committed or rolled back and no read/write
transactions are in progress. This ensures that the recording
of transactions do not extend into a subsequent .aij backup file.
This backup file can then be used to produce a recovered database
that is in the same state as when the quiet point was reached.
When fixed-size journaling is employed, the Quiet_Point qualifier
is only relevant when the active .aij file is being backed up. In
this case, a quiet point is acquired only once, regardless of the
number of .aij files being backed up.
There is no natural quiet point if someone is writing or waiting
to write to the database at any given time. (A natural quiet
point is one that is not instigated by the use of the QP (quiet
point) Lock.) The .aij backup operation may never be able to
capture a state that does not have uncommitted data in the
database. As a result, the Noquiet_Point qualifier creates .aij
backup files that are not independent of one another. If you
apply one .aij backup file to the database without applying the
next .aij backup file in sequence, the recovery operation will
not be applied completely.
See the Usage_Notes help entry under this command for
recommendations on using the Quiet_Point and Noquiet_Point
qualifiers.
The following combination of qualifiers on the same command line
are invalid:
o Quiet_Point and Sequence
o Quiet_Point and Wait
o Noquiet_Point and Format=New
24 – Rename
Rename
Norename
The Rename qualifier creates and initializes a new .aij file and
creates the backup file by renaming the original .aij file. The
effect is that the original .aij file has a new name and the new
.aij file has the same name as the original .aij file.
The Rename qualifier sets the protection on the renamed backup
file so that you can work with it as you would any backup
file. You can specify the new name by using the Edit_Filename
qualifier.
When the Rename qualifier is used, the backup operation is faster
(than when Norename, the default, is specified) because the
duration of the backup operation is the total time required to
rename and initialize the .aij file; the data copy portion of
the backup (reading and writing) is eliminated. However, the disk
containing the .aij file must have sufficient space for both the
new and original .aij files. Note also that the .aij backup file
name must not include a device specification.
NOTE
If there is insufficient space for both the new and original
.aij files when the Rename qualifier is specified, after-
image journaling shutdown is invoked, resulting in a
complete database shutdown.
The Rename qualifier can be used with both fixed-size and
extensible journaling files.
The Norename qualifier copies the contents of the .aij file on
tape or disk and initializes the original .aij file for reuse.
The Norename qualifier results in a slower backup operation (than
when Rename is specified), but it does not require space on the
journal disk for both new and original .aij files.
The default is Norename.
25 – Rewind
Rewind
Norewind
Specifies that the magnetic tape that contains the backup file
will be rewound before processing begins. The tape is initialized
according to the Label and Density qualifiers. The Norewind
qualifier is the default and causes the backup file to be created
starting at the current logical end-of-tape (EOT).
These qualifiers are applicable only to tape devices.
26 – Sequence
Sequence=(n,m)
Nosequence
Specifies that the journals with sequence numbers from n to m
inclusive are to be backed up. The values n and m are interpreted
or interpolated as follows:
o If Sequence = (33, 35) is specified, then the .aij files with
sequence numbers 33, 34, and 35 are backed up.
o If Sequence = (53, 53) is specified, then the .aij file with
sequence number 53 is backed up.
o If Sequence = (53) is specified, then the .aij files with
sequence numbers 53 and lower are backed up, if they have
not been backed up already. For example, if .aij files with
sequence numbers 51, 52, and 53 have not been backed up, then
Sequence = (53) results in these three .aij files being backed
up.
o If Sequence = (55, 53) is specified, then .aij files with
sequence numbers 53, 54, and 55 are backed up.
o If the Sequence qualifier is specified without a value list,
both n and m are set to the sequence number of the next
journal that needs to be backed up.
The default is the Nosequence qualifier. When the default is
accepted, the backup operation starts with the next journal that
needs to be backed up and stops when the termination condition
you have specified is reached.
The following qualifiers cannot be used or have no effect when
used with the Sequence qualifier:
Continuous
Format=New_Tape
Interval
Quiet_Point
Threshold
Until
Furthermore, fixed-size after-image journals must be in use when
this qualifier is specified.
27 – Tape Expiration
Tape_Expiration=date-time
Specifies the expiration date of the .aij backup file. Note that
when Oracle RMU reads a tape, it looks at the expiration date
in the file header of the first file on the tape and assumes
the date it finds in that file header is the expiration date
for the entire tape. Therefore, if you are backing up an .aij
file to tape, specifying the Tape_Expiration qualifier only has
meaning if the .aij file is the first file on the tape. You can
guarantee that the .aij file will be the first file on the tape
by specifying the Rewind qualifier and overwriting any existing
files on the tape.
When the first file on the tape contains an expiration date
in the file header, you cannot overwrite the tape before the
expiration date unless you have the OpenVMS SYSPRV or BYPASS
privilege.
Similarly, when you attempt to perform a recover operation with
an .aij file on tape, you cannot perform the recover operation
after the expiration date recorded in the first file on the tape
unless you have the OpenVMS SYSPRV or BYPASS privilege
By default, no expiration date is written to the .aij file
header. In this case, if the .aij file is the first file on the
tape, the tape can be overwritten immediately. If the .aij file
is not the first file on the tape, the ability to overwrite the
tape is determined by the expiration date in the file header of
the first file on the tape.
You cannot explicitly set a tape expiration date for an entire
volume. The volume expiration date is always determined by
the expiration date of the first file on the tape. The Tape_
Expiration qualifier cannot be used with a backup operation to
disk.
See the Oracle Rdb Guide to Database Maintenance for information
on tape label processing.
28 – Threshold
Threshold=disk-blocks
Nothreshold
This qualifier can be used only when extensible journaling is
enabled. It cannot be used with fixed-size journaling.
The Threshold qualifier sets an approximate limit on the size
of the active .aij file. When the size of the active .aij file
exceeds the threshold, you cannot initiate new transactions
until the backup process finishes backing up and truncating
(resetting) the active .aij file. During the backup operation,
existing transactions can continue to write to the .aij file.
Before new transactions can start, all activity issuing from
existing transactions (including activity occurring after the
threshold is exceeded) must be moved from the active .aij disk
file to the .aij backup file. At that time, the active .aij file
will be completely truncated.
If you use the default, the Nothreshold qualifier, each backup
cycle will completely back up the active .aij file. Oracle
Corporation recommends using the Nothreshold qualifier.
An appropriate value for the Threshold qualifier depends on the
activity of your database, how much disk space you want to use,
whether backup operations will be continuous, and how long you
are willing to wait for a backup operation to complete.
See the Oracle Rdb7 Guide to Database Performance and Tuning for
more information on setting SPAM thresholds.
29 – Until
Until=time
Specifies the approximate future time and date to stop the
continuous backup process. There is no default.
30 – Wait
Wait=n
Nowait
Specifies whether the backup operation should wait (the Wait
qualifier) or terminate (the Nowait qualifier) when it encounters
a journal that is not ready to be backed up. The value specified
for the Wait qualifier is the time interval in seconds between
attempts to back up the journal that was not ready.
The Wait or Nowait qualifier can only be specified if the
Sequence qualifier is also specified. When the Wait qualifier is
specified, the default value for the time interval is 60 seconds.
The default is the Nowait qualifier.