From oracle-l-bounce@freelists.org Fri Sep 23 17:04:32 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8NM4Wex024486 for ; Fri, 23 Sep 2005 17:04:32 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8NM4R6H024475 for ; Fri, 23 Sep 2005 17:04:27 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 624911EF36B; Fri, 23 Sep 2005 17:04:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27890-04; Fri, 23 Sep 2005 17:04:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D03991EF002; Fri, 23 Sep 2005 17:04:11 -0500 (EST) Subject: Re: Replication Advice Needed From: Carel-Jan Engel To: dubey.sandeep@gmail.com Cc: "Gogala, Mladen" , ranko.mosic@gmail.com, cmarquez@collegeboard.org, charlottejanehammond@yahoo.com, ORACLE-L In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-WiXKVc7ruxepcBFE69Yw" Organization: DBA!ert Date: Sat, 24 Sep 2005 00:02:00 +0200 Message-Id: <1127512920.16692.8.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 X-archive-position: 25848 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 --=-WiXKVc7ruxepcBFE69Yw Content-Type: text/plain Content-Transfer-Encoding: 7bit Sandeep, I stand corrected. Following the link Ranko Provided I discovered step '6. Set up supplemental logging at the source database.' That triggered me to write my reply, based on my limited knowledge. Based on Data Guard experience (Logical Standby) I was only familiar with Supplemental Logging as such, which I interpreted as what appears to be known as Database Supplemental Logging. Further reading learned there is also Table Supplemental Logging, and this is what Sanjay Mishra explains further in his article. So, streams is an even more serious candidate to solve Charlottes replication problem. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Fri, 2005-09-23 at 17:11 -0400, Sandeep Dubey wrote: > > Streams requires supplemental logging. This means that all transactions at > > your source database will write extra logging. > > It does not mean you have to do supplemental logging for all > transactions. Only updates on the tables which you want to capture > will be supplemental logged. > > >Supplemental logging? Do both databases need to be on the same > platform? This sounds almost like data guard. > > No. The destination database can be even non oracle. > > Regards > > Sandeep > -- > http://www.freelists.org/webpage/oracle-l --=-WiXKVc7ruxepcBFE69Yw Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Sandeep,

I stand corrected. Following the link Ranko Provided I discovered step '6. Set up supplemental logging at the source database.' That triggered me to write my reply, based on my limited knowledge. Based on Data Guard experience (Logical Standby) I was only familiar with Supplemental Logging as such, which I interpreted as what appears to be known as Database Supplemental Logging.

Further reading learned there is also Table Supplemental Logging, and this is what Sanjay Mishra explains further in his article.

So, streams is an even more serious candidate to solve Charlottes replication problem.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===

On Fri, 2005-09-23 at 17:11 -0400, Sandeep Dubey wrote:

> Streams requires supplemental logging. This means that all transactions at
> your source database will write extra logging.

It does not mean you have to do supplemental logging for all
transactions. Only updates on the tables which you want to capture
will be supplemental logged.

>Supplemental logging? Do both databases need to be on the same
platform? This sounds almost like data guard.

No. The destination database can be even non oracle.

Regards

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

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