1 – All
All
When you specify the All qualifier, the entire database is
checked, including any external routines. Specifying the All
qualifier is equivalent to issuing the list of qualifiers shown
in the following command:
$ RMU/VERIFY/ROOT/CONSTRAINTS/INDEXES/DATA/AREAS -
_$ /SNAPSHOTS/LAREAS/ROUTINES MF_PERSONNEL.RDB
If you do not specify the All qualifier, the verification
requested by the other qualifiers you specify is performed.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
2 – Areas
Areas[=storage-area-list]
Specifies the storage areas of the database to verify. You can
specify storage areas by name or by the area's ID number. When
you specify the storage area by name, each storage area name must
be the name defined in the SQL CREATE STORAGE AREA statement for
the storage area, not the storage area file name. If you list
multiple storage areas, separate the storage area names or ID
numbers with a comma, and enclose the storage area list within
parentheses. The Areas qualifier with no arguments (or Areas=*)
directs Oracle RMU to verify all storage areas of the database.
With a single-file database, if you do not specify a storage area
name, the RDB$SYSTEM storage area is verified.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
The Areas qualifier can be used with indirect file references.
See the Indirect-Command-Files Help entry for more information.
When the Areas qualifier is not specified, Oracle RMU does not
verify any storage areas.
3 – Checksum Only
Checksum_Only
Specify with the Areas qualifier to perform only checksum
verification of pages. This reduces the degree of verification
done on a database page. While the RMU Verify command executes
faster with the Checksum_Only qualifier than without it, it does
not verify pages completely. This qualifier allows you to make
trade-offs between speed of verification and thoroughness of
verification. For more information on these trade-offs, see the
Oracle Rdb Guide to Database Maintenance.
If this command finds a problem with a certain page, then that
page can be verified in depth by using other qualifiers, such as
Indexes, Areas, or Lareas.
Note that you can accomplish the same degree of verification
during a backup operation by specifying the Checksum qualifier
with the RMU Backup command. The advantage of specifying the
Checksum qualifier with the RMU Backup command is that the
checksum operation takes place concurrently with the backup
operation.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
The default is for full verification of pages.
4 – Constraints
Constraints
Constraints[=(Constraints=(list))]
Constraints[=(Tables=(list))]
Constraints[=(Tables=(list), Constraints=(list))]
Noconstraints
Specifies which constraints Oracle RMU is to load and execute
to check the integrity of data in the database. In addition,
external routines (procedures and functions) referenced by
constraints are activated and executed. Any exceptions produced
cause the verify operation to report a failure. See the
description of the routines qualifier for information on how
routines are activated and executed.
The options are as follows:
o Tables=(list)
Specifies the table for which constraints are to be checked.
If you specify more than one table, separate each table name
with a comma and enclose the list in parentheses. You can
specify the wildcard character, the asterisk (*), instead of
a table list to indicate that you want constraints checked
for all tables in the database. This option is useful if you
issued an RMU Load command with the Noconstraints qualifier.
o Constraints=(list)
Specifies the constraints which you want Oracle RMU to load
and execute. If you specify more than one constraint, separate
each constraint name with a comma and enclose the list in
parentheses. You can specify the wildcard character, the
asterisk (*), instead of a constraint list to indicate that
you want all constraints checked for the database.
o (Tables=(list), Constraints=(list))
You can specify both the Tables and Constraints options to
specify which combination of tables and constraints you
want Oracle RMU to verify. If you specify the wildcard
character, the asterisk (*), for the Tables option and a
named constraint or constraints for the Constraint option
within the same Oracle RMU command line, Oracle RMU verifies
all constraints.
See the Oracle Rdb Guide to Database Maintenance for more
information on verifying constraints.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
The default is the Noconstraints qualifier. When you specify
the Noconstraints qualifier, Oracle RMU does not verify any
constraints.
5 – Data
Data
Nodata
Specifies whether consistency checks are made between indexes and
tables. When you specify the Data qualifier, Oracle RMU checks
that every row to which an index points is a valid row for the
table and it checks that every row in a table is pointed to by
every index defined on the table. See the description of the
Indexes qualifier for more information on how these comparisons
are made.
The Data qualifier is valid only when it is used with the Indexes
qualifier.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
The default is the Data qualifier.
6 – End
End=page-number
Specifies the last page to be verified. This qualifier is used in
conjunction with the Areas and Lareas qualifiers. If you do not
use the End qualifier, Oracle RMU verifies all pages between the
first page (or the page specified in the Start qualifier) and the
last page of the storage area.
The End qualifier is valid only when you specify the Areas or
Lareas qualifier.
See the Usage Notes entry in this command for the rules that
determine which other qualifiers can be used in combination on
the same RMU Verify command line.
7 – Functions
Functions
Nofunctions
This qualifier is synonymous with the Routines qualifier. See the
description of the Routines qualifier.
8 – Incremental
Incremental
Directs Oracle RMU to verify database pages that have changed
since the last full or incremental verification. Oracle RMU
stores timestamps in the database root file for both full
and incremental verifications. To determine which pages
have changed since the last verify operation, Oracle RMU
compares these timestamps with the page timestamps. The page
timestamps are updated whenever pages are updated. An incremental
verification performs the same number of I/O operations as a
full verification, but the incremental verification takes fewer
CPU cycles than a full verification, allowing you to perform
incremental verifications more frequently than you would perform
full ones. The default is to perform a full verification.
NOTE
If you use the Incremental qualifier with the RMU Verify
command, Oracle Corporation recommends that you use it only
with the All qualifier and not with any other qualifiers.
The timestamps in the database root file are updated during
full and incremental verifications only when the All
qualifier is specified. Therefore, if you do not specify
the All qualifier, two successive incremental verifications
of the same storage area of the database perform the same
verifications. This means that the second incremental
verification does not pass over pages verified by the first
incremental verification, contrary to what you might expect.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
If the Incremental qualifier is not specified, all requested
pages are verified, regardless of the timestamp.
9 – Indexes
Indexes[=index-list]
Verifies the integrity of all but disabled indexes in the
database if you specify the Indexes or the Indexes=* qualifier;
verifies the integrity of a specific index, or of multiple
indexes if you provide an index list. If you list multiple
indexes, separate the index names with a comma, and enclose the
index list within parentheses.
Beginning with Oracle Rdb V7.0, Oracle RMU uses a new method to
verify indexes. In prior versions, the verify operation tried
to retrieve the table row to which the index pointed. Beginning
with Oracle Rdb V7.0, the verify operation creates a sorted list
of all dbkeys for a table and a sorted list of all dbkeys in an
index. By comparing these two lists, the verify operation can
detect any cases of an index missing an entry for a data row. In
addition, the verify operation runs faster. This comparison of
dbkeys occurs at the end of the verify operation. If you specify
the log qualifier, you see messages similar to the following to
indicate that the comparison is occurring:
%RMU-I-IDXVERSTR, Index data verification of logical area
60 (DEGREES) started.
%RMU-I-IDXVEREND, Index data verification of logical area
60 finished.
In addition, beginning in Oracle Rdb V7.0, when you verify an
index with the Data qualifier (the default), Oracle RMU also
verifies the logical areas referenced by the indexes. See Example
5 in the Examples help entry under this command.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
By default, Oracle RMU does not verify indexes.
The Indexes qualifier can be used with indirect file references.
See the Indirect-Command-Files Help entry for more information.
10 – Lareas
Lareas[=logical-area-list]
Specifies the storage area pages allocated to a logical area
or logical areas that you want verified. If you list multiple
logical areas, separate the logical area names with a comma,
and enclose the logical area list within parentheses. The Lareas
qualifier with no arguments (or Lareas=*) directs Oracle RMU to
verify all logical areas of the database. When a logical area is
verified, each page in the area is read and verified sequentially
starting at the first page.
If an index name is specified with the Lareas qualifier, the
index is verified, but it is not verified as a logical area.
In this case, the first index record is fetched (which could be
on any page) and the verification follows the structure of the
index. (For example, if the index record points to other index
records, then those records are fetched and verified. If the
index node is a leaf node, then the data record is fetched and
verified. These data pages might reside in different logical
areas.)
Use this qualifier to verify one or more tables.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
The Lareas qualifier can be used with indirect file references.
See the Indirect-Command-Files Help entry for more information.
By default, Oracle RMU does not verify logical areas.
11 – Log
Log
Nolog
Specifies whether the processing of the command is reported to
SYS$OUTPUT. By default, SYS$OUTPUT is your terminal. Specify the
Log qualifier to request that each verify operation be displayed
to SYS$OUTPUT and the Nolog qualifier to prevent this display.
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.)
When you specify the Log qualifier, Oracle RMU displays the time
taken to verify each database area specified and the total time
taken for the complete verification operation. The display from
the Log qualifier is also useful for showing you how much of the
verification operation is completed.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
12 – Output
Output=file-spec
Specifies the name of the file where output will be sent. The
default is SYS$OUTPUT. When you specify a file name, the default
output file type is .lis.
If you specify both the Log qualifier and the Output qualifier,
the messages produced by the Log qualifier and any error messages
are directed into the output file specification. If you specify
only the Output qualifier, only error messages are captured
in the output file. See the Usage Notes entry in this command
for the rules that determine which qualifiers can be used in
combination on the same RMU Verify command line.
13 – Root
Root
Noroot
Specifies that, in a multifile database, only fields in the
database root (.rdb) file and all the pointers to the database
(.rda, .snp, .aij) files are verified. The snapshot (.snp) files
are validated; that is, only the first page is checked to make
sure that it is indeed an .snp file and belongs to the database
being verified. If after-image journaling is enabled, the .aij
files are validated. The AIP and ABM pages are verified when you
specify the Root qualifier.
If you specify the Noroot qualifier, and no other qualifiers,
only the AIP pages are verified. If you specify the Noroot
qualifier, and the Areas or the Lareas qualifier, ABM and SPAM
pages are verified as the other pages in the storage area or
logical area are verified.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
You can specify the Root qualifier for a single-file database.
The default is the Root qualifier.
14 – Routines
Routines
Noroutines
The Routines qualifier verifies the integrity of all routine
(function and procedure) definitions stored in the database.
Oracle RMU performs the verification by activating and
deactivating each external routine, one at a time. Any exceptions
produced cause the verify operation to report a failure.
The Routines qualifier verifies that the shareable image is
located where expected, is accessible, and that the correct entry
point is at this location. The expected location is that which
was specified in the SQL CREATE FUNCTION or CREATE PROCEDURE
statement. If the shareable image is not in the expected
location, is not accessible, or the entry point is not at the
expected location, you receive an error message.
If Oracle RMU is installed with SYSPRV, any external routine
image for a routine that is registered with client-site binding
must meet the following criteria or the RMU Verify command cannot
check for the existence of the entry point for the routine in the
image:
o It must be installed.
o It must have been specified with an image file specification
that uses only logicals defined with the DCL /SYSTEM and
/EXECUTIVE qualifiers.
In addition, the user issuing the RMU Verify command must have
OpenVMS SYSPRV in order for the routine to be activated.
The Noroutines qualifier specifies that routine interface not be
verified.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
By default, Oracle RMU does not verify any routines.
15 – Segmented Strings
Segmented_Strings
Nosegmented_Strings
Verifies all list (segmented string) data for each column, in
each table in any of the two types of storage areas: read/write
and read-only (on read/write disk devices). When you specify
the RMU Verify command with the All qualifier, all list data
(segmented strings) in all tables is verified in the database.
The Segmented_Strings qualifier can only be used with the Lareas
qualifier and has the following meanings when used with this
qualifier:
o RMU Verify command with the Lareas=* and the Segmented_Strings
qualifiers.
Segmented strings in all tables are verified.
o RMU Verify command with the Lareas=(LAREA_1, . . . ,LAREA_N)
and the Segmented_Strings qualifiers.
Segmented strings in tables LAREA_1, . . . ,LAREA_N are
verified.
If the Segmented_Strings qualifier is omitted, there is no
list data verification.
The Segmented_Strings qualifier verifies all list data in
each column of each row in the database. The verify operation
tries to fetch all pointer segments and all data segments from
the pointer segments, and verifies all header information,
including the total length of the segment, the number of
pointer segments, the number of data segments, and the length
of the longest segment for the list data.
16 – Snapshots
Snapshots
Verifies the snapshot area of the specified storage areas up
to the page header level. The Snapshots qualifier only performs
checksum verification of snapshot pages.
The Snapshots qualifier is valid only when you also specify the
Areas qualifier.
See the Usage Notes entry in this command for the rules that
determine which other qualifiers can be used in combination on
the same RMU Verify command line.
The Snapshots qualifier can be used with indirect file
references. See the Indirect-Command-Files Help entry for more
information.
By default, Oracle RMU does not verify snapshots.
17 – Start
Start=page-number
Specifies the first page to be verified. This qualifier is used
in conjunction with the Areas and Lareas qualifiers. If you do
not use the Start qualifier, the verification begins with the
first page of the storage area.
The Start qualifier is valid only when you specify the Areas or
Lareas qualifier also.
See the Usage Notes entry in this command for the rules that
determine which other qualifiers can be used in combination on
the same RMU Verify command line.
18 – Transaction Type
Transaction_Type=option
Sets the retrieval lock for the storage areas being verified.
Use one of the following keywords to control the transaction
mode:
o Automatic
When Transaction_Type=Automatic is specified, the transaction
type depends on the current database settings for snapshots
(enabled, deferred, or disabled), transaction modes available
to this user, and the standby status of the database.
o Read_Only
Starts a Read_Only transaction.
o Exclusive
Starts a Read_Write transaction and reserves the table for
Exclusive_Read.
o Protected
Starts a Read_Write transaction and reserves the table for
Protected_Read. Protected mode is the default.
o Shared
Starts a Read_Write transaction and reserves the table for
Shared_Read.
Use one of the following options with the keyword Isolation_
Level=[option] to specify the transaction isolation level:
o Read_Committed
o Repeatable_Read
o Serializable. Serializable is the default setting.
Refer to the SET TRANSACTION statement in the Oracle Rdb SQL
Reference Manual for a complete description of the transaction
isolation levels.
Specify the wait setting by using one of the following keywords:
o Wait
Waits indefinitely for a locked resource to become available.
Wait is the default behavior.
o Wait=n
The value you supply for n is the transaction lock timeout
interval. When you supply this value, Oracle Rdb waits n
seconds before aborting the wait and the RMU Verify session.
Specifying a wait timeout interval of zero is equivalent to
specifying Nowait.
o Nowait
Does not wait for a locked resource to become available.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.