> Expert > Backup and Restore Agents > Databases > Oracle > Oracle Backup Administrator Guide > Oracle Online Help

Instance Properties (Details)

When you create a new instance, use this dialog box to add the details of the instance. For an existing instance, use this tab to view or change the details of the selected instance.

Use Oracle Wallet Auto Login

Use the Oracle Wallet Manager that provides a more secure connection to the database by providing encrypted passwords. You can use this feature when you use scripts to connect to the Oracle database.

When you use the Oracle Wallet, the Commvault software does not use the Oracle Connect String to connect to the Oracle database, so you only need to provide the Oracle Service Name.

Note: If you do provide the user name and password, the Oracle Wallet feature is not used.

Connect String

An account with database administrator privileges to access the Oracle database (Standard and Recovery Catalog databases). The account information is provided as a connect string with the following information:

  • Database user ID

  • Password for the user ID

  • Oracle Service name

You can use separate accounts to access the standard database and the Recovery Catalog database. The Recovery Catalog database user account must have recovery catalog owner privileges.

By default, the user account for the standard database has administration privileges. If you want to use a different account, see the following table for the user account requirements to access the database:

Account Type

The User Account Should Have:

Administrator

  • Oracle database administration privileges.

  • SYSDBA or SYSBACKUP (in Oracle version 12 or higher), ALTER SYSTEM, and SELECT ANY TABLE system privileges.

Non-Administrator

Access to specific objects (as opposed to the admin account with the SELECT ANY TABLE privilege)

For example:

  • SELECT ON "SYS"."V_$DATABASE"

  • SELECT ON "SYS"."V_$DATAFILE"

  • SELECT ON "SYS"."V_$SESSION"

  • SELECT ON "SYS"."DBA_TABLESPACES"

  • GRANT SELECT ON "SYS"."V_$ARCHIVE_DEST" TO "USER_NAME

Additional accounts (except Impersonate User) should be established by the Oracle database administrator.

Use Catalog Connect

When selected, a connection is established between the target database and the Recovery Catalog database using the specified connect string, and the Recovery Catalog database will be used for backups.

When cleared, there will be no connection between the target database and the Recovery Catalog database, and the target database Control Files will be used for backups.

The three fields are used to identify/create the connect string for the Recovery Catalog database. You can change the connect string by using entering 1) Recovery Catalog database user ID, 2) password for the user ID @ Recovery Catalog service name.

TNS_ADMIN folder

Identifies the path to the TNS Admin directory. If you have not provided the path, a default path \network\admin is appended to the path of the $ORACLE_HOME directory.

For example, if $ORACLE_HOME is /opt2/oracle, then TNS_ADMIN is /opt2/oracle/network/admin.

Browse

Click to establish or change the designated TNS_ADMIN directory.

Disable RMAN Crosscheck

When you do not select this option (which is also the default), the Commvault software automatically runs an RMAN script that sets the prunable backup piece to unavailable when the data aging job runs.

When you select this option, the Commvault software does not run the script, which causes the prunable backup piece to remain unchanged when the data aging job runs.

Automatic Backup of Control Files

Lists the configuration options available AUTOBACKUP of control file so that every time a BACKUP or COPY command is executed in RMAN, an autobackup of the control file is performed.

Select one of the following:

  • Not Configure - Disables autobackup of the control file.

  • Configure On - the control file and server parameter files are written to a separate autobackup piece during backup. The autobackup enables RMAN to recover the database even if the current control file, catalog, and server parameter file are lost.

  • Configure Off - RMAN will not create a separate autobackup piece containing the control file and server parameter file.

Block Size

Specify the block size for backup and restore operations on the selected instance. You can disable the block size specification by setting the value to 0. In such cases, the default RMAN block size value will be used for backup and restore operations.

If set, the value must be a multiple of the minimum physical block size of the Oracle database.

The default block size is 1M.

Loading...