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.