Entering content frameSyntax documentation check_controlfile_mirror Locate the document in its SAP Library structure

ORACLE offers the possibility to mirror the control files. SAPDBA can check the presence and validity of the control files and their ORACLE mirrors. See also check_initial_settings.

Default value: Y

Possible values: Y/N (Y(es) - control file check is executed, N(o) - control file check is not executed).

The setting Y (es) means that, on starting up, SAPDBA issues a warning if one of the control files defined in init<DBSID>.ora is not present or invalid. Only then does the initial menu appear. If SAPDBA is already running, this check is performed when ORACLE reads the file init<DBSID>.ora (e.g. on starting the database).

See also Mirroring the Control File.

Leaving content frame