Enabling supplemental logging
Recently I faced the following issues while enabling supplemental logging
When I enabled supplemental logging at database level
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
The following error was reported on application server
DM(master) respawning backend child for slot
and there were connectivity issues on the application server
When I enabled supplemental logging at table level
ADD TRANDATA ACCOUNT;
The following error was reported on application server
ORA-01466: unable to read data - table definition has changed
Also I got the following message when I added table level supplemental logging for some tables
WARNING OGG-00706 Failed to add supplemental log group on table <...> due to ORA-00054: resource busy and acquire with NOWAIT specified, SQL ALTER TABLE "........
Can anyone explain these