Remove Supplemental Logging for a table form Golden Gate Replication by example
Commands:
DBLOGIN USERID ogguser, password xxxxxxx
INFO TRANDATA CELL_USER.CELL_REPORT_DATA
DELETE TRANDATA CELL_USER.CELL_REPORT_DATA
DELETE TRANDATA CELL_USER.CELL_REPORT_DATA, ALLCOLS
INFO TRANDATA CELL_USER.CELL_REPORT_DATA
Double check from sqlplus:
SELECT log_group_name, log_group_type
FROM DBA_LOG_GROUPS
WHERE table_name='CELL_REPORT_DATA';
If there is data:
ALTER TABLE CELL_USER.CELL_REPORT_DATA DROP SUPPLEMENTAL LOG GROUP <log_group_name>;
By Example:
DBLOGIN USERID gguser, password xxxxxxx
Successfully logged into database.
INFO TRANDATA CELL_USER.CELL_REPORT_DATA
2024-12-16 06:36:57 INFO OGG-10471 ***** Oracle Goldengate support information on table CELL_USER.CELL_REPORT_DATA *****
Oracle Goldengate support native capture on table CELL_USER.CELL_REPORT_DATA.
Oracle Goldengate marked following column as key columns on table CELL_USER.CELL_REPORT_DATA: TCAP_ID, TS_START, ACTION_REASON_ID, VLR, LAC, CELL, IS_BORDER, IMSI, SESSION_ID
No unique key is defined for table CELL_USER.CELL_REPORT_DATA.
Logging of supplemental redo log data is enabled for table CELL_USER.CELL_REPORT_DATA.
Columns supplementally logged for table CELL_USER.CELL_REPORT_DATA: "TCAP_ID", "TS_START", "ACTION_REASON_ID", "VLR", "LAC", "CELL", "IS_BORDER", "IMSI", "SESSION_ID"
Prepared CSN for table CELL_USER.CELL_REPORT_DATA: 51949060106
DELETE TRANDATA CELL_USER.CELL_REPORT_DATA
2024-12-16 06:39:25 INFO OGG-15142 Logging of supplemental redo log data disabled for table CELL_USER.CELL_REPORT_DATA.
2024-12-16 06:39:25 INFO OGG-15139 TRANDATA for scheduling columns has been disabled on table CELL_USER.CELL_REPORT_DATA.
DELETE TRANDATA CELL_USER.CELL_REPORT_DATA, ALLCOLS
2024-12-16 06:39:42 INFO OGG-15141 Logging of supplemental redo log data is already disabled for table CELL_USER.CELL_REPORT_DATA.
2024-12-16 06:39:42 INFO OGG-15137 TRANDATA is already disabled for table CELL_USER.CELL_REPORT_DATA.
2024-12-16 06:39:42 INFO OGG-15137 TRANDATA is already disabled for table CELL_USER.CELL_REPORT_DATA.
INFO TRANDATA CELL_USER.CELL_REPORT_DATA
2024-12-16 06:40:09 INFO OGG-10471 ***** Oracle Goldengate support information on table CELL_USER.CELL_REPORT_DATA *****
Oracle Goldengate support native capture on table CELL_USER.CELL_REPORT_DATA.
Oracle Goldengate marked following column as key columns on table CELL_USER.CELL_REPORT_DATA: TCAP_ID, TS_START, ACTION_REASON_ID, VLR, LAC, CELL, IS_BORDER, IMSI, SESSION_ID
No unique key is defined for table CELL_USER.CELL_REPORT_DATA.
Logging of supplemental redo log data is disabled for table CELL_USER.CELL_REPORT_DATA.
Double check from sqlplus:
SELECT log_group_name, log_group_type
FROM DBA_LOG_GROUPS
WHERE table_name='CELL_REPORT_DATA';
no rows selected
No comments:
Post a Comment