Use this tab to define the backup arguments of a new subclient or to change the backup arguments of an existing subclient.
- Data Files per BFS
Use this space to specify the number of data files to be bundled in each RMAN backup set. When a value is entered greater than the default setting of 32, the following line will be displayed in the RMAN log file: set limit channel ch1 maxopenfiles = nn;
- Archive Files per BFS
Use this space to specify the number of archive files to be bundled in each RMAN backup set.
- Max Backup set Size (KB)
Use this space to specify the maximum size, in kilobytes, allowed for an RMAN backup set.
- Max Open Files
Use this space to specify the maximum number of concurrent open data files that RMAN can read from simultaneously during a backup operation.
- Oracle Tag
Use this space to enter a character string that will be used as the Oracle Tag argument associated with backups performed on the selected subclient.
The offline arguments are enabled when you choose Offline Databases in the Content tab.
- Lights Out Script
Specifies whether the Lights Out Script will be automatically executed before backing up databases. This script shuts down the database and uses the SPFile to start up the database in mount mode. Once the backup is completed, the script opens the database. When cleared, you will have to manually start the database in mount mode, before performing a backup of an offline database. The lights out script is automatically installed with the Oracle iDataAgent.
For Oracle on Unix, specifies whether to issue a message to the physical node for users logged into the database warning them that the database will be shut down in the number of minutes specified in the Delay Time (min) option.
- Delay Time (min)
For Oracle on Unix, use this space to specify the number of minutes that you want the system to wait after the warning message is sent to the physical node before attempting to shut down the database.
- Sleep Time (min)
Use this space to specify the interval in minutes that you want the system to wait, or sleep, between retry attempts to shut down the database and check the status. Note that this option is only activated when the number of tries limit has been reached for the Sleep Time (sec) option.
- Tries Number
Use this space, located below the Sleep Time (min) option, to specify the number of times that the system will retry attempts to shut down the database when the Sleep Time (min) option is activated.
- Sleep Time (sec)
Use this space to specify the interval in seconds that you want the system to wait, or sleep, between retry attempts to shut down the database and check the status. Note that this option is only activated when the database cannot be shut down during the first attempt after the Delay Time (min) has expired.
- Tries Number
Use this space, located below the Sleep Time (sec) option, to specify the number of times that the system will retry attempts to shut down the database when the Sleep Time (sec) option is activated.
- Use SQL Connect
When selected, the CommServe connects to the oracle database using the SQL command “Connect <Connect string> as sysdba”. The “Connect String” value is configured in the Instance properties (Details) tab. When not selected, the connection is established using the SQL command “Connect /as sysdba”.
- STARTUP PFILE location
Specifies the location of the PFile to be used with the Lights Out Script option. You need to select this option only if you want to start up the database using the PFile. By default, the system uses the SPFile available in $ORACLE_HOME/dba directory (for Unix) or $ORACLE_HOME/database directory (for Windows) to start up the database.
Click to establish or change the designated STARTUP PFILE.
- SKIP READ ONLY
Specifies whether to omit read-only tablespaces from the backup.
- SKIP OFFLINE
Specifies whether to omit offline tablespaces from the backup.
- SKIP INACCESSIBLE
Specifies whether to omit data files and archived redo log files that are inaccessible due to read I/O errors from the backup. When cleared, the backup fails when it encounters inaccessible data files and archived redo log files.
Specifies whether to run a validate backup job, which will cause RMAN to simulate a backup job for the purpose of determining whether the backup can be successfully restored.
- Enable Table Browse
Specifies that the Oracle iDataAgent or Oracle RAC iDataAgent gathers the database tables and user information during the backup so that the backup data can be displayed in a table view during a browse operation. This option can be used only on subclients configured for online backups.
- Merge Incremental Image Copies
Specifies that you can create an image copy of a database, then regularly create incremental backups of the database and apply them to this image copy. The system will update the image copy with all the incremental changes that have taken place since the previous full backup using the System Change Number (SCN) . RMAN can use this updated datafile in media recovery in the same manner as it would use a regular full image copy taken at that SCN. This reduces the overhead of performing a full image copy of the database everyday.
- Resync Catalog
Specifies whether the contents of the Recovery Catalog will be synchronized with the contents of the control file.