ORA-32593: database supplemental logging attributes in flux

For databases with high activity where there are always active transactions the supplemental logging can be enabled by bouncing the database and running the statement manually:
STARTUP MOUNT
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE OPEN;


Cause:


When you enable supplemental logging, additional information is recorded in the redo stream that is needed to make the information in the
redo log files useful to you.

The amount of redo generated when supplemental logging is enabled is quite high when compared to when supplemental logging is disabled

1)This may significantly increase the size of redo logs and will have some impact on performace of database.
2)No
3)You must enable supplemental logging prior to generating log files that will be analyzed by LogMiner.

Review Note 750198.1 Effect of Supplemental Logging on LogMiner with Example

If you do not intend to use Logminer , you must disable supplemental logging

You can turn off Supplemental Logging by following command.

SQL> ALTER DATABASE DROP SUPPLEMENTAL LOG DATA;