1 – Access
Access=Restricted
Access=Unrestricted
Permits the database administrator to open the database
and restrict access to it in order to perform maintenance
operations or to restructure the database without interference
from users who want to gain access. If access is restricted
(Access=Restricted), the DBADM privilege is required for SQL
access to the database. If the Access=Unrestricted qualifier is
specified, users without the DBADM privilege can attach to the
database.
NOTE
Do not confuse the Oracle RMU Access=Restricted qualifier
with the SQL restricted access clause (available for use
with the following SQL statements: ATTACH, CREATE, DECLARE
ALIAS, and IMPORT). When you specify the restricted access
clause in SQL, only one user can attach to the database;
when you specify the Access=Restricted qualifier using
Oracle RMU, any number of users with the DBADM privilege
can access the database.
Furthermore, note that an SQL SHOW DATABASE command
displays the phrase "No Restricted Access" or the phrase
"Restricted Access" if access has been restricted using the
SQL restricted access clause. However, SHOW DATABASE tells
you nothing about whether Oracle RMU has opened a database
with access restricted. Use the RMU Dump command to view the
Oracle RMU access setting.
Refer to the Oracle Rdb SQL Reference Manual for more
information on the SQL restricted access clause.
If you specify the RMU Open command without the Access qualifier,
Oracle RMU opens the database in the same access mode as the last
RMU Open command performed. If the database was last opened as
restricted, issuing the RMU Dump command results in the following
message being displayed:
Access restricted to privileged users
Use this form of the RMU Open command to open the database on
other nodes without changing the access mode.
The access mode is clusterwide and the last mode set with the RMU
Open command is used for the entire cluster.
For example, if you open the mf_personnel database on node A with
the Access=Unrestricted qualifier, and open the same database
on node B with the Access=Restricted qualifier, the database
has restricted access on both node A and node B. However, the
commands do not terminate any user processes that may have gained
access while the database was unrestricted.
The access mode is stored in the database. Consequently, if
the system fails while access is restricted, access remains
restricted unless the unrestricted mode is explicitly requested.
The RMU Backup, RMU Restore, and RMU Copy_Database commands also
preserve the access mode.
The RMU Close command does not alter the access mode. You can
change the mode by using the RMU Open command only. You can use
the RMU Open command to restrict access to any database, whether
it was opened as AUTOMATIC or MANUAL.
The Access qualifier is a positional qualifier.
2 – Global Buffers
Global_Buffers[=(Total=i,User_Limit=j)]
Allows you to set the basic global buffer parameters on each
RMU Open command. If you specify the Global_Buffers qualifier,
you can optionally specify values for the Total and User_Limit
parameters:
o Total is the number of global buffers per node to allocate for
this opened instance of the database (minimum = 5, and maximum
o User_Limit is the maximum number of global buffers to be
allotted to any given user (minimum = 5, maximum = Total).
The default values for Total and User_Limit are set by:
o The RMU Open command explicitly
o Values determined at the time the database was created
If you do not specify a value for the Total or User_Limit
options, the values are determined based on what they were when
the database was created.
If a database does not have global buffers enabled, the Global_
Buffers qualifier is ignored. Use the RMU Dump command to see
if global buffering is enabled or disabled. The RMU Dump command
also shows the global buffer count and the maximum global buffer
count per user. For example:
$ RMU/DUMP MF_PERSONNEL
*------------------------------------------------------------------
* Oracle Rdb V7.0-00 22-SEP-1995 10:11:51.14
*
* Dump of Database header
* Database: DISK1:[DATABASE]MF_PERSONNEL.RDB;1
*
*-------------------------------------------------------------------
Database Parameters:
Root filename is "DISK1:[DATABASE]MF_PERSONNEL.RDB;1"
Created at 7-APR-1994 16:50:09.01
Oracle Rdb structure level is 70.0
Maximum user count is 50
Maximum node count is 16
Database open mode is AUTOMATIC
Database close mode is AUTOMATIC
Database is available for READ WRITE access
Snapshot mode is NON-DEFERRED
Statistics are enabled
Storage Areas...
- Active storage area count is 10
- Reserved storage area count is 0
Buffers...
- Default user buffer count is 20
- Default recovery buffer count is 20
- Global buffers are enabled <--------
- Global buffer count is 250 <--------
- Maximum global buffer count per user is 5 <--------
- Buffer size is 6 blocks
.
.
.
Derived Data...
- Global section size
With global buffers disabled is 70962 bytes
With global buffers enabled is 975992 bytes
.
.
.
The Global_Buffers qualifier is a positional qualifier.
3 – Path
Path
Specifies the full or relative data dictionary path name in which
the definitions reside for the database you want to open.
The Path qualifier is a positional qualifier. The path name
cannot include wildcard characters.
4 – Row Cache=Disable
Disables row caching. This qualifier is provided for use with hot
standby databases. Row caching cannot be enabled on a hot standby
database while replication is active. If it is enabled, the hot
standby feature will not start.
5 – Statistics=Import
Statistics=Import
Nostatistics
Specifies that statistic information previously saved by using
the Statistics=Export qualifier on the RMU Close command is to be
loaded when the database is opened. The default is Nostatistics,
which indicates that statistic information is not loaded when the
database is opened.
After the database is opened using the Statistics=Import
qualifier, the saved statistics file is closed. The statistics
file is not automatically deleted. It can be deleted if it is no
longer needed.
When you use the Statistics=Import qualifier, statistics
information is automatically preserved in the event of abnormal
database closure. To ensure that the ondisk statistic information
files are accurate in the case of a node or monitor failure,
the statistic information files are checkpointed by the database
monitor every half-hour. The RMU Show Users command identifies
when the checkpoint for each database occurs.
The statistic files are not loaded if the physical schema of the
database has changed since the statistic file was created. This
means that the addition or deletion of storage aras, logical
areas, and record caches invalidate the statistic files. This
restriction prevents incorrect statistic information from being
loaded when intervening physical changes occur to the database.
Closing the database updates the statistic files and makes
them valid. Use the RMU Show Users command to verify that the
statistic information file was imported.
6 – Wait
Wait
Nowait
Specifies whether the system prompt should be returned before
the database is completely open and available. Specify the
Wait qualifier if you want the system prompt returned when the
database is completely open and available. Specify Nowait if you
want the system prompt returned immediately, regardless of the
state of the open operation.
The Nowait qualifier is the default.