Re: A question on supplemental logging on 10.2.0.3 RAC

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@xxxxxxxxx> 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@xxxxxxxxxx>
> 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@xxxxxxxxx]
> > *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

Other related posts: