dbTalk Databases Forums  

Streams Replication: Is Supplemental logging mandatory?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Streams Replication: Is Supplemental logging mandatory? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ora_DBA
 
Posts: n/a

Default Streams Replication: Is Supplemental logging mandatory? - 03-18-2010 , 07:46 PM






Is Supplemental logging mandatory when using streams Replication ?

I am trying to replicate about 100 plus tables in a schema. All the
tables in the source database have a primary key. Do I need to create
supplmental logs ?

Thanks in Advance.

Reply With Quote
  #2  
Old   
ddf
 
Posts: n/a

Default Re: Streams Replication: Is Supplemental logging mandatory? - 03-19-2010 , 07:34 AM






On Mar 18, 8:46*pm, Ora_DBA <sanjaydharmadhik... (AT) gmail (DOT) com> wrote:
Quote:
Is Supplemental logging mandatory when using streams Replication ?

I am trying to replicate about 100 plus tables in a schema. All the
tables in the source database have a primary key. Do I need to create
supplmental logs ?

Thanks in Advance.
You alter the database to provide supplimental logging, and yes, it is
mandatory to implement Streams.


David Fitzjarrell

Reply With Quote
  #3  
Old   
sandeep pande
 
Posts: n/a

Default Re: Streams Replication: Is Supplemental logging mandatory? - 05-11-2010 , 05:30 AM



On Mar 19, 5:46*am, Ora_DBA <sanjaydharmadhik... (AT) gmail (DOT) com> wrote:
Quote:
Is Supplemental logging mandatory when using streams Replication ?

I am trying to replicate about 100 plus tables in a schema. All the
tables in the source database have a primary key. Do I need to create
supplmental logs ?

Thanks in Advance.
Hi,
Supplemental logging places additional column data into a redo log
whenever an operation is performed.
A capture process captures this additional information and places it
in LCRs. Supplemental logging is always configured at a source
database, regardless of location of the capture process that captures
changes to the source database.

Supplemental logging is required in Streams replication environments.

Regards
Sandy

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.