supplemental logging in oracle streams
Posted on 2009-04-20
i have a small question on supplemental logging in oracle streams. i am trying to configure oracle streams. in oracle documentation i have seen enable supplemental logging at table on source database. i did not quite understand what is supplemental logging. can any one clarify me.
in the documentation have seen this info.
Additional column data placed in a redo log whenever an operation is performed. A capture process captures this additional information and places it in LCRs, and the additional information might be needed for an apply process to apply LCRs properly at a destination database.
what type additional data is placed when we enable supplemental logging.
what happen if i do not enable supplemental logging.
one more question is, i am configuring 1 way replication. do i need to enable archive log mode fro source database and target database?