My Oracle Support Banner

Missed Database Supplemental Log Information After Recreate Controlfile In 10g Database. (Doc ID 1474952.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version and later
Information in this document applies to any platform.


You have recreated the controlfile and notice that database supplemental log information was resetted querying:

SQL> SELECT supplemental_log_data_min min_log,
            supplemental_log_data_pk pk_log,
            supplemental_log_data_ui ui_log,
            supplemental_log_data_fk fk_log,
            supplemental_log_data_all all_log,
            force_logging force_log
     FROM v$database;


Note: you need supplemental logging when using one of these features: Logminer, Streams or Standby Databases.


The problem will happen if you recreate the database control files.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.