Re: A question on supplemental logging on 10.2.0.3 RAC

From: Asif Momen <asif_oracle_at_yahoo.com>
Date: Sat, 28 Jul 2007 00:06:47 -0700 (PDT)
Message-ID: <377597.13092.qm@web56612.mail.re3.yahoo.com>

Hi Anurag,

From Oracle Documentation (Oracle® Streams: Replication Administrator’s Guide):

"There are two types of supplemental logging: database supplemental logging and table supplemental logging. Database supplemental logging specifies supplemental logging for an entire database, while table supplemental logging enables you to specify log groups for supplemental logging of a particular table."

You may use the following statement to place a table in supplemental logging :

alter table your_table add supplemental log data ( all | primary key | unique | foreign key ) columns;

Regards

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
>

Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. http://autos.yahoo.com/carfinder/

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

Received on Sat Jul 28 2007 - 02:06:47 CDT