Re: A question on supplemental logging on 10.2.0.3 RAC

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

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