1 – Active IO
Active_IO=max-reads Specifies the maximum number of read operations to the backup file that the RMU Restore Only_Root command will attempt simultaneously. The value of the Active_IO qualifier can range from 1 to 5. The default value is 3.
2 – After Journal
After_Journal=file-spec Noafter_Journal NOTE This qualifier is maintained for compatibility with versions of Oracle Rdb prior to Version 6.0. You might find it more useful to specify the Aij_Options qualifier, unless you are only interested in creating extensible .aij files. Specifies how RMU Restore Only_Root is to handle after-image journaling and .aij file creation, using the following rules: o If you specify the After_Journal qualifier and provide a file specification, RMU Restore Only_Root creates a new extensible .aij file and enables journaling. o If you specify the After_Journal qualifier but you do not provide a file specification, RMU Restore Only_Root creates a new extensible .aij file with the same name as the journal that was active at the time of the backup operation. o If you specify the Noafter_Journal qualifier, RMU Restore Only_Root disables after-image journaling and does not create a new .aij file. Note that if you specify the Noafter_Journal qualifier, there will be a gap in the sequence of .aij files. For example, suppose your database has .aij file sequence number 1 when you back it up. If you issue an RMU Restore Only_Root command with the Noafter qualifier, the .aij file sequence number will be changed to 2. This means that you cannot (and do not want to) apply the original .aij file to the restored database (doing so would result in a sequence mismatch). o If you do not specify an After_Journal, Noafter_Journal, Aij_ Options, or Noaij_Options qualifier, RMU Restore Only_Root recovers the journal state (enabled or disabled) and tries to reuse the .aij file or files. If you choose this option, take great care to either set the database root TSN and CSN correctly, or create a full and complete backup file of the database. Failure to do so might make it impossible for you to recover your database from the .aij file should it become necessary. However, if the .aij file or files are not available (for example, they have been backed up), after-image journaling is disabled. You cannot use the After_Journal qualifier to create fixed-size .aij files; use the Aij_Options qualifier.
3 – Aij Options
Aij_Options=journal-opts Noaij_Options Specifies how RMU Restore Only_Root is to handle after-image journaling and .aij file creation, using the following rules: o If you specify the Aij_Options qualifier and provide a journal-opts file, RMU Restore Only_Root enables journaling and creates the .aij file or files you specify for the restored database. If only one .aij file is created for the restored database, it will be an extensible .aij file. If two or more .aij files are created for the database copy, they will be fixed-size .aij files (as long as at least two .aij files are always available). o If you specify the Aij_Options qualifier, but do not provide a journal-opts file, RMU Restore Only_Root disables journaling and does not create any new .aij files. o If you specify the Noaij_Options qualifier, RMU Restore Only_ Root disables journaling and does not create any new .aij files. o If you do not specify an After_Journal, Noafter_Journal, Aij_ Options, or Noaij_Options qualifier, RMU Restore Only_Root recovers the journaling state (enabled or disabled) and tries to reuse the .aij file or files. If you choose this option, take great care to either set the database root TSN and CSN correctly, or create a full and complete backup file of the database. Failure to do so might make it impossible for you to recover your database from the .aij file should it become necessary. However, if the .aij file or files are not available (for example, they have been backed up), after-image journaling is disabled. See Show After_Journal for information on the format of a journal-opts-file.
4 – Directory
Directory=directory-spec Specifies the default directory for the database root and the default directory for where the root can expect to find the database storage areas and snapshot files. See the Usage Notes for information on how this qualifier interacts with the Root, File, and Snapshot qualifiers and for warnings regarding restoring database files into a directory owned by a resource identifier.
5 – Initialize Tsns
Initialize_Tsns Noinitialize_Tsns Initializes all transaction sequence number (TSN) values for the entire database by setting the values to zero. Each time a transaction is initiated against a database, a TSN is issued. The numbers are incremented sequentially over the life of the database. TSN and CSN values are each contained in a quadword with the following decimal format: high longword : low longword The high longword can hold a maximum user value of 32768 (215) and the low longword can hold a maximum user value of 4,294,967,295 (232). A portion of the high longword is used by Oracle Rdb for overhead. When you specify a TSN or CSN, you can omit the high longword and the colon if the TSN or CSN fits in the low longword. For example 0:444 and 444 are both valid input values. As your next TSN value approaches the maximum value allowed, you should initialize the TSNs. You can determine the next TSN and next commit sequence number (CSN) values by dumping the database root file, using the RMU Dump command with the Header and Option=Debug qualifiers. The Initialize_Tsns qualifier takes much more time to execute because all TSN values in the database are set to zero, which requires writing to every page in the database. When the database TSNs are reset, using the Initialize_Tsns qualifier, you should use the After_Journal qualifier or the Aij_Options qualifier and immediately perform a full database backup operation and create a new .aij file. This ensures continuity of journaling and the ability to recover the database. The default Noinitialize_Tsns qualifier does not initialize the database TSNs. Note that you cannot use the Initialize_Tsns with the Set_Tsn or Noset_Tsn qualifier in the same command. This restriction is required because Initialize_Tsns directs RMU Restore Only_Root to reset the TSN value to zero, while Set_Tsn directs RMU Restore Only_Root to reset the TSN to the value you have indicated, and Noset_Tsn leaves the TSN value unchanged. Never use the Initialize_Tsns qualifier if Replication Option for Rdb transfers have been defined for the database. The Initialize_Tsns qualifier does not reset the Replication Option for Rdb transfers.
6 – Label
Label=(label-name-list) Specifies the 1- to 6-character string with which the volumes of the backup file have been 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. In a normal restore operation, the Label qualifier you specify with the RMU Restore Only_Root command should be the same Label qualifier you specified with the RMU Backup command you used to back up your database. The Label qualifier can be used with indirect file references. See the Indirect-Command-Files help entry for more information.
7 – Librarian
Librarian=options Use the Librarian qualifier to restore files from data archiving software applications that support the Oracle Media Management interface. The file name specified on the command line identifies the stream of data to be retrieved from the Librarian utility. If you supply a device specification or a version number it will be ignored. Oracle RMU supports retrieval using the Librarian qualifier only for data that has been previously stored by Oracle RMU using the Librarian qualifer. 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 application. 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 implementation 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.
8 – Log
Log Nolog Specifies whether the processing of the command is reported to SYS$OUTPUT. Specify the Log qualifier to request that the progress of the restore operation be written to SYS$OUTPUT and the Nolog qualifier to suppress this report. 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.)
9 – Media Loader
Media_Loader Nomedia_Loader Use the Media_Loader qualifier to specify that the tape device from which the backup file is being read 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, RMU Restore Only_Root should recognize this fact. However, occasionally RMU Restore Only_Root does not recognize that a tape device has a loader or stacker. Therefore, when the first tape has been read, RMU Restore Only_Root issues a request to the operator for the next tape, instead of requesting the next tape from the loader or stacker. Similarly, sometimes RMU Restore Only_Root behaves as though a tape device has a loader or stacker when actually it does not. If you find that RMU Restore Only_Root is not recognizing that your tape device has a loader or stacker, specify the Media_ Loader qualifier. If you find that RMU Restore Only_Root expects a loader or stacker when it should not, specify the Nomedia_ Loader qualifier.
10 – New Snapshots
New_Snapshots Nonew_Snapshots Allows you to specify whether to create new snapshot (.snp) files as part of a Restore Only_Root operation. The default is the Nonew_Snapshots qualifier, which causes the command to initialize the existing .snp files. If you specify the New_Snapshots qualifier, the command creates and initializes new .snp files. When you specify the New_ Snapshots qualifier, you should either delete the existing .snp files before the restore operation or purge the .snp files afterwards.
11 – Nodes Max
Nodes_Max=number-cluster-nodes Specifies a new upper limit on the number of VMScluster nodes from which users can access the restored database. The Nodes_Max qualifier will accept values between 1 and 96 VMScluster nodes. The actual maximum is the highest number of VMScluster nodes possible in the current version of OpenVMS. The default value is the limit defined for the database before it was backed up.
12 – Options
Options=file-spec Specifies the options file that contains storage area names, followed by the storage area qualifiers that you want applied to that storage area. You can direct RMU Restore Only_Root to create an options file for use with this qualifier by specifying the Restore_Options qualifier with the RMU Backup, RMU Dump, and RMU Dump Backup commands. See Backup Database, Dump Database, and Dump Backup_ File for details. If you create your own options file, do not separate the storage area names with commas. Instead, put each storage area name on a separate line in the file. The storage area qualifiers that you can include in the options file are: Blocks_Per_Page, File, Snapshot, and Thresholds. You can use the DCL line continuation character, a hyphen (-), or the comment character (!) in the options file. The default file extension is .opt. See Example 5 in the Examples help entry under this command.
13 – Rewind
Rewind Norewind Specifies whether the tape that contains the backup file will be rewound before processing begins. The Norewind qualifier, the default, causes the search for the backup file to begin at the current tape position. The Rewind and Norewind qualifiers are applicable only to tape devices. RMU Restore Only_Root returns an error message if you use these qualifiers and the device is not a tape device.
14 – Root
Root=root-file-spec Requests that the database root (.rdb) be restored to the specified location. See the Usage Notes for information on how this qualifier interacts with the Directory, File, and Snapshot qualifiers and for warnings regarding restoring database files into a directory owned by a resource identifier. The Root qualifier is only meaningful when used with a multifile database.
15 – Set Tsn
Set_Tsn=(Tsn=n, Csn=m) Noset_Tsn The Set_Tsn qualifier sets the database transaction sequence number (TSN) and commit sequence number (CSN) to the specified values. The correct value can be extracted from the original .rdb file if it is still accessible, or from the last .aij file if one is available. If that fails, you can use a TSN value larger than the maximum number of transactions applied to the database since it was created, or since TSNs were last initialized. The TSN and CSN values do not have to be the same value. However, you need to choose new values that are greater than the last values assigned to a transaction. Set_Tsn values are expected to be multiples of eight. If you specify a value that is not a multiple of eight, RMU Restore Only_Root assigns the next highest value that is a multiple of eight. (For example, if you specify Set_Tsn=(Tsn=90, Csn=90), RMU Restore Only_Root assigns the Next TSN a value of 96.) The default value for the Set_Tsn qualifier is the TSN and CSN values stored in the backup file plus 1,000,000 when TSNs are not being initialized. The new TSN and CSN values for most database applications should be larger than the number of transactions committed since the database was last backed up. Set the TSN and CSN values higher than this default increment value plus the value in the backup file when needed. You can determine the next TSN and CSN values by dumping the .rdb file, using the Option=Debug qualifier. The TSN and CSN values are each contained in a quadword with the following decimal format: high longword : low longword The high longword can hold a maximum user value of 32768 (215) and the low longword can hold a maximum user value of 4,294,967,295 (232). A portion of the high longword is used by Oracle Rdb for overhead. When you specify a TSN or CSN, you can omit the high longword and the colon if the TSN fits in the low longword. For example 0:444 and 444 are both valid TSN input values. The Noset_Tsn qualifier specifies that the root will be restored with the same TSN state as was recorded in the backup file. When you use the Noset_Tsn qualifier in conjunction with the Noupdate_Files qualifier, you can use a backup strategy that uses recent by-area full backup files in place of a recent full and complete backup file of the entire database. See Example 6 in the Examples help entry under this command. Note that you cannot use the Initialize_Tsns with the Set_Tsn or Noset_Tsn qualifier in the same command. This restriction is required because Initialize_Tsns directs RMU Restore Only_Root to reset the TSN value to zero, while Set_Tsn directs RMU Restore Only_Root to reset the TSN to the value you have indicated, and Noset_Tsn leaves the TSN value unchanged.
16 – Transaction Mode=(mode-list)
Transaction_Mode=(mode-list) Sets the allowable transaction modes for the database root file created by the restore operation. 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 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, for example Noexclusive_Write, it indicates that exclusive write is not an allowable access mode for the copied 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.
17 – Update Files
Update_Files Noupdate_Files The Update_Files qualifier specifies that the root will be restored, and RMU Restore Only_Root will attempt to link that restored root to the area files. In addition, the snapshot (.snp) file will be updated or created. This is the default. The Noupdate_Files qualifier specifies that the restore operation will restore the root, but it will not link that restored root to any of the area files, nor will it create or update the .snp files. When you use the Noupdate_Files qualifier in conjunction with the Noset_Tsn qualifier, you can use a backup strategy that uses recent by-area full backup files in place of a recent full and complete backup file of the entire database. See Example 6 in the Examples help entry under this command
18 – Users Max
Users_Max=number-users Specifies a new upper limit on the number of users that can simultaneously access the restored database. The valid range is between 1 and 2032 users. The default value is the value defined for the database before it was backed up.