Loading...

Properties of Oracle Instance (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.

Connect String

  • When you create a new instance, specify the database connect string.
  • For an existing instance, you can change the database connect string by entering 1) database user ID, 2) password for the user ID @ 3) Oracle instance name in the three spaces provided. The user ID must have SYSDBA, ALTER SYSTEM and SELECT ANY TABLE system privileges.

Alternatively, instead of the SELECT ANY TABLE privilege, you can create less powerful user IDs with the following object privileges:

  • 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"

You can create a user ID with these privileges, or you can use the internal user ID.

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 cross check

When selected, the CommServe database will not be cross verified with the RMAN catalog during a data aging operation.

Ctrl File Autobackup

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:

Not Configure - Disables autobackup of the control file.

Configure On - If the backup includes a datafile, then RMAN will not automatically include the current control file in the datafile backupset, but will write the control file and server parameter file to a separate autobackup piece. If the backup does not include a datafile, the control file and server parameter file will be written to their own autobackup piece.

Configure Off - If the backup includes a datafile, then RMAN automatically includes the current control file and server parameter file in the datafile backupset. 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.