Transaction_Mode=(mode-list)
Sets the allowable transaction modes for the database root
file restored by the restore operation. The primary use of
this qualifier is when you restore a backup file (of a master
database) to create a Hot Standby database. Because only read-
only transactions are allowed on a standby database, you should
use the Transaction_Mode=Read_Only qualifier setting. This
setting prevents modifications to the standby database at all
times, even when replication operations are not active. For more
information on Hot Standby see the Oracle Rdb7 and Oracle CODASYL
DBMS: Guide to Hot Standby Databases. The mode-list can include
one or more of the following transaction modes:
o All - Enables all transaction modes
o Current - Enables all transaction modes that are set for the
source database. This is the default transaction mode.
o None - Disables all transaction modes
o [No]Batch_Update
o [No]Read_Only
o [No]Exclusive
o [No]Exclusive_Read
o [No]Exclusive_Write
o [No]Protected
o [No]Protected_Read
o [No]Protected_Write
o [No]Read_Write
o [No]Shared
o [No]Shared_Read
o [No]Shared_Write
Your restore operation must include the database root file.
Otherwise, RMU Restore returns the CONFLSWIT error when you issue
an RMU Restore command with the Transaction_Mode qualifier.
If you specify more than one transaction mode in the mode-list,
enclose the list in parenthesis and separate the transaction
modes from one another with a comma. Note the following:
o When you specify a negated transaction mode, it indicates
that a mode is not an allowable access mode. For example, if
you specify the Noexclusive_Write access mode, it indicates
that exclusive write is not an allowable access mode for the
restored database.
o If you specify the Shared, Exclusive, or Protected transaction
mode, Oracle RMU assumes you are referring to both reading and
writing in that transaction mode.
o No mode is enabled unless you add that mode to the list, or
you use the All option to enable all transaction modes.
o You can list one transaction mode that enables or disables a
particular mode followed by another that does the opposite.
For example, Transaction_Mode=(Noshared_Write, Shared) is
ambiguous because the first value disables Shared_Write access
and the second value enables Shared_Write access. Oracle
RMU resolves the ambiguity by first enabling the modes as
specified in the modes-list and then disabling the modes as
specified in the modes-list. The order of items in the list is
irrelevant. In the example presented previously, Shared_Read
is enabled and Shared_Write is disabled.