Education
Abstract
Detail instruction for Supplemental Logging enable conditions.
Content
https://www.ibm.com/support/knowledgecenter/SSTRGZ_11.4.0/com.ibm.cdcdoc.cdcfororacle.doc/concepts/enablingdatabasesupplementallogging.html
Database-level supplemental logging on all columns means:
select supplemental_log_data_all from v$database;
The result should be YES.
And in this situation, we do not need to consider if 'select supplemental_log_data_min MIN from v$database;' is YES or IMPLICIT.
Minimum level supplemental logging means :
select supplemental_log_data_min MIN from v$database;
The result should be YES or IMPLICIT.
Table level supplemental logging on all columns means:
select * from dba_log_groups where table_name='xxx' ;
If there is result returned, and LOG_GROUP_TYPE is 'ALL COLUMN LOGGING', it means table level supplemental logging on all columns is enable.
Table level supplemental logging with conditional or unconditional log groups:
ALWAYS column = ALWAYS or CONDITIONAL, where we provide different kinds of log group, including "user log group"
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6HD6","label":"InfoSphere Change Data Capture for Oracle Replication"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
25 March 2019
UID
ibm10878246