Oracle mirroring parameters

The following table describes the Oracle mirroring parameters worksheet when building or copying a database. You need these values when you set up the mirror database.

Parameter

Description

Control‑M Mirror Database Owner (DBO)

Defines the name of the Control‑M/Server Mirror database owner. Control‑M uses the name when accessing the mirror database.

When building a new mirror database, the initialization script creates this user on the database server. When copying to an existing database, this user must already be defined on the database server.

NOTE: After using the utility, enter the DBO password to access the Control-M/Server database. Limited to 30 alphanumeric characters (including underscores).

Default: ctrlm

DBO password

Defines the password for the Control‑M/Server database user (6 to 30 characters alphanumeric). The characters you enter do not echo for security reasons. Control‑M processes and utilities use the password to access the Control‑M/Server database.

Mirror Oracle Host Name

Defines the host computer name of an existing Oracle server.

Mirror Oracle Port Number

Defines the communication port of the Oracle Database Server.

If you use a Control-M dedicated database SQL Server for the mirror database, the Port Number can be found in the QUERY_SPN field in the <controlm_owner>/install/install_defs file.

Refresh Type: Recycle

Mirror Oracle Instance Name (SID)

Defines the Server ID of the Oracle Database Server.

Type the command echo $ORACLE_SID on the mirror database server to obtain the name of the server.

Default: ctrlm

NOTE: The name must contain 1 to 8 alpha characters and an underscore.

Control-M Mirror tablespace name

Defines the name of a defined tablespace on the database server that the mirror database uses. The name must be unique.

Default: ctrlm

NOTE: Name starts with a letter followed by 1-24 alphanumeric characters.

Control-M Mirror SID

Defines the instance name of the Control-M/Server database.
Default: ctrlm_mirror

The ORACLE_SID parameter must be unique and not appear more than once in the tnsnames.ora file. For more information see Oracle documentation.

NOTE: The Oracle database instance name must conform to the Oracle naming convention.

Control-M Mirror Retry

Defines the the number of retries the Control-M/Server attempts before marking the mirror as damaged.

Valid values: 0-99 seconds.

Default: 10 seconds

Database Administrator Password

Defines the password of the database server administrator

Force (default: Y)

Defines whether existing user are dropped before mirror initialization when the requested username is the same as the existing user.

If set to N, the existing user won’t be dropped and the mirror initialization aborts.

Valid values: Y,N

Data Device Physical Full File

Defines the database data location path

Data File Size

Defines the database size in MB created in the database server. The database size must have a numeric number.

Parent Topic

Mirroring parameters