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

SAPDBA checks several requirements that must be fulfilled in order to safely operate the ORACLE database (for interactive work with SAPDBA).

Default value: Y

Possible values: Y/N (Y(es) - checks are performed, N(o) - no checks are performed).

Setting Y (es) causes SAPDBA to check the following:

  1. No combination of Database log mode archivelog and Automatic archival disabled .
  2. Existence and validity of the control file and its mirror copies.
  3. Existence and validity of the four online redo log files and of at least one mirror copy of each online redo log file.

If one or more of the above conditions are not met, SAPDBA displays a warning when starting up. The initial menu then appears. If SAPDBA is already running, some of these checks are performed when ORACLE reads the file init<DBSID>.ora (e.g. on starting the database).

Setting N (o) deactivates all these checks. It is possible to deactivate only some of the checks and keep others active by using the parameter check_controlfile_mirror and/or check_redolog_mirror (see check_controlfile_mirror and/or check_redolog_mirror).

Leaving content frame