Re: A question on supplemental logging on 10.2.0.3 RAC

Anurag,

I guess you are using asynchronous change data capture.

Don't do supplemental logging at database level.

Do it at the table level as follows:

alter table <table_name> add supplemental log data ( all ) columns;

Arul

On 7/27/07, Anurag Verma <anuragdba_at_gmail.com> wrote:
>
>
> There are many reasons, I feel.
>
> Basically, I am implementing ORacle change data capture (CDC ) in my 6
> node RAC database. And CDC will be applied on only around 50 tables out of
> 2000 user tables.
>
> What Oracle says in documentation that I have to enable Supplemental
> logging on database level.
>
> And when we enable supplemental logging level on database level, the
> archive log generation will go upto around 3-4 times in the database.
>
> So just for 50 tables, the logging is going to affect the whole database.
> Hence if there is any table level logging is there, it would really be
> great.
>
>
>
>
> On 7/26/07, Peter McLarty <p.mclarty_at_cqu.edu.au> wrote:
> >
> > I guess I should ask is there a reason you found to suggest you cant
> > do it;
> >
> > As this is part of core architecture for supporting some requirements
> > for Data Guard and streams , I dont see why it wouldnt be ok on any platform
> > and any realease from 9.2.xx onwards.
> >
> > Cheers
> > Peter
> >
> > ------------------------------
> > *From:* Anurag Verma [mailto:anuragdba_at_gmail.com]
> > *Sent:* Friday, 27 July 2007 10:05 AM
> > *To:* ORACLE-L
> > *Subject:* A question on supplemental logging on 10.2.0.3 RAC
> >
> >
> >
> > Hi All,
> >
> >
> > A question on supplemental logging.
> >
> > Can we enable the supplemental logging on table level ?
> >
> > My database is 10.2.0.3 RAC on Sun Solaris 9 (64 bit).
> >
> >
> > Thanks in advance,
> >
> > Anurag Verma,
> > Database Administrator
> > ERCOT(Electric Reliability Council of Texas),
> > Texas 76574
> >
>
>
>
> --
>
> Anurag Verma,
> Database Administrator
> ERCOT(Electric Reliability Council of Texas),
> Texas 76574
>

-- 
Arul

--
http://www.freelists.org/webpage/oracle-l