Re: Replication : ORA-04068: existing state of packages has been

[Tanel Poder]

Hi!

Just for the record, one other solution would probably have been to set
REMOTE_DEPENDENCIES_MODE = SIGNATURE.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, October 25, 2003 10:24 PM


> Thanks Jared.
>
> Recently we did run catrepr.sql and catrep.sql to recreate replication
catalog.
>
> I was getting the same error even after recompiled all the invalid
objects(few packages were invalid). Then restared my instance and now it is
woking fine.
>
> Thanks again
> -tamizh
>
> - Original Message -
> Date: Saturday, October 25, 2003 2:04 pm
>
> > Have you recently made any changes to your database?
> >
> > Upgrades, etc?
> >
> > This is the message you will receive when the state
> > of a package is invalid. It either needs recompiled,
> > as something it is dependent on has changed, and/or
> > it is broken for the same reason.
> >
> > One possible explanation for this is an incomplete
> > upgrade.
> >
> > You can recompile all stored code in the database
> > by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.
> >
> > There's another script for this as well, but I can't recall
> > it at the moment.  The above script is generally used as
> > a final step in an upgrade.
> >
> > Jared
> >
> > On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote:
> > > Hi List,
> > >
> > > Coudl someone please help me out to resolve this issue?
> > >
> > >  1  begin
> > >   2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
> > > end;
> > > /
> > >
> > >
> > > begin
> > > *
> > > ERROR at line 1:
> > > ORA-04068: existing state of packages has been discarded
> > > ORA-04062:  of  has been changed
> > > ORA-04062: timestamp of package "SYS.DBMS_REPCAT_RPC" has been
> > changed> ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 812
> > > ORA-06512: at "SYS.DBMS_REPCAT", line 532
> > > ORA-06512: at line 2
> > >
> > >
> > > -tamizh
> > >
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> > services> -
> > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jared Still
> >  INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > ---
> > --
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication : ORA-04068: existing state of packages has been

[Jared Still]

Thanks Pete, that was the one.

Jared

On Sat, 2003-10-25 at 15:09, Pete Finnigan wrote:
> >
> >There's another script for this as well, but I can't recall
> >it at the moment.  The above script is generally used as
> >a final step in an upgrade.
> >
> >Jared
> 
> Hi Jared,
> 
> Did you mean:
> 
> utlirp.sql - UTiLity script to Invalidate & Recompile Pl/sql modules 
> 
> Which does the extra invalidate first that utlrp.sql doesn't do.
> utlirp.sql uses utlip.sql first to invalidate all PL/SQL and then uses
> utlrp.sql to recompile all the invalid packages.
> 
> kind regards
> 
> Pete
> -- 
> Pete Finnigan
> email:[EMAIL PROTECTED]
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Pete Finnigan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication : ORA-04068: existing state of packages has been

[Pete Finnigan]

>
>There's another script for this as well, but I can't recall
>it at the moment.  The above script is generally used as
>a final step in an upgrade.
>
>Jared

Hi Jared,

Did you mean:

utlirp.sql - UTiLity script to Invalidate & Recompile Pl/sql modules 

Which does the extra invalidate first that utlrp.sql doesn't do.
utlirp.sql uses utlip.sql first to invalidate all PL/SQL and then uses
utlrp.sql to recompile all the invalid packages.

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication : ORA-04068: existing state of packages has been

[tamizh]

Thanks Jared.

Recently we did run catrepr.sql and catrep.sql to recreate replication catalog.

I was getting the same error even after recompiled all the invalid objects(few 
packages were invalid). Then restared my instance and now it is woking fine.

Thanks again
-tamizh

- Original Message -
Date: Saturday, October 25, 2003 2:04 pm

> Have you recently made any changes to your database?
> 
> Upgrades, etc?
> 
> This is the message you will receive when the state
> of a package is invalid. It either needs recompiled,
> as something it is dependent on has changed, and/or 
> it is broken for the same reason.
> 
> One possible explanation for this is an incomplete 
> upgrade.
> 
> You can recompile all stored code in the database
> by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.
> 
> There's another script for this as well, but I can't recall
> it at the moment.  The above script is generally used as
> a final step in an upgrade.
> 
> Jared
> 
> On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote:
> > Hi List,
> > 
> > Coudl someone please help me out to resolve this issue?
> > 
> >  1  begin
> >   2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE); 
> > end;
> > /
> > 
> > 
> > begin
> > *
> > ERROR at line 1:
> > ORA-04068: existing state of packages has been discarded
> > ORA-04062:  of  has been changed
> > ORA-04062: timestamp of package "SYS.DBMS_REPCAT_RPC" has been 
> changed> ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 812
> > ORA-06512: at "SYS.DBMS_REPCAT", line 532
> > ORA-06512: at line 2
> > 
> > 
> > -tamizh
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: 
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting 
> services> -
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jared Still
>  INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---
> --
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication : ORA-04068: existing state of packages has been

[Jared Still]

Have you recently made any changes to your database?

Upgrades, etc?

This is the message you will receive when the state
of a package is invalid. It either needs recompiled,
as something it is dependent on has changed, and/or 
it is broken for the same reason.

One possible explanation for this is an incomplete 
upgrade.

You can recompile all stored code in the database
by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.

There's another script for this as well, but I can't recall
it at the moment.  The above script is generally used as
a final step in an upgrade.

Jared

On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote:
> Hi List,
> 
> Coudl someone please help me out to resolve this issue?
> 
>  1  begin
>   2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE); 
> end;
> /
> 
> 
> begin
> *
> ERROR at line 1:
> ORA-04068: existing state of packages has been discarded
> ORA-04062:  of  has been changed
> ORA-04062: timestamp of package "SYS.DBMS_REPCAT_RPC" has been changed
> ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 812
> ORA-06512: at "SYS.DBMS_REPCAT", line 532
> ORA-06512: at line 2
> 
> 
> -tamizh
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[Robson, Peter]

I'm sorry - been very busy these last several days.

Yes, a somewhat flippant answer, but I built replication for our place
(asynchronous, master-master, multiple remote instances with full constraint
support) years ago, and its still running very reliably. Must be cheaper
than Oracle's product... !

If you really want more details, then contact me off-line.

peter
edinburgh

-Original Message-
Sent: Wednesday, October 22, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L


Peter,

your reply was empty, could pls. send it again, maybe
you have valuable information...

rgds
gb


Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Gunnar=20Berglund?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


*
This  e-mail  message,  and  any  files  transmitted  with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. .http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[Gunnar Berglund]

Peter,

your reply was empty, could pls. send it again, maybe
you have valuable information...

rgds
gb


Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Gunnar=20Berglund?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[Robson, Peter]

--_=_NextPart_001_01C39882.D1104260
Content-Type: text/plain; charset="iso-8859-1"

Use Oracla's advanced replication (only available with Enterprise Edition).
Or use the patented Robson method!!
 
peter
 

-Original Message-
Sent: Wednesday, October 22, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L


Hi all,
 
I have an environment where we are replication from Master to Slave a number
of tables.
 
But there is one table which needs to replicate also both ways.
 
Currently I have setup snapshots/mviews master-slave, how I can implement
this one table to be replicated also other way...
 
rgds
gb



  _  

Want to chat instantly with your online friends?
 Get the FREE Yahoo! Messenger



*
This  e-mail  message,  and  any  files  transmitted  with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. .http://www.bgs.ac.uk
*


--_=_NextPart_001_01C39882.D1104260
Content-Type: text/html; charset="iso-8859-1"








Use 
Oracla's advanced replication (only available with Enterprise Edition). Or use 
the patented Robson method!!
 
peter
 

  -Original Message-From: Gunnar Berglund 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 
  2003 11:45 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Replication 
  Hi all,
   
  I have an environment where we are replication from Master to Slave a 
  number of tables.
   
  But there is one table which needs to replicate also both ways.
   
  Currently I have setup snapshots/mviews master-slave, how I can implement 
  this one table to be replicated also other way...
   
  rgds
  gb
  
  
  Want to chat instantly with your online 
  friends? http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/";>Get
 
  the FREE Yahoo! Messenger

*
This  e-mail  message,  and  any  files  transmitted  with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. .http://www.bgs.ac.uk
*



--_=_NextPart_001_01C39882.D1104260--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication from DB2 to Oracle

[Govindan K]

Forgot to add one more aspect. You may consider "extproc"; A Java/C program interface
From DB2 equivalent of "extproc" of oracle. DB2 to pass values to the Java/C program 
which will in turn connect to Oracle and carry out DMLs.
 
HTH
GovindanK<-Original Message->



 
 
From: Govindan KSent: 9/25/2003 1:15:22 PMTo: [EMAIL PROTECTED];[EMAIL PROTECTED]Subject: Re: Replication from DB2 to Oracle 
 Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication 
across Databases of diff.vendors is still not avbl. though it seems you can do DMLs
from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G. 
Don't know about the reverse.
 
Or you may considering any of the following:
1. Dump the DB2 data onto flat file and load using sqlldr / External Tables.
2. Generate SQL insert statements using the equivalent of triggers (capturing
the DMLs in the same sequence) and run it in Oracle.
 
In either of the above cases , how are you going to handle DDLs if any that are
being done in DB2. The same need to be propogated to Oracle too and the 
subsequent data inserted correctly.
 
HTH
GovindanK
<-Original Message->



 
 
From: [EMAIL PROTECTED]Sent: 9/25/2003 12:05:43 PMTo: [EMAIL PROTECTED]Subject: Re: Replication from DB2 to Oracle Hi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

Re: Replication from DB2 to Oracle

[Tanel Poder]

Oracle heterogenous services + ODBC.
Included in EE, maybe in SE as well.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 10:09 PM


> Hi,
>
> Do any of you have any recommendation about any tools / software which
> replicate data between DB2 and Oracle ? Are there any good products out in
> the market ? I would really appreciate if you could suggest something.
>
> I am looking to replicate around couple of hundred thousand rows a day.
The
> replication can be every couple of hours. Our main concern is performance
on
> the transactional system ( source system running db2) should not have
> significant performance impact.
>
> Thanks.
>
> Thanks
>
> Rishi Jain
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication from DB2 to Oracle

[Govindan K]

 Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication
across Databases of diff.vendors is still not avbl. though it seems you can do DMLs
from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G. 
Don't know about the reverse.
 
Or you may considering any of the following:
1. Dump the DB2 data onto flat file and load using sqlldr / External Tables.
2. Generate SQL insert statements using the equivalent of triggers (capturing
the DMLs in the same sequence) and run it in Oracle.
 
In either of the above cases , how are you going to handle DDLs if any that are
being done in DB2. The same need to be propogated to Oracle too and the 
subsequent data inserted correctly.
 
HTH
GovindanK
<-Original Message->



 
 
From: [EMAIL PROTECTED]Sent: 9/25/2003 12:05:43 PMTo: [EMAIL PROTECTED]Subject: Re: Replication from DB2 to Oracle Hi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain 

___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

Re: Replication in NOARCHIVELOGMODE

[Tanel Poder]

Replication is completely different story and independent from archive mode,
thus everything will remain the same (well, unless you're doing replication
with Streams, but that's a different story)

Deftran is a view which is based on def$_aqcall and def$aq_error tables,
these tables are in system schema, but in which tablespace they are, depends
on your system users default_tablespace setting, in my test db it is tools
for example.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 19, 2003 12:29 AM


>
> Sorry if my question sounds too simple.
>
> what are the pros/cons of the above?
>
> Where will deftran be stored? System tbs?. Should i increase my
> system tbs size.
>
>
> Thanks
> Quriyat DBA
>
>
>
>
>
>
> ___
> No banners. No pop-ups. No kidding.
> Introducing My Way - http://www.myway.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: quriyat
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication in Oracle RDBMS

[Fermin Bernaus]

For replication docs, go to:


http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a87499/toc.htm

Fermin.

-Mensaje original-
De: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 10 de septiembre de 2003 13:09
Para: Multiple recipients of list ORACLE-L
Asunto: Replication in Oracle RDBMS


Dear Friends,

Can somebody send me / direct me to startup documents for ORacle
Replication.

TIA,
Rajuveera
** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Fermin Bernaus
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Arup Nanda]

Sami,

Setting up replication is pretty straight forward as long as you follow all
the steps dilligently. Unfortunately if a step is missed, it's hard to
diagnose the problem until one is at the terminal looking at the actual
database. In this case there are several steps that my not have been
correctly executed. Here are some:

(1) Have you built the replication support for the master group?

begin
dbms_repcat.generate_replication_support(
sname=>'HR',
oname=>'DEPATMENTS',
type=>'TABLE',
min_communication=>TRUE);
end;

(2) Have you started replication activity?

begin
dbms_repcat.resume_master_activity(
gname=>'HR_REPG');
end;

(3) Have you created the snaphsot group at the MV Site using
dbms_refresh.make?

You should do this steps before you create the MV RepGroup. You may find an
article I wrote for DBAZine (http://www.dbazine.com/nanda2.html), a related
but separate issue. And please let us know your progress.

HTH.

Arup


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 5:09 PM
mastered at ORC1.WORLD


> Dear Arup,
>
> Thanks for your response. But i have done the same
> which is mentioned in page # 3-6(Replication API
> Reference Manual). Please see below. What else could
> be wrong? TIA
>
> CONNECT repadmin/[EMAIL PROTECTED]
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPGROUP (
> gname => 'hr_repg');
> END;
> /
>
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
> gname => 'hr_repg',
> type => 'TABLE',
> oname => 'departments',
> sname => 'hr',
> use_existing_object => TRUE,
> copy_rows => FALSE);
> END;
> /
>
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > Before you create the Materialized View Group, you
> > must create the REPGROUP
> > at the Master site, which in you case is ORC1.world.
> >
> > In the database ORC1, use the
> > DBMS_REPCAT.CREATE_MASTER_REPGROUP and
> > DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling
> > the procedure
> > DBMS_REPCAT.CREATE_MVIEW_REPGROUP.
> >
> > HTH.
> >
> > Arup Nanda
> >
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Monday, September 01, 2003 4:24 PM
> > mastered at ORC1.WORLD
> >
> >
> > > Hi list
> > >
> > > I am using Oracle 9.2.0.1.0 enterprise on windows.
> > >
> > > I am going thru the examples provided in
> > "Replication
> > > Management API Reference-Part No. A96568-01".
> > >
> > > While creating MVIEW REPLICATION GROUP, getting
> > the
> > > following error (page # 5-7)
> > >
> > >
> > > SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
> > > Connected.
> > > SQL> BEGIN
> > >   2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
> > >   3  gname => 'hr_repg',
> > >   4  master => 'orc1.world',
> > >   5  propagation_mode => 'ASYNCHRONOUS');
> > >   6  END;
> > >   7  /
> > > BEGIN
> > > *
> > > ERROR at line 1:
> > > ORA-23313: object group "PUBLIC"."HR_REPG" is not
> > > mastered at ORC1.WORLD
> > > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> > > ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> > > ORA-06512: at line 2
> > >
> > >
> > > Any help would be really greatful.
> > >
> > > Thanks
> > > Sami
> > >
> > > __
> > > Do you Yahoo!?
> > > The New Yahoo! Search - Faster. Easier. Bingo.
> > > http://search.yahoo.com
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > -- 
> > > Author: Oracle DBA
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > > San Diego, California-- Mailing list and
> > web hosting services
> > >
> >
> -
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> > >
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Arup Nanda
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also 

Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Oracle DBA]

Dear Arup,

Thanks for your response. But i have done the same
which is mentioned in page # 3-6(Replication API
Reference Manual). Please see below. What else could
be wrong? TIA

CONNECT repadmin/[EMAIL PROTECTED]
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP (
gname => 'hr_repg');
END;
/

BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
gname => 'hr_repg',
type => 'TABLE',
oname => 'departments',
sname => 'hr',
use_existing_object => TRUE,
copy_rows => FALSE);
END;
/



--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> Before you create the Materialized View Group, you
> must create the REPGROUP
> at the Master site, which in you case is ORC1.world.
> 
> In the database ORC1, use the
> DBMS_REPCAT.CREATE_MASTER_REPGROUP and
> DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling
> the procedure
> DBMS_REPCAT.CREATE_MVIEW_REPGROUP.
> 
> HTH.
> 
> Arup Nanda
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Monday, September 01, 2003 4:24 PM
> mastered at ORC1.WORLD
> 
> 
> > Hi list
> >
> > I am using Oracle 9.2.0.1.0 enterprise on windows.
> >
> > I am going thru the examples provided in
> "Replication
> > Management API Reference-Part No. A96568-01".
> >
> > While creating MVIEW REPLICATION GROUP, getting
> the
> > following error (page # 5-7)
> >
> >
> > SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
> > Connected.
> > SQL> BEGIN
> >   2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
> >   3  gname => 'hr_repg',
> >   4  master => 'orc1.world',
> >   5  propagation_mode => 'ASYNCHRONOUS');
> >   6  END;
> >   7  /
> > BEGIN
> > *
> > ERROR at line 1:
> > ORA-23313: object group "PUBLIC"."HR_REPG" is not
> > mastered at ORC1.WORLD
> > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> > ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> > ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> > ORA-06512: at line 2
> >
> >
> > Any help would be really greatful.
> >
> > Thanks
> > Sami
> >
> > __
> > Do you Yahoo!?
> > The New Yahoo! Search - Faster. Easier. Bingo.
> > http://search.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > -- 
> > Author: Oracle DBA
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> >
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arup Nanda
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Arup Nanda]

Before you create the Materialized View Group, you must create the REPGROUP
at the Master site, which in you case is ORC1.world.

In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and
DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure
DBMS_REPCAT.CREATE_MVIEW_REPGROUP.

HTH.

Arup Nanda

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 4:24 PM
mastered at ORC1.WORLD


> Hi list
>
> I am using Oracle 9.2.0.1.0 enterprise on windows.
>
> I am going thru the examples provided in "Replication
> Management API Reference-Part No. A96568-01".
>
> While creating MVIEW REPLICATION GROUP, getting the
> following error (page # 5-7)
>
>
> SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
> Connected.
> SQL> BEGIN
>   2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
>   3  gname => 'hr_repg',
>   4  master => 'orc1.world',
>   5  propagation_mode => 'ASYNCHRONOUS');
>   6  END;
>   7  /
> BEGIN
> *
> ERROR at line 1:
> ORA-23313: object group "PUBLIC"."HR_REPG" is not
> mastered at ORC1.WORLD
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> ORA-06512: at line 2
>
>
> Any help would be really greatful.
>
> Thanks
> Sami
>
> __
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[Ramon E. Estevez]

Title: Message



Thks 
Arup, I'll let him know those points.
 
Tks
 
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Arup NandaSent: 
  Friday, February 21, 2003 10:30 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: Replication
  Is the MV set up for FAST REFRESH or 
  COMPLETE?
   
  If FAST REFRESH, check to see if the tablespace 
  of MV Log table, named MLOG$_ where  is the 
  first 20 characters of the table on which the log is based, has enough space 
  for the mlog$ to grow.
   
  If complete refresh, do it manually from command 
  line
   
  exec 
  DBMS_SNAPSHOT.REFRESH(','CF')
   
  and see what error message is given. A few things 
  come to my mind
   
  (1) not enough temp space for the sorting to 
  occur for he MV
  (2) not enough rollback segment 
  space.
   
  Either way, you will see the exact error it fails 
  on.
   
  HTH.
   
  Arup Nanda
  
- Original Message - 
From: 
Ramon E. Estevez 
To: Multiple recipients of list ORACLE-L 

Sent: Friday, February 21, 2003 8:19 
AM
Subject: Replication

I was asked of 
a problem in a friend's site about replication.
 
The 
problem.
 
They 
implemented replication using Materialized Views with an refresh update of 
ON DEMAND and some immediate.  It works for some days and suddenly some 
MV stop replicating.
 
He has checked 
metalink, but can't open a TAR.
 
Is there any 
recommendation that you can give him to check.
 
 
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
809-565-3121
 

Re: Replication

[Arup Nanda]

Title: Message



Is the MV set up for FAST REFRESH or 
COMPLETE?
 
If FAST REFRESH, check to see if the tablespace of 
MV Log table, named MLOG$_ where  is the first 
20 characters of the table on which the log is based, has enough space for the 
mlog$ to grow.
 
If complete refresh, do it manually from command 
line
 
exec 
DBMS_SNAPSHOT.REFRESH(','CF')
 
and see what error message is given. A few things 
come to my mind
 
(1) not enough temp space for the sorting to occur 
for he MV
(2) not enough rollback segment space.
 
Either way, you will see the exact error it fails 
on.
 
HTH.
 
Arup Nanda

  - Original Message - 
  From: 
  Ramon E. Estevez 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, February 21, 2003 8:19 
  AM
  Subject: Replication
  
  I was asked of a 
  problem in a friend's site about replication.
   
  The 
  problem.
   
  They implemented 
  replication using Materialized Views with an refresh update of ON DEMAND and 
  some immediate.  It works for some days and suddenly some MV stop 
  replicating.
   
  He has checked 
  metalink, but can't open a TAR.
   
  Is there any 
  recommendation that you can give him to check.
   
   
   
  Ramon E. 
  Estevez
  [EMAIL PROTECTED]
  809-565-3121
   

Re: Replication..

[Mogens Nørgaard]

Yep - advanced replication is updateable snapshots and master-to-master replication,
whereas basic replication is read-only snapshots (known these days as materialized
views). And here's the reply from Dominic Delmolino regarding versions:

  
Hey  Mogens!
 
 
 
I'll  be seeing you at the conference -- bring me an ice-cold bottle
of Denmark's  finest akvavit.


No, wait, that was the wrong one. Sorry. Here's the one I was thinking about...

  
Advanced replication was introduced in 7.1.6

Best regards,

Mogens

Richard Ji wrote:

  My understanding is that Basic replication is "readonly snapshot".
Anything above that, including updatable snapshot is advanced replication.

Richard

-Original Message-
Sent: Wednesday, January 29, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L


Paul - That is not my understanding. If you look in the Oracle guide that
shows the differences between Standard Edition and Enterprise Edition,
Standard has something named "Basic Replication", and Enterprise has
"Advanced Replication". Advanced means multimaster replication. Basic means
snapshots. In between there are several other replication alternatives, like
updatable snapshots, but I haven't seen a clear explanation of where basic
stops and advanced starts. If anyone knows, I would appreciate their posting
the facts.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, January 29, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


I believe that "Advanced Replication" was just a name change,
introduced in either Oracle8 or Oracle8i.

PB
--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
  
  
The person I know who can answer this is the guy who was Mr
Replication 
in Cary's SPG-group from the beginning, namely Dominic Delmolino. He
was 
truly a pioneer with that stuff. I'll ask him and get back.

Mogens

DENNIS WILLIAMS wrote:



  Chaim - I agree with your note, but isn't that basic replication?
  

Robert


  asked about advanced (multimaster) replication.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: Multiple recipients of list ORACLE-L



  

>from metalink note: 28018.1


  
5.14  Symmetric Replication

---

 The Oracle symmetric

replication facility is new with

release 7.1.6. The symmetric

replication facility allows

multiple copies of data to be

maintained at different sites in

a distributed environment. It

provides immediate, local access

to data and allows systems to

function autonomously even when

other systems in the distributed

environment are unavailable, or

networks fail. To use the

symmetric replication facility,

you must have purchased and

installed the replication

option. The symmetric

replication facility is

documented in the "Oracle7

Server Distributed Systems:

Replicated Data" manual.










Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003
  

02:29:24


  PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?

RF

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
  

services

-


  To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





 

  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication..

[Richard Ji]

My understanding is that Basic replication is "readonly snapshot".
Anything above that, including updatable snapshot is advanced replication.

Richard

-Original Message-
Sent: Wednesday, January 29, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L


Paul - That is not my understanding. If you look in the Oracle guide that
shows the differences between Standard Edition and Enterprise Edition,
Standard has something named "Basic Replication", and Enterprise has
"Advanced Replication". Advanced means multimaster replication. Basic means
snapshots. In between there are several other replication alternatives, like
updatable snapshots, but I haven't seen a clear explanation of where basic
stops and advanced starts. If anyone knows, I would appreciate their posting
the facts.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, January 29, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


I believe that "Advanced Replication" was just a name change,
introduced in either Oracle8 or Oracle8i.

PB
--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> The person I know who can answer this is the guy who was Mr
> Replication 
> in Cary's SPG-group from the beginning, namely Dominic Delmolino. He
> was 
> truly a pioneer with that stuff. I'll ask him and get back.
> 
> Mogens
> 
> DENNIS WILLIAMS wrote:
> 
> >Chaim - I agree with your note, but isn't that basic replication?
> Robert
> >asked about advanced (multimaster) replication.
> >
> >Dennis Williams
> >DBA, 40%OCP
> >Lifetouch, Inc.
> >[EMAIL PROTECTED] 
> >
> >
> >-Original Message-
> >[mailto:[EMAIL PROTECTED]]
> >Sent: Monday, January 27, 2003 2:12 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >from metalink note: 28018.1
> > 
> >
> > 5.14  Symmetric Replication
> >
> > ---
> >
> >  The Oracle symmetric
> >
> > replication facility is new with
> >
> > release 7.1.6. The symmetric
> >
> > replication facility allows
> >
> > multiple copies of data to be
> >
> > maintained at different sites in
> >
> > a distributed environment. It
> >
> > provides immediate, local access
> >
> > to data and allows systems to
> >
> > function autonomously even when
> >
> > other systems in the distributed
> >
> > environment are unavailable, or
> >
> > networks fail. To use the
> >
> > symmetric replication facility,
> >
> > you must have purchased and
> >
> > installed the replication
> >
> > option. The symmetric
> >
> > replication facility is
> >
> > documented in the "Oracle7
> >
> > Server Distributed Systems:
> >
> > Replicated Data" manual.
> >
> > 
> >
> >
> >
> >
> >
> >
> >
> >
> >Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003
> 02:29:24
> >PM
> >
> >Please respond to [EMAIL PROTECTED]
> >
> >Sent by:[EMAIL PROTECTED]
> >
> >
> >To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >cc:
> >
> >
> >
> >Any of you Oracle history buffs remember what version of Oracle that
> >advanced replication was first available in?
> >
> >RF
> >
> >Robert G. Freeman
> >Technical Management Consultant
> >TUSC - The Oracle Experts www.tusc.com
> >904.708.5076 Cell (it's everywhere that I am!)
> >Author of several books you can find on Amazon.com!
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: Freeman Robert - IL
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >San Diego, California-- Mailing list and web hosting
> services
>
>-
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> >
> >  
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Net

RE: Replication..

[DENNIS WILLIAMS]

Paul - That is not my understanding. If you look in the Oracle guide that
shows the differences between Standard Edition and Enterprise Edition,
Standard has something named "Basic Replication", and Enterprise has
"Advanced Replication". Advanced means multimaster replication. Basic means
snapshots. In between there are several other replication alternatives, like
updatable snapshots, but I haven't seen a clear explanation of where basic
stops and advanced starts. If anyone knows, I would appreciate their posting
the facts.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, January 29, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


I believe that "Advanced Replication" was just a name change,
introduced in either Oracle8 or Oracle8i.

PB
--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> The person I know who can answer this is the guy who was Mr
> Replication 
> in Cary's SPG-group from the beginning, namely Dominic Delmolino. He
> was 
> truly a pioneer with that stuff. I'll ask him and get back.
> 
> Mogens
> 
> DENNIS WILLIAMS wrote:
> 
> >Chaim - I agree with your note, but isn't that basic replication?
> Robert
> >asked about advanced (multimaster) replication.
> >
> >Dennis Williams
> >DBA, 40%OCP
> >Lifetouch, Inc.
> >[EMAIL PROTECTED] 
> >
> >
> >-Original Message-
> >[mailto:[EMAIL PROTECTED]]
> >Sent: Monday, January 27, 2003 2:12 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >from metalink note: 28018.1
> > 
> >
> > 5.14  Symmetric Replication
> >
> > ---
> >
> >  The Oracle symmetric
> >
> > replication facility is new with
> >
> > release 7.1.6. The symmetric
> >
> > replication facility allows
> >
> > multiple copies of data to be
> >
> > maintained at different sites in
> >
> > a distributed environment. It
> >
> > provides immediate, local access
> >
> > to data and allows systems to
> >
> > function autonomously even when
> >
> > other systems in the distributed
> >
> > environment are unavailable, or
> >
> > networks fail. To use the
> >
> > symmetric replication facility,
> >
> > you must have purchased and
> >
> > installed the replication
> >
> > option. The symmetric
> >
> > replication facility is
> >
> > documented in the "Oracle7
> >
> > Server Distributed Systems:
> >
> > Replicated Data" manual.
> >
> > 
> >
> >
> >
> >
> >
> >
> >
> >
> >Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003
> 02:29:24
> >PM
> >
> >Please respond to [EMAIL PROTECTED]
> >
> >Sent by:[EMAIL PROTECTED]
> >
> >
> >To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >cc:
> >
> >
> >
> >Any of you Oracle history buffs remember what version of Oracle that
> >advanced replication was first available in?
> >
> >RF
> >
> >Robert G. Freeman
> >Technical Management Consultant
> >TUSC - The Oracle Experts www.tusc.com
> >904.708.5076 Cell (it's everywhere that I am!)
> >Author of several books you can find on Amazon.com!
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: Freeman Robert - IL
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >San Diego, California-- Mailing list and web hosting
> services
>
>-
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> >
> >  
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to

Re: Replication..

[Paul Baumgartel]

I believe that "Advanced Replication" was just a name change,
introduced in either Oracle8 or Oracle8i.

PB
--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> The person I know who can answer this is the guy who was Mr
> Replication 
> in Cary's SPG-group from the beginning, namely Dominic Delmolino. He
> was 
> truly a pioneer with that stuff. I'll ask him and get back.
> 
> Mogens
> 
> DENNIS WILLIAMS wrote:
> 
> >Chaim - I agree with your note, but isn't that basic replication?
> Robert
> >asked about advanced (multimaster) replication.
> >
> >Dennis Williams
> >DBA, 40%OCP
> >Lifetouch, Inc.
> >[EMAIL PROTECTED] 
> >
> >
> >-Original Message-
> >[mailto:[EMAIL PROTECTED]]
> >Sent: Monday, January 27, 2003 2:12 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >from metalink note: 28018.1
> > 
> >
> > 5.14  Symmetric Replication
> >
> > ---
> >
> >  The Oracle symmetric
> >
> > replication facility is new with
> >
> > release 7.1.6. The symmetric
> >
> > replication facility allows
> >
> > multiple copies of data to be
> >
> > maintained at different sites in
> >
> > a distributed environment. It
> >
> > provides immediate, local access
> >
> > to data and allows systems to
> >
> > function autonomously even when
> >
> > other systems in the distributed
> >
> > environment are unavailable, or
> >
> > networks fail. To use the
> >
> > symmetric replication facility,
> >
> > you must have purchased and
> >
> > installed the replication
> >
> > option. The symmetric
> >
> > replication facility is
> >
> > documented in the "Oracle7
> >
> > Server Distributed Systems:
> >
> > Replicated Data" manual.
> >
> > 
> >
> >
> >
> >
> >
> >
> >
> >
> >Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003
> 02:29:24
> >PM
> >
> >Please respond to [EMAIL PROTECTED]
> >
> >Sent by:[EMAIL PROTECTED]
> >
> >
> >To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >cc:
> >
> >
> >
> >Any of you Oracle history buffs remember what version of Oracle that
> >advanced replication was first available in?
> >
> >RF
> >
> >Robert G. Freeman
> >Technical Management Consultant
> >TUSC - The Oracle Experts www.tusc.com
> >904.708.5076 Cell (it's everywhere that I am!)
> >Author of several books you can find on Amazon.com!
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: Freeman Robert - IL
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >San Diego, California-- Mailing list and web hosting
> services
>
>-
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> >
> >  
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication..

[Mogens Nørgaard]

The person I know who can answer this is the guy who was Mr Replication 
in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was 
truly a pioneer with that stuff. I'll ask him and get back.

Mogens

DENNIS WILLIAMS wrote:

Chaim - I agree with your note, but isn't that basic replication? Robert
asked about advanced (multimaster) replication.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: Multiple recipients of list ORACLE-L



from metalink note: 28018.1


5.14  Symmetric Replication

---

 The Oracle symmetric

replication facility is new with

release 7.1.6. The symmetric

replication facility allows

multiple copies of data to be

maintained at different sites in

a distributed environment. It

provides immediate, local access

to data and allows systems to

function autonomously even when

other systems in the distributed

environment are unavailable, or

networks fail. To use the

symmetric replication facility,

you must have purchased and

installed the replication

option. The symmetric

replication facility is

documented in the "Oracle7

Server Distributed Systems:

Replicated Data" manual.










Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003 02:29:24
PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?

RF

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication..

[DENNIS WILLIAMS]

Chaim - I agree with your note, but isn't that basic replication? Robert
asked about advanced (multimaster) replication.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: Multiple recipients of list ORACLE-L



from metalink note: 28018.1
 

 5.14  Symmetric Replication

 ---

  The Oracle symmetric

 replication facility is new with

 release 7.1.6. The symmetric

 replication facility allows

 multiple copies of data to be

 maintained at different sites in

 a distributed environment. It

 provides immediate, local access

 to data and allows systems to

 function autonomously even when

 other systems in the distributed

 environment are unavailable, or

 networks fail. To use the

 symmetric replication facility,

 you must have purchased and

 installed the replication

 option. The symmetric

 replication facility is

 documented in the "Oracle7

 Server Distributed Systems:

 Replicated Data" manual.

 








Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003 02:29:24
PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?

RF

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication..

[Freeman Robert - IL]

Thanks!

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: Multiple recipients of list ORACLE-L



from metalink note: 28018.1
 

 5.14  Symmetric Replication

 ---

  The Oracle symmetric

 replication facility is new with

 release 7.1.6. The symmetric

 replication facility allows

 multiple copies of data to be

 maintained at different sites in

 a distributed environment. It

 provides immediate, local access

 to data and allows systems to

 function autonomously even when

 other systems in the distributed

 environment are unavailable, or

 networks fail. To use the

 symmetric replication facility,

 you must have purchased and

 installed the replication

 option. The symmetric

 replication facility is

 documented in the "Oracle7

 Server Distributed Systems:

 Replicated Data" manual.

 








Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003 02:29:24
PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?

RF

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication..

[Chaim . Katz]

from metalink note: 28018.1
   
 
 5.14  Symmetric Replication   
 
 ---   
 
  The Oracle symmetric 
 
 replication facility is new with  
 
 release 7.1.6. The symmetric  
 
 replication facility allows   
 
 multiple copies of data to be 
 
 maintained at different sites in  
 
 a distributed environment. It 
 
 provides immediate, local access  
 
 to data and allows systems to 
 
 function autonomously even when   
 
 other systems in the distributed  
 
 environment are unavailable, or   
 
 networks fail. To use the 
 
 symmetric replication facility,   
 
 you must have purchased and   
 
 installed the replication 
 
 option. The symmetric 
 
 replication facility is   
 
 documented in the "Oracle7
 
 Server Distributed Systems:   
 
 Replicated Data" manual.  
 
   
 







Freeman Robert - IL <[EMAIL PROTECTED]>@fatcity.com on 01/27/2003 02:29:24
PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?

RF

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Nguyen, David M]

Title: RE: Replication question





We don't update data on slaves, we update data from master then slave pull data from the master every 5 minutes.


David


-Original Message-
From: BigP [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 22, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Replication question


it depends on how you are updating slave databases .
-bp


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 3:39 PM



> We have four machines setup as slave databases which get updated data from
> one Master database every 5 minutes.  The question is how do I know all
> slave machines get updated data completely from the master database,
another
> word is how do I know there is no missing data when slave machines
replicate
> from the master database?
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: BigP
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication question

[BigP]

it depends on how you are updating slave databases .
-bp

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 3:39 PM


> We have four machines setup as slave databases which get updated data from
> one Master database every 5 minutes.  The question is how do I know all
> slave machines get updated data completely from the master database,
another
> word is how do I know there is no missing data when slave machines
replicate
> from the master database?
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: BigP
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: [Replication] Altering Master Object at materialized view replication environment

[Arup Nanda]

Dennis,

I am glad that it worked for you. Of course, it's useful if the table size
is big. In case of a small table, you would just drop and recreate the
snapshot.

Thanks for pointing out the typo.

Regards,

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 9:44 AM
replication environment


> Hello!
>
> > That's one of the nuances of MV replication. If you alter the  master
> table,
> > you have to drop and recreate the MV on the snapshot site. This is as
> per Oracle's internal documentation.
>
> :-(
>
> > However, there is a trick. If you have created the MV using a prebuilt
> > table, then you can have a workaround.
>
> [ ... ]
>
> > Of course, there are several small but crucial steps to be followed. I
> have
> > described the procedure completely in
> http://www.dbazine.com/nanda2.html .
> > Hope this helps.
>
> Thank you, it works.
> But it's reasonable only if a table size is huge ... or channel capacity
> is small :-), so complete refresh becoms very expensive operation ...
>
> /sds
>
> PS: About "  http://www.dbazine.com/nanda2.html ", imho, something wrong
> in this sentence:
> "The table has two columns, COL1 NUMBER (9) and COL2 CHAR(1000), COL3
> CHAR(900)" ... 8-)
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Dennis Sorokin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: [Replication] Altering Master Object at materialized view replication environment

[Dennis Sorokin]

Hello! 

> That's one of the nuances of MV replication. If you alter the  master
table,
> you have to drop and recreate the MV on the snapshot site. This is as
per Oracle's internal documentation.

:-(

> However, there is a trick. If you have created the MV using a prebuilt
> table, then you can have a workaround. 

[ ... ]

> Of course, there are several small but crucial steps to be followed. I
have
> described the procedure completely in
http://www.dbazine.com/nanda2.html .
> Hope this helps.

Thank you, it works. 
But it's reasonable only if a table size is huge ... or channel capacity
is small :-), so complete refresh becoms very expensive operation ... 

/sds

PS: About "  http://www.dbazine.com/nanda2.html ", imho, something wrong
in this sentence:
"The table has two columns, COL1 NUMBER (9) and COL2 CHAR(1000), COL3
CHAR(900)" ... 8-)




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dennis Sorokin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: [Replication] Altering Master Object at materialized view replication environment

[Arup Nanda]

Dennis,

That's one of the nuances of MV replication. If you alter the master table,
you have to drop and recreate the MV on the snapshot site. This is as per
Oracle's internal documentation.

However, there is a trick. If you have created the MV using a prebuilt
table, then you can have a workaround. When you build an MV on a table,
Oracle simply assumes the type of the segment as MV rather than the table,
i.e. the segment that used to be known as the table is now known as the MV.
when the MV is dropped, Oracle does not drop the segment; rather it reverts
the type to the table as it used to be.

So when you alter the master table, follow the sequence of steps.

stop replication
drop the MV
alter the master table
alter the prebuilt table in the same way.
Build the MV on the prebuilt table again.

Of course, there are several small but crucial steps to be followed. I have
described the procedure completely in http://www.dbazine.com/nanda2.html .

Hope this helps.

Arup Nanda

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 3:53 AM
replication environment


> Hello
>
> How can i replicate DDL on table  (modify column for example)  in
> materialized view replication environment ?
> DBMS_REPCAT.ALTER_MASTER_REPOBJECT alter the object, put changes are not
> propagated to MV site ...
>
> I try DBMS_REFRESH.REFRESH and DBMS_REPCAT.REFRESH_MVIEW_REPGROUP at MV
> site, but I steel don't see the changes.
> Is it possible to propagate DDL to MV site ?
> Thnx.
>
> /sds
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Dennis Sorokin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication Manager

[Yechiel Adar]

Building replication is usually somewhat lengthy process.
I spent sometime with an Oracle expert and built a skeleton script
to build my replication via sqlplus.

However, I use the replication manager to track the progress of
the build process and to check the results.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 7:39 PM


> Has anyone used Replication Manager with success?  Any feedback on issues
you
> may have run into would be greatly appreciated.
>
> Does it come bundled with OEM or is it typically on a separate CD as a
> Management Pack?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mike Sardin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication Manager

[Arup Nanda]

Replication Manager is a part of DBA Studio on OEM with 8i; On OEM with 9i,
the DBA Studio is gone; so the replication manager is on OEM Console.
I use it, for a quick and dirty look at things. I don't use it to create
replication objects etc. However thjat's simply becuase I never used it
earlier and am comfortable using the sql plus.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 12:39 PM


> Has anyone used Replication Manager with success?  Any feedback on issues
you
> may have run into would be greatly appreciated.
>
> Does it come bundled with OEM or is it typically on a separate CD as a
> Management Pack?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mike Sardin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication - snaphot/asynchronous

[Michael Barger]

You can run asynchronos rep from server A to C, then
run a snapshot to B off of C (have C be the master to
B)

Make sure you have conflict resolution set-up!

--- Eric Richmond <[EMAIL PROTECTED]> wrote:
> I read that any given object can be in only one
> replication group.  We already
> have SNAPSHOT replication running from Server A to
> Server B.  Now we want to
> set up ASYNCHRONOUS replication to run from Server A
> to Server C.  How can
> that be set up so there isn't a conflict if the
> objects can only be in one
> replication group?
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Eric Richmon
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Barger
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[Jared . Still]

The directory structure was the problem I had in mind actually.

Moving to a different disk layout is easy with hot backup.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/15/2002 10:24 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:        Re: Replication



This is definitely possible with RMAN. The only hitch is that in case you
use RMAN to write to disk, the same directory structure must exist on the
target server. The workaround would be to create soft links. Also, in 
case,
you are moving the datafiles to a different destination, then one needs to
use the 'set newname' in RMAN. If you are looking for the fastest way to
replicate a db, and $$ aint a problem, I would recommend BCV splits.

If you only plan to use it as a reporting database only, and periodic
refreshes, why not use standby databases, instead of replication.

Raj






  
Jared.Still@r  
adisys.com   To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]> 
Sent by: cc:   
root@fatcity.    Subject: Re: Replication  
 
com  
  
  
October 14,  
2002 04:44 PM  
Please  
respond to  
ORACLE-L  
  
  




How about:

Copy your database to the new server.  This needs to be
done in real time.  I've done this a number of times by
putting the database in hot backup mode, copying the
datafiles to the new server.

Then when you're ready to switch, shutdown the old
database, copy all archive logs generated during the
backup to the new server.

Also, copy all unarchived redo logs to the new server
as well.  Open the new database, apply media recovery
using all the archive logs you copied, as well as the
unarchived redo logs.

Applying the redo logs from the old database allows
you to open the database without 'RESETLOGS'.

This may be possible with RMAN, but I suspect the
hot backup method is simpler.

Jared







"Robin Li" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/14/2002 12:53 PM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc:
Subject:Re: Replication


Thanks to all who replied.

The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over,
he is going to use the DB on the old server as reporting.

Robin

[EMAIL PROTECTED] wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose?  High Availability?  Querying and
reporting?
>
> Jared
>
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/14/2002 06:58 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Replication
>
> Hi all,
>
> Does anyone have the appropriate time on implementing replication for a
> newbe?
>
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
>
> TIA
>
> Robin


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note 

Re: Replication

[Rajesh . Rao]

This is definitely possible with RMAN. The only hitch is that in case you
use RMAN to write to disk, the same directory structure must exist on the
target server. The workaround would be to create soft links. Also, in case,
you are moving the datafiles to a different destination, then one needs to
use the 'set newname' in RMAN. If you are looking for the fastest way to
replicate a db, and $$ aint a problem, I would recommend BCV splits.

If you only plan to use it as a reporting database only, and periodic
refreshes, why not use standby databases, instead of replication.

Raj






   
 
Jared.Still@r  
 
adisys.com   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
root@fatcity.    Subject: Re: Replication  
 
com
 
   
 
   
 
October 14,
 
2002 04:44 PM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




How about:

Copy your database to the new server.  This needs to be
done in real time.  I've done this a number of times by
putting the database in hot backup mode, copying the
datafiles to the new server.

Then when you're ready to switch, shutdown the old
database, copy all archive logs generated during the
backup to the new server.

Also, copy all unarchived redo logs to the new server
as well.  Open the new database, apply media recovery
using all the archive logs you copied, as well as the
unarchived redo logs.

Applying the redo logs from the old database allows
you to open the database without 'RESETLOGS'.

This may be possible with RMAN, but I suspect the
hot backup method is simpler.

Jared







"Robin Li" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/14/2002 12:53 PM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Replication


Thanks to all who replied.

The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over,
he is going to use the DB on the old server as reporting.

Robin

[EMAIL PROTECTED] wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose?  High Availability?  Querying and
reporting?
>
> Jared
>
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/14/2002 06:58 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Replication
>
> Hi all,
>
> Does anyone have the appropriate time on implementing replication for a
> newbe?
>
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
>
> TIA
>
> Robin


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 

Re: Replication

[alan . aschenbrenner]

Robin,

If you can have an hour of downtime, you could probably just create a
clone of the original database and be done with it (but make sure you
change the DB Name and the DBID if you are using RMAN).  Of course,
depending on your disk and network speed, this could take more or less that
an hour.  Try a small transfer and then do the math to determine how long
it will take for you to copy/ftp all of the datafiles to another location.
Replication for the sake of setting up an extra database is one of the
most ridiculous things I've heard.  To begin with, if your schema isn't
setup the way replication wants (all tables having primary keys or indexes
for any alternate keys you specify during setup), replication can be very
slow.  I'm not certain if this effects the initial push of data from
database A to database B or not, but that could be extremely time consuming
if so.  Can anyone confirm this one way or the other?
On the other hand, if you're going to use the old database for
reporting and want it kept up to date, replication is probably a good idea.
But learning replication in 10 days is asking for trouble.  I agree with
everyone else, it takes months to fully understand all the concepts and
have a good grasp of what's going on inside the database, what can go
wrong, and how to resolve problems

Just my $.02

Alan




   

"Robin Li" 

<[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

        [EMAIL PROTECTED]   Subject: Re: Replication  

om 

   

   

10/14/02 01:53 

PM 

Please respond 

to ORACLE-L

   

   





Thanks to all who replied.

The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over,
he is going to use the DB on the old server as reporting.

Robin

[EMAIL PROTECTED] wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose?  High Availability?  Querying and reporting?
>
> Jared
>
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/14/2002 06:58 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Replication
>
> Hi all,
>
> Does anyone have the appropriate time on implementing replication for a
> newbe?
>
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
>
> TIA
>
> Robin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robin Li
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECT

Re: Replication

[Jared . Still]

How about:

Copy your database to the new server.  This needs to be
done in real time.  I've done this a number of times by
putting the database in hot backup mode, copying the 
datafiles to the new server.

Then when you're ready to switch, shutdown the old
database, copy all archive logs generated during the
backup to the new server. 

Also, copy all unarchived redo logs to the new server 
as well.  Open the new database, apply media recovery
using all the archive logs you copied, as well as the
unarchived redo logs. 

Applying the redo logs from the old database allows
you to open the database without 'RESETLOGS'.

This may be possible with RMAN, but I suspect the
hot backup method is simpler.

Jared







"Robin Li" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/14/2002 12:53 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Replication


Thanks to all who replied.

The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over, 
he is going to use the DB on the old server as reporting.

Robin

[EMAIL PROTECTED] wrote:
> 
> Is this simply replicating data to another system read only?
> 
> Replicated for what purpose?  High Availability?  Querying and 
reporting?
> 
> Jared
> 
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/14/2002 06:58 AM
>  Please respond to ORACLE-L
> 
> 
> To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
> cc:
> Subject:Replication
> 
> Hi all,
> 
> Does anyone have the appropriate time on implementing replication for a
> newbe?
> 
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
> 
> TIA
> 
> Robin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robin Li
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Robin


* Robin Li  *
* Technical Specialist, DBA   Phone#: (212) 297-3073   *
* Information ServicesFax#:   (212) 297-4231   *
* 333 East 38th Street, 2nd fl.   E-mail: [EMAIL PROTECTED]  *
* New York, NY 10016*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robin Li
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[Robin Li]

Thanks to all who replied.

The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over, 
he is going to use the DB on the old server as reporting.

Robin

[EMAIL PROTECTED] wrote:
> 
> Is this simply replicating data to another system read only?
> 
> Replicated for what purpose?  High Availability?  Querying and reporting?
> 
> Jared
> 
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/14/2002 06:58 AM
>  Please respond to ORACLE-L
> 
> 
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Replication
> 
> Hi all,
> 
> Does anyone have the appropriate time on implementing replication for a
> newbe?
> 
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
> 
> TIA
> 
> Robin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robin Li
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Robin


* Robin Li *
* Technical Specialist, DBA   Phone#: (212) 297-3073   *
* Information ServicesFax#:   (212) 297-4231   *
* 333 East 38th Street, 2nd fl.   E-mail: [EMAIL PROTECTED]  *
* New York, NY 10016   *

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robin Li
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[Jared . Still]

Is this simply replicating data to another system read only?

Replicated for what purpose?  High Availability?  Querying and reporting?

Jared






"Robin Li" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/14/2002 06:58 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Replication


Hi all,

Does anyone have the appropriate time on implementing replication for a
newbe? 

I am given a time frame on doing the replication for 10 days which is
including testing on test server and move to production. I've never done
that before, now just start reading. This DB is about 30G on Oracle
8.1.7.

TIA

Robin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robin Li
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[DENNIS WILLIAMS]

Peter - I entered PLOUG in Google, and it returned the Polish Oracle User's
Group. I doubt that I will be able to attend. Any chance you could post your
presentation afterward?

Dennis Williams
DBA - Still being threatened with replication
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, October 14, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L


Yeah - replication - a tasty subject.

I too have been working on it for years (about 15 - how long has Oracle had
a replication facility?!).

I've cut the implementation time down to about, h, a few minutes all
done using scripts which build scripts which call scripts which build
scripts etc. Not Oracle's solution, though, but it is master/master. Come to
PLOUG next week and hear about it...

peter


> -Original Message-
> From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
> Sent: 14 October 2002 15:59
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Replication
> 
> 
> I have recently heard some people say it had taken them 
> several months to master, and *now* it would take them about 
> 15 days to implement.
> 
> >- Original Message -
> >From: "Robin Li" <[EMAIL PROTECTED]>
> >To: Multiple recipients of list ORACLE-L
> ><[EMAIL PROTECTED]>
> >Sent: Mon, 14 Oct 2002 05:58:24
> >
> >Hi all,
> >
> >Does anyone have the appropriate time on
> >implementing replication for a
> >newbe? 
> >
> >I am given a time frame on doing the replication
> >for 10 days which is
> >including testing on test server and move to
> >production. I've never done
> >that before, now just start reading. This DB is
> >about 30G on Oracle
> >8.1.7.
> >
> >TIA
> >
> >Robin
> >-- 
> >Please see the official ORACLE-L FAQ:
> >http://www.orafaq.com
> >-- 
> >Author: Robin Li
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051
> >http://www.fatcity.com
> >San Diego, California  -- Mailing list and
> >web hosting services
> >To REMOVE yourself from this mailing list, send an
> >E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> >'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> >ORACLE-L
> >(or the name of mailing list you want to be removed
> >from).  You may
> >also send the HELP command for other information
> >(like subscribing).
> >---
> >--
> 
> 
> Regards,
> 
> Stephane Faroult
> Oriole
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Stephane Faroul
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


*
This  e-mail   message,  and  any  files  transmitted   with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not  necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS  accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. The BGS cannot accept any responsibility  for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the messa

Re: Replication

[Rachna Vaidya]

Replication implementation for a newbie in 10 days?
Having worked on replication for two and half hears,
I would say it should not be done.

Replication is way too complex. Read the Anita Badreen's white
paper and it would emphasize the importance of understanding
and planning repliction.

There are several good white papers / notes on replication too
on metalink.

>From my expereience, I would say, read Oracle Manual for Replication
2-3 times atleast. If you want to be good at it, come to
the stage where you can do it without GUI (so that you know
it pretty well.) They say that Replication Manager GUI is very
good. But I have never felt need to use it, except, some basic
monitoring...

Practice, practice, practice

Understand exactly needs of application very well and then decide
what kind of replication to use

HTH,

-Rachna


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 11:43 AM


>
>
> and, if possible, start with Anita Bardeen's white paper "Replication DOs
> and DON'Ts".  (You'll probably find it at OTN).  This is only a few pages,
> but it's full of invaluable tips.
>
> Barb
>
> > --
> > From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]]
> > Reply To: [EMAIL PROTECTED]
> > Sent: Monday, October 14, 2002 8:58 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Replication
> >
> > Robin
> >Your management sounds like some people I dealt with that assumed
they
> > would just "flip the replication switch". How much of the 30-gig. do
they
> > plan to replicate? What replication interval? What tools do they plan to
> > use? What is the replication direction - master-slave, peer-peer? How
many
> > sites? Ask for a copy of their replication policies. How will
replication
> > problems be detected? How will they be rectified?
> >For reading, I would recommend what are the only 2 books I could
locate
> > (does that give you a hint about the popularity of replication?)
> >   Data Replication, Marie Buretta (lots of information about why
policies
> > are vital and how to write them).
> >   Oracle Distributed Systems, Charles Dye.
> > The key to replication success (I can only speak from book knowledge) is
> > in
> > the people and the policies that coordinate their efforts and ensure
> > nothing
> > is overlooked, not in the technology.
> >
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > Sent: Monday, October 14, 2002 8:58 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi all,
> >
> > Does anyone have the appropriate time on implementing replication for a
> > newbe?
> >
> > I am given a time frame on doing the replication for 10 days which is
> > including testing on test server and move to production. I've never done
> > that before, now just start reading. This DB is about 30G on Oracle
> > 8.1.7.
> >
> > TIA
> >
> > Robin
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Robin Li
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FA

RE: Replication

[Baker, Barbara]

and, if possible, start with Anita Bardeen's white paper "Replication DOs
and DON'Ts".  (You'll probably find it at OTN).  This is only a few pages,
but it's full of invaluable tips.

Barb

> --
> From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Monday, October 14, 2002 8:58 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Replication
> 
> Robin
>Your management sounds like some people I dealt with that assumed they
> would just "flip the replication switch". How much of the 30-gig. do they
> plan to replicate? What replication interval? What tools do they plan to
> use? What is the replication direction - master-slave, peer-peer? How many
> sites? Ask for a copy of their replication policies. How will replication
> problems be detected? How will they be rectified?
>For reading, I would recommend what are the only 2 books I could locate
> (does that give you a hint about the popularity of replication?)
>   Data Replication, Marie Buretta (lots of information about why policies
> are vital and how to write them).
>   Oracle Distributed Systems, Charles Dye.
> The key to replication success (I can only speak from book knowledge) is
> in
> the people and the policies that coordinate their efforts and ensure
> nothing
> is overlooked, not in the technology.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Monday, October 14, 2002 8:58 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all,
> 
> Does anyone have the appropriate time on implementing replication for a
> newbe? 
> 
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
> 
> TIA
> 
> Robin
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Robin Li
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[Robson, Peter]

Yeah - replication - a tasty subject.

I too have been working on it for years (about 15 - how long has Oracle had
a replication facility?!).

I've cut the implementation time down to about, h, a few minutes all
done using scripts which build scripts which call scripts which build
scripts etc. Not Oracle's solution, though, but it is master/master. Come to
PLOUG next week and hear about it...

peter


> -Original Message-
> From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
> Sent: 14 October 2002 15:59
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Replication
> 
> 
> I have recently heard some people say it had taken them 
> several months to master, and *now* it would take them about 
> 15 days to implement.
> 
> >- Original Message -
> >From: "Robin Li" <[EMAIL PROTECTED]>
> >To: Multiple recipients of list ORACLE-L
> ><[EMAIL PROTECTED]>
> >Sent: Mon, 14 Oct 2002 05:58:24
> >
> >Hi all,
> >
> >Does anyone have the appropriate time on
> >implementing replication for a
> >newbe? 
> >
> >I am given a time frame on doing the replication
> >for 10 days which is
> >including testing on test server and move to
> >production. I've never done
> >that before, now just start reading. This DB is
> >about 30G on Oracle
> >8.1.7.
> >
> >TIA
> >
> >Robin
> >-- 
> >Please see the official ORACLE-L FAQ:
> >http://www.orafaq.com
> >-- 
> >Author: Robin Li
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051
> >http://www.fatcity.com
> >San Diego, California  -- Mailing list and
> >web hosting services
> >To REMOVE yourself from this mailing list, send an
> >E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> >'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> >ORACLE-L
> >(or the name of mailing list you want to be removed
> >from).  You may
> >also send the HELP command for other information
> >(like subscribing).
> >---
> >--
> 
> 
> Regards,
> 
> Stephane Faroult
> Oriole
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Stephane Faroul
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


*
This  e-mail   message,  and  any  files  transmitted   with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not  necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS  accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. The BGS cannot accept any responsibility  for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[Stephane Faroult]

I have recently heard some people say it had taken them several months to master, and 
*now* it would take them about 15 days to implement.

>- Original Message -
>From: "Robin Li" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 14 Oct 2002 05:58:24
>
>Hi all,
>
>Does anyone have the appropriate time on
>implementing replication for a
>newbe? 
>
>I am given a time frame on doing the replication
>for 10 days which is
>including testing on test server and move to
>production. I've never done
>that before, now just start reading. This DB is
>about 30G on Oracle
>8.1.7.
>
>TIA
>
>Robin
>-- 
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.com
>-- 
>Author: Robin Li
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051
>http://www.fatcity.com
>San Diego, California-- Mailing list and
>web hosting services
>To REMOVE yourself from this mailing list, send an
>E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of
>'ListGuru') and in
>the message BODY, include a line containing: UNSUB
>ORACLE-L
>(or the name of mailing list you want to be removed
>from).  You may
>also send the HELP command for other information
>(like subscribing).
>---
>--


Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication

[DENNIS WILLIAMS]

Robin
   Your management sounds like some people I dealt with that assumed they
would just "flip the replication switch". How much of the 30-gig. do they
plan to replicate? What replication interval? What tools do they plan to
use? What is the replication direction - master-slave, peer-peer? How many
sites? Ask for a copy of their replication policies. How will replication
problems be detected? How will they be rectified?
   For reading, I would recommend what are the only 2 books I could locate
(does that give you a hint about the popularity of replication?)
  Data Replication, Marie Buretta (lots of information about why policies
are vital and how to write them).
  Oracle Distributed Systems, Charles Dye.
The key to replication success (I can only speak from book knowledge) is in
the people and the policies that coordinate their efforts and ensure nothing
is overlooked, not in the technology.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, October 14, 2002 8:58 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Does anyone have the appropriate time on implementing replication for a
newbe? 

I am given a time frame on doing the replication for 10 days which is
including testing on test server and move to production. I've never done
that before, now just start reading. This DB is about 30G on Oracle
8.1.7.

TIA

Robin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robin Li
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[John Weatherman]

Paul,

Dispite being "internal" the triggers are triggers just like any
others.  INSERT, UPDATE, DELETE all fire the package (all the
transactions you want to move).  I have NEVER been clear on the
relationship between these triggers and user defined ones, sence
you suposedly can't control the order multiple "PRE-INSERT" triggers,
for instance, fire.  The internals are created by 
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT, which is why the catrepr.sql
doesn't know about them.

HtH,

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, September 05, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L


Thanks, John.  Do you know what mechanism causes the internal triggers
to fire?  Are the internal triggers created by catrep.sql, or by
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table?  


Does the RDBMS have to determine whether 
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> Paul,
> 
> The procedures are executed by a special "internal" trigger.  These
> triggers are also NOT dropped by catrepr.sql (yes, I found out the
> hard way!).  It is documented in metalink.
> 
> HtH,
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> 
> 
> -Original Message-
> Sent: Wednesday, September 04, 2002 9:04 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build
> the
> necessary underpinnings for multimaster replication of an object, it
> creates a package called $RP.  This package contains
> code
> to be run when rows are inserted, updated, or deleted.  There are,
> however, no trigges in the owning schema, nor in that of the
> replication administrator.  What, then, is the mechanism by which the
> procedures in this package are called?
> 
> TIA!
> 
> 
> 
> =
> Paul Baumgartel, Adept Computer Associates, Inc.
> [EMAIL PROTECTED]
> 
> 
> 
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Chaim . Katz]

I once noticed this code which is executed (for each column?) when you
create a table. Would it be related to replication?

BEGIN
   2.   /* NOP UNLESS A TABLE OBJECT */
   3.   IF dictionary_obj_type = 'TABLE' THEN
   4.
sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,'LOCK');
   5.   END IF;
   6.   END;






Paul Baumgartel <[EMAIL PROTECTED]>@fatcity.com on 09/05/2002 11:38:25
AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Thanks, John.  Do you know what mechanism causes the internal triggers
to fire?  Are the internal triggers created by catrep.sql, or by
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table?


Does the RDBMS have to determine whether
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> Paul,
>
> The procedures are executed by a special "internal" trigger.  These
> triggers are also NOT dropped by catrepr.sql (yes, I found out the
> hard way!).  It is documented in metalink.
>
> HtH,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
>
>
>
> -Original Message-
> Sent: Wednesday, September 04, 2002 9:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
> When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build
> the
> necessary underpinnings for multimaster replication of an object, it
> creates a package called $RP.  This package contains
> code
> to be run when rows are inserted, updated, or deleted.  There are,
> however, no trigges in the owning schema, nor in that of the
> replication administrator.  What, then, is the mechanism by which the
> procedures in this package are called?
>
> TIA!
>
>
>
> =
> Paul Baumgartel, Adept Computer Associates, Inc.
> [EMAIL PROTECTED]
>
>
>
>
>
> __
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[John Weatherman]

The jobs are used to propogate the captured transactions.
The transactions are captured by the packages called by the
internal triggers.

PAX,

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, September 05, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L


Paul - I don't know multimaster replication, so bear with me. I am thumbing
through my copy of Oracle Distributed Systems by Charles Dye. Does your
question relate to how propagation is controlled? I think propagation is
controlled by scheduled jobs. Take a look at the procedure
DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says "Schedules an automatic
push of the deftran queue to the specified master database". Hope this
helps, it may irritate someone that really knows the answer to your question
into replying.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, September 04, 2002 8:04 PM
To: Multiple recipients of list ORACLE-L


When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the
necessary underpinnings for multimaster replication of an object, it
creates a package called $RP.  This package contains code
to be run when rows are inserted, updated, or deleted.  There are,
however, no trigges in the owning schema, nor in that of the
replication administrator.  What, then, is the mechanism by which the
procedures in this package are called?

TIA!



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Paul Baumgartel]

Thanks, John.  Do you know what mechanism causes the internal triggers
to fire?  Are the internal triggers created by catrep.sql, or by
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table?  


Does the RDBMS have to determine whether 
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> Paul,
> 
> The procedures are executed by a special "internal" trigger.  These
> triggers are also NOT dropped by catrepr.sql (yes, I found out the
> hard way!).  It is documented in metalink.
> 
> HtH,
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> 
> 
> -Original Message-
> Sent: Wednesday, September 04, 2002 9:04 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build
> the
> necessary underpinnings for multimaster replication of an object, it
> creates a package called $RP.  This package contains
> code
> to be run when rows are inserted, updated, or deleted.  There are,
> however, no trigges in the owning schema, nor in that of the
> replication administrator.  What, then, is the mechanism by which the
> procedures in this package are called?
> 
> TIA!
> 
> 
> 
> =
> Paul Baumgartel, Adept Computer Associates, Inc.
> [EMAIL PROTECTED]
> 
> 
> 
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Godlewski, Melissa]

Title: RE: Replication question





Great book, I have it too!


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question



Paul - I don't know multimaster replication, so bear with me. I am thumbing
through my copy of Oracle Distributed Systems by Charles Dye. Does your
question relate to how propagation is controlled? I think propagation is
controlled by scheduled jobs. Take a look at the procedure
DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says "Schedules an automatic
push of the deftran queue to the specified master database". Hope this
helps, it may irritate someone that really knows the answer to your question
into replying.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, September 04, 2002 8:04 PM
To: Multiple recipients of list ORACLE-L



When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the
necessary underpinnings for multimaster replication of an object, it
creates a package called $RP.  This package contains code
to be run when rows are inserted, updated, or deleted.  There are,
however, no trigges in the owning schema, nor in that of the
replication administrator.  What, then, is the mechanism by which the
procedures in this package are called?


TIA!




=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]






__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[John Weatherman]

Paul,

The procedures are executed by a special "internal" trigger.  These
triggers are also NOT dropped by catrepr.sql (yes, I found out the
hard way!).  It is documented in metalink.

HtH,

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Wednesday, September 04, 2002 9:04 PM
To: Multiple recipients of list ORACLE-L


When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the
necessary underpinnings for multimaster replication of an object, it
creates a package called $RP.  This package contains code
to be run when rows are inserted, updated, or deleted.  There are,
however, no trigges in the owning schema, nor in that of the
replication administrator.  What, then, is the mechanism by which the
procedures in this package are called?

TIA!



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[DENNIS WILLIAMS]

Paul - I don't know multimaster replication, so bear with me. I am thumbing
through my copy of Oracle Distributed Systems by Charles Dye. Does your
question relate to how propagation is controlled? I think propagation is
controlled by scheduled jobs. Take a look at the procedure
DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says "Schedules an automatic
push of the deftran queue to the specified master database". Hope this
helps, it may irritate someone that really knows the answer to your question
into replying.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, September 04, 2002 8:04 PM
To: Multiple recipients of list ORACLE-L


When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the
necessary underpinnings for multimaster replication of an object, it
creates a package called $RP.  This package contains code
to be run when rows are inserted, updated, or deleted.  There are,
however, no trigges in the owning schema, nor in that of the
replication administrator.  What, then, is the mechanism by which the
procedures in this package are called?

TIA!



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[paquette stephane]

At a previous job, I've tested the first version of
Oracle Lite in 1996 if I remember correctly. The
concept of user did not exist, I do not know if it has
changed. In my case, several users will connect to the
same database. So I guess I'll need the Workgroup
version.

 --- Don Jerman <[EMAIL PROTECTED]> a écrit : >
Yes that's how it works, although the volume for 2-3
> months might be
> excessive, if the deltas get large.  Light uses
> Advanced Replication to
> manage the deltas so the resolution process might
> take a while.
> 
> paquette stephane wrote:
> 
> > Hi,
> >
> > Oracle Lite would not be good for us as when I
> said
> > users are working with a deployable version, I
> mean a
> > bunch of users go away with their server/database
> and
> > come back 2-3 months after, then they synchronized
> the
> > master database.
> >
> >  --- Don Jerman <[EMAIL PROTECTED]> a écrit
> : >
> > Oracle Lite is designed to do this -- the
> > > content-deployment part for
> > > standalone applications is a little buggy, but
> the
> > > data deployment and
> > > web-app deployment seems to work.  We're
> instituting
> > > a couple of
> > > applications with this now, and data sync seems
> to
> > > be working fine.
> > > Application sync has been getting most of the
> > > attention so far, though, as
> > > we try to get the programs deployed properly
> without
> > > by-hand intervention.
> > >
> > > paquette stephane wrote:
> > >
> > > > Hi,
> > > >
> > > > We will develop a new system that has a
> central
> > > > database (817/win2000).
> > > > >From times to times, some users will worked
> with
> > > a
> > > > deployable version of the application in a
> region
> > > > without network connection.
> > > > When the users are back, there should be able
> to
> > > > synchronize with the centralized database. The
> > > data
> > > > goes from the deployable version to the
> > > centralized
> > > > database only.
> > > >
> > > > What strategies can be considered ?
> > > >
> > > > =
> > > > Stéphane Paquette
> > > > DBA Oracle, consultant entrepôt de données
> > > > Oracle DBA, datawarehouse consultant
> > > > [EMAIL PROTECTED]
> > > >
> > > >
> > >
> >
>
___
> > > > Do You Yahoo!? -- Une adresse @yahoo.fr
> gratuite
> > > et en français !
> > > > Yahoo! Mail : http://fr.mail.yahoo.com
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > --
> > > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051
> > > FAX: (858) 538-5051
> > > > San Diego, California-- Public
> Internet
> > > access / Mailing Lists
> > > >
> > >
> >
>

> > > > To REMOVE yourself from this mailing list,
> send an
> > > E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling
> of
> > > 'ListGuru') and in
> > > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > > removed from).  You may
> > > > also send the HELP command for other
> information
> > > (like subscribing).
> > > > begin:vcard
> > > n:Jerman;Don
> > > tel;work:919.508.1886
> > > x-mozilla-html:TRUE
> > > org:Database Management Service,Information
> > > Technology
> > > version:2.1
> > > email;internet:[EMAIL PROTECTED]
> > > title:Database Administrator
> > > adr;quoted-printable:;;Database Management
> > > Service,Information Technology=0D=0A104
> Fayetteville
> > > Street Mall;Raleigh;NC;27699-1521;USA
> > > x-mozilla-cpt:;-9536
> > > fn:Don Jerman
> > > end:vcard
> > >
> >
> > =
> > Stéphane Paquette
> > DBA Oracle, consultant entrepôt de données
> > Oracle DBA, datawarehouse consultant
> > [EMAIL PROTECTED]
> >
> >
>
___
> > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> et en français !
> > Yahoo! Mail : http://fr.mail.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> > begin:vcard 
> n:Jerman;Don
> tel;work:919.508.1886
> x-mozilla-html:TRUE
> org:Database Management Service,Information
> Technology
> version:2.1
> email;internet:[EMAIL PROTECTED]
> title:Database Administrator
> adr

Re: Replication

[Don Jerman]

Light works with a 9ias application (part of the Light package) to establish
the mobile database and application on the mobile client.  Once the
application and database are downloaded, the database uses Advanced
Replication to sync with the master when the clients are brought back to the
network.  While mobile, Light emulates the oracle server (and potentially the
9ias server) for a single user.

You have a master database server connected to the mobile data server (9ias)
which handles the interface to the mobile clients (laptops, desktops,
what-have-you).  Up to 64 mobile clients per mobile server, if I remember the
marketing speil right, but we're still at the 4-client dev/test phase.

We have staff working on it, with assistance from an Oracle consultant brought
in for the purpose.  I just deal with the master database.

Since we're doing stand-alone, we have to hand-jar the java applications (the
jar wizard with Oracle Developer doesn't fit the bill somehow) so application
deployment is the sticking point at the moment.  We might get an answer this
month, but the dev manager is doing the schedule and application details.

My understanding is that if you deploy a JSP web app using 9ias, the app can
be downloaded and run on the mobile client against the Lite database, and that
sort of deployment appears to run smoothly (the examples work).  But we're not
doing that in this case so I have no real-world experience there.

"Ramon E. Estevez" wrote:

> Don,
>
> What are you using for deploy the applications ??
>
> I am interested in this topic too.
>
> Ramon
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, August 02, 2002 10:33 AM
>
> Oracle Lite is designed to do this -- the content-deployment part for
> standalone applications is a little buggy, but the data deployment and
> web-app deployment seems to work.  We're instituting a couple of
> applications with this now, and data sync seems to be working fine.
> Application sync has been getting most of the attention so far, though, as
> we try to get the programs deployed properly without by-hand intervention.
>
> paquette stephane wrote:
>
> > Hi,
> >
> > We will develop a new system that has a central
> > database (817/win2000).
> > >From times to times, some users will worked with a
> > deployable version of the application in a region
> > without network connection.
> > When the users are back, there should be able to
> > synchronize with the centralized database. The data
> > goes from the deployable version to the centralized
> > database only.
> >
> > What strategies can be considered ?
> >
> > =
> > Stéphane Paquette
> > DBA Oracle, consultant entrepôt de données
> > Oracle DBA, datawarehouse consultant
> > [EMAIL PROTECTED]
> >
> > ___
> > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> > Yahoo! Mail : http://fr.mail.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramon E. Estevez
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Replication

[Don Jerman]

Yes that's how it works, although the volume for 2-3 months might be
excessive, if the deltas get large.  Light uses Advanced Replication to
manage the deltas so the resolution process might take a while.

paquette stephane wrote:

> Hi,
>
> Oracle Lite would not be good for us as when I said
> users are working with a deployable version, I mean a
> bunch of users go away with their server/database and
> come back 2-3 months after, then they synchronized the
> master database.
>
>  --- Don Jerman <[EMAIL PROTECTED]> a écrit : >
> Oracle Lite is designed to do this -- the
> > content-deployment part for
> > standalone applications is a little buggy, but the
> > data deployment and
> > web-app deployment seems to work.  We're instituting
> > a couple of
> > applications with this now, and data sync seems to
> > be working fine.
> > Application sync has been getting most of the
> > attention so far, though, as
> > we try to get the programs deployed properly without
> > by-hand intervention.
> >
> > paquette stephane wrote:
> >
> > > Hi,
> > >
> > > We will develop a new system that has a central
> > > database (817/win2000).
> > > >From times to times, some users will worked with
> > a
> > > deployable version of the application in a region
> > > without network connection.
> > > When the users are back, there should be able to
> > > synchronize with the centralized database. The
> > data
> > > goes from the deployable version to the
> > centralized
> > > database only.
> > >
> > > What strategies can be considered ?
> > >
> > > =
> > > Stéphane Paquette
> > > DBA Oracle, consultant entrepôt de données
> > > Oracle DBA, datawarehouse consultant
> > > [EMAIL PROTECTED]
> > >
> > >
> >
> ___
> > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> > et en français !
> > > Yahoo! Mail : http://fr.mail.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> > > begin:vcard
> > n:Jerman;Don
> > tel;work:919.508.1886
> > x-mozilla-html:TRUE
> > org:Database Management Service,Information
> > Technology
> > version:2.1
> > email;internet:[EMAIL PROTECTED]
> > title:Database Administrator
> > adr;quoted-printable:;;Database Management
> > Service,Information Technology=0D=0A104 Fayetteville
> > Street Mall;Raleigh;NC;27699-1521;USA
> > x-mozilla-cpt:;-9536
> > fn:Don Jerman
> > end:vcard
> >
>
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> ___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Replication

[Ramon E. Estevez]

tks

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 11:39 AM


> The application will be developped in ASP, the
> deployed version would juste be a lighter version of
> the main application.
>
>
>
>  --- "Ramon E. Estevez" <[EMAIL PROTECTED]>
> a écrit : > Don,
> >
> > What are you using for deploy the applications ??
> >
> > I am interested in this topic too.
> >
> > Ramon
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Friday, August 02, 2002 10:33 AM
> >
> >
> > Oracle Lite is designed to do this -- the
> > content-deployment part for
> > standalone applications is a little buggy, but the
> > data deployment and
> > web-app deployment seems to work.  We're instituting
> > a couple of
> > applications with this now, and data sync seems to
> > be working fine.
> > Application sync has been getting most of the
> > attention so far, though, as
> > we try to get the programs deployed properly without
> > by-hand intervention.
> >
> > paquette stephane wrote:
> >
> > > Hi,
> > >
> > > We will develop a new system that has a central
> > > database (817/win2000).
> > > >From times to times, some users will worked with
> > a
> > > deployable version of the application in a region
> > > without network connection.
> > > When the users are back, there should be able to
> > > synchronize with the centralized database. The
> > data
> > > goes from the deployable version to the
> > centralized
> > > database only.
> > >
> > > What strategies can be considered ?
> > >
> > > =
> > > Stéphane Paquette
> > > DBA Oracle, consultant entrepôt de données
> > > Oracle DBA, datawarehouse consultant
> > > [EMAIL PROTECTED]
> > >
> > >
> >
> ___
> > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> > et en français !
> > > Yahoo! Mail : http://fr.mail.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ramon E. Estevez
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> >
> >
>
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> ___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

RE: Replication

[DENNIS WILLIAMS]

Stephane - Have you considered transportable tablespaces?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, August 02, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L


Hi,

Oracle Lite would not be good for us as when I said
users are working with a deployable version, I mean a
bunch of users go away with their server/database and
come back 2-3 months after, then they synchronized the
master database.




 --- Don Jerman <[EMAIL PROTECTED]> a écrit : >
Oracle Lite is designed to do this -- the
> content-deployment part for
> standalone applications is a little buggy, but the
> data deployment and
> web-app deployment seems to work.  We're instituting
> a couple of
> applications with this now, and data sync seems to
> be working fine.
> Application sync has been getting most of the
> attention so far, though, as
> we try to get the programs deployed properly without
> by-hand intervention.
> 
> paquette stephane wrote:
> 
> > Hi,
> >
> > We will develop a new system that has a central
> > database (817/win2000).
> > >From times to times, some users will worked with
> a
> > deployable version of the application in a region
> > without network connection.
> > When the users are back, there should be able to
> > synchronize with the centralized database. The
> data
> > goes from the deployable version to the
> centralized
> > database only.
> >
> > What strategies can be considered ?
> >
> > =
> > Stéphane Paquette
> > DBA Oracle, consultant entrepôt de données
> > Oracle DBA, datawarehouse consultant
> > [EMAIL PROTECTED]
> >
> >
>
___
> > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> et en français !
> > Yahoo! Mail : http://fr.mail.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> > begin:vcard 
> n:Jerman;Don
> tel;work:919.508.1886
> x-mozilla-html:TRUE
> org:Database Management Service,Information
> Technology
> version:2.1
> email;internet:[EMAIL PROTECTED]
> title:Database Administrator
> adr;quoted-printable:;;Database Management
> Service,Information Technology=0D=0A104 Fayetteville
> Street Mall;Raleigh;NC;27699-1521;USA
> x-mozilla-cpt:;-9536
> fn:Don Jerman
> end:vcard
>  

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[paquette stephane]

The application will be developped in ASP, the
deployed version would juste be a lighter version of
the main application.



 --- "Ramon E. Estevez" <[EMAIL PROTECTED]>
a écrit : > Don,
> 
> What are you using for deploy the applications ??
> 
> I am interested in this topic too.
> 
> Ramon
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Friday, August 02, 2002 10:33 AM
> 
> 
> Oracle Lite is designed to do this -- the
> content-deployment part for
> standalone applications is a little buggy, but the
> data deployment and
> web-app deployment seems to work.  We're instituting
> a couple of
> applications with this now, and data sync seems to
> be working fine.
> Application sync has been getting most of the
> attention so far, though, as
> we try to get the programs deployed properly without
> by-hand intervention.
> 
> paquette stephane wrote:
> 
> > Hi,
> >
> > We will develop a new system that has a central
> > database (817/win2000).
> > >From times to times, some users will worked with
> a
> > deployable version of the application in a region
> > without network connection.
> > When the users are back, there should be able to
> > synchronize with the centralized database. The
> data
> > goes from the deployable version to the
> centralized
> > database only.
> >
> > What strategies can be considered ?
> >
> > =
> > Stéphane Paquette
> > DBA Oracle, consultant entrepôt de données
> > Oracle DBA, datawarehouse consultant
> > [EMAIL PROTECTED]
> >
> >
>
___
> > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> et en français !
> > Yahoo! Mail : http://fr.mail.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ramon E. Estevez
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
>  

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[paquette stephane]

Hi,

Oracle Lite would not be good for us as when I said
users are working with a deployable version, I mean a
bunch of users go away with their server/database and
come back 2-3 months after, then they synchronized the
master database.




 --- Don Jerman <[EMAIL PROTECTED]> a écrit : >
Oracle Lite is designed to do this -- the
> content-deployment part for
> standalone applications is a little buggy, but the
> data deployment and
> web-app deployment seems to work.  We're instituting
> a couple of
> applications with this now, and data sync seems to
> be working fine.
> Application sync has been getting most of the
> attention so far, though, as
> we try to get the programs deployed properly without
> by-hand intervention.
> 
> paquette stephane wrote:
> 
> > Hi,
> >
> > We will develop a new system that has a central
> > database (817/win2000).
> > >From times to times, some users will worked with
> a
> > deployable version of the application in a region
> > without network connection.
> > When the users are back, there should be able to
> > synchronize with the centralized database. The
> data
> > goes from the deployable version to the
> centralized
> > database only.
> >
> > What strategies can be considered ?
> >
> > =
> > Stéphane Paquette
> > DBA Oracle, consultant entrepôt de données
> > Oracle DBA, datawarehouse consultant
> > [EMAIL PROTECTED]
> >
> >
>
___
> > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> et en français !
> > Yahoo! Mail : http://fr.mail.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> > begin:vcard 
> n:Jerman;Don
> tel;work:919.508.1886
> x-mozilla-html:TRUE
> org:Database Management Service,Information
> Technology
> version:2.1
> email;internet:[EMAIL PROTECTED]
> title:Database Administrator
> adr;quoted-printable:;;Database Management
> Service,Information Technology=0D=0A104 Fayetteville
> Street Mall;Raleigh;NC;27699-1521;USA
> x-mozilla-cpt:;-9536
> fn:Don Jerman
> end:vcard
>  

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[Ramon E. Estevez]

Don,

What are you using for deploy the applications ??

I am interested in this topic too.

Ramon

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 10:33 AM


Oracle Lite is designed to do this -- the content-deployment part for
standalone applications is a little buggy, but the data deployment and
web-app deployment seems to work.  We're instituting a couple of
applications with this now, and data sync seems to be working fine.
Application sync has been getting most of the attention so far, though, as
we try to get the programs deployed properly without by-hand intervention.

paquette stephane wrote:

> Hi,
>
> We will develop a new system that has a central
> database (817/win2000).
> >From times to times, some users will worked with a
> deployable version of the application in a region
> without network connection.
> When the users are back, there should be able to
> synchronize with the centralized database. The data
> goes from the deployable version to the centralized
> database only.
>
> What strategies can be considered ?
>
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> ___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[Don Jerman]

Oracle Lite is designed to do this -- the content-deployment part for
standalone applications is a little buggy, but the data deployment and
web-app deployment seems to work.  We're instituting a couple of
applications with this now, and data sync seems to be working fine.
Application sync has been getting most of the attention so far, though, as
we try to get the programs deployed properly without by-hand intervention.

paquette stephane wrote:

> Hi,
>
> We will develop a new system that has a central
> database (817/win2000).
> >From times to times, some users will worked with a
> deployable version of the application in a region
> without network connection.
> When the users are back, there should be able to
> synchronize with the centralized database. The data
> goes from the deployable version to the centralized
> database only.
>
> What strategies can be considered ?
>
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> ___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Replication

[Connor McDonald]

Oracle has "basic" replication and "advanced"
replication.  The basic allows read-only copies of
data whilst advanced can give multiple updaters at
different locations and can get as complicated as you
like.

IMHO, the key to a good replication environment is in
the planning.  Determining up front whether conflicts
will occur (when the data is resync'd back in to the
central store) and possibly architecting parts of the
database to avoid some/all conflicts is key.

If you're new to replication, using the gui
replication manager is a good way to get up and
running relatively quickly, but I'd advise having a
good study of the replication manuals to see all the
possibile issues that need to be considered.

Oracle were touting an architecture called
"Oracle-to-go" or "Web-to-go" some time ago which
(claimed) to simplify all of this - but I've heard
nothing recently.

hth
connor

 --- paquette stephane <[EMAIL PROTECTED]>
wrote: > Hi,
> 
> I've never had experiences in replication
> environments.
> 
> We will develop a new system that has a central
> database (817/win2000).  
> From times to times, some users will worked with a
> deployable version of the application in a region
> without network connection.
> When the users are back, they're should be able to
> synchronize with the centralized database. The data
> goes from the deployable version to the centralized
> database only.
> 
> What strategies can be considered ?
> 
> 
> 
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
> 
>
___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et
> en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication

[Yechiel Adar]

Use the KISS principle.
Define asynchronous replications on their machines and when they come back
and connect to the network the updates  will be applied.

TEST TEST TEST

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 2:33 AM


> Hi,
>
> I've never had experiences in replication
> environments.
>
> We will develop a new system that has a central
> database (817/win2000).
> From times to times, some users will worked with a
> deployable version of the application in a region
> without network connection.
> When the users are back, they're should be able to
> synchronize with the centralized database. The data
> goes from the deployable version to the centralized
> database only.
>
> What strategies can be considered ?
>
>
>
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> ___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication Question

[DENNIS WILLIAMS]

John - I've noticed that Google queries pull up info from the archives.
Obviously you'll get other stuff, but if you can make your query pretty
specific it may get you what you need.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, July 30, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


So how do I get into the archives?  I've got a question I know I've seen
answered.

Thanks,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication Question

[John Weatherman]

So how do I get into the archives?  I've got a question I know I've seen
answered.

Thanks,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication - truncate not propagating

[Joe Raube]

Take a look in the docs at the syntax:

truncate table  preserve/purge snapshot log;

"The SNAPSHOT LOG clause lets you specify whether a snapshot log
defined on the table is to be preserved or purged when the table is
truncated. This clause allows snapshot master tables to be
reorganized through export/import without affecting the ability of
primary-key snapshots defined on the master to be fast refreshed. To
support continued fast refresh of primary-key snapshots, the snapshot
log must record primary-key information. 

PRESERVE 
 Specify PRESERVE if any snapshot log should be preserved when the
master table is truncated. This is the default.  <<< this is why
you are not seeing the truncate being replicated
 
PURGE 
 Specify PURGE if any snapshot log should be purged when the master
table is truncated"

-Joe

--- Vladimir Barac <[EMAIL PROTECTED]> wrote:
> Hi!
> 
> I have noticed something...
> 
> Deletes are propagating from master site to the snapshots.
> Everything works like charm, as it is supposed.
> 
> But... truncate of master table IS NOT seen in snapshot table. I
> don't really expect snapshot to be truncated, of course, but I
> expect it to be empty (trunace is essentially delete).
> 
> So, is this bug or feature? What is logic behind it, if it is
> feature?
> 
> 
> 


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication - truncate not propagating

[Alessandro Guimaraes]

Vladimir,
 
When a table is truncated, its 
snapshot log is also truncated. 
If the PURGE SNAPSHOT LOG option is specified, 
the snapshot log is purged along with the master table. If you specify the PRESERVE SNAPSHOT LOG option or no option, 
the information in the master table's snapshot log is preserved, but current 
ROWID snapshots can use the log for a fast refresh only after a complete refresh 
has been performed. This is the default. 
 
Alessandro Guimarães

  - Original Message - 
  From: 
  Vladimir Barac 
  
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, July 29, 2002 5:23 AM
  Subject: Replication - truncate not 
  propagating
  
  Hi!
   
  I have noticed 
  something...
   
  Deletes are propagating from master 
  site to the snapshots. Everything works like charm, as it is 
  supposed.
   
  But... truncate of master table IS NOT 
  seen in snapshot table. I don't really expect snapshot to be truncated, of 
  course, but I expect it to be empty (trunace is essentially 
  delete).
   
  So, is this bug or feature? What is 
  logic behind it, if it is feature?
   
   

RE: Replication question

[Robson, Peter]

On performance of triggers blocking update of primary keys.

There are two aspects to performance. First, that which impacts on cpu
cycles etc, and secondly, that which impacts on the integrity of the
fundamental database design. I regard the latter as crucial - and
non-negotiable. The former is a function of secondary issues such as machine
power, load, use profile etc etc.

You can see what I am going to say - if Oracle won't protect your PKs from
modification, then you must do it yourself, and take any load into account
when specifying your hardware platform. I do know of relational databases
which will absolutely preclude modification of PKs. It ought to be a given
with an RDBMS.

As for our situation - no, these triggers don't impact us noticeably, but
then we don't run a high tp environment. But I tell you what - they give me
enormouse peace of mind!

peter
edinburgh

> -Original Message-
> From: Lowes, Harry (NESL-IT) [mailto:[EMAIL PROTECTED]]
> Sent: 21 June 2002 13:37
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Replication question
> 
> 
> Peter,
> 
> Great idea, but would you care to share the impact of these 
> triggers on
> performance? I think it's a good principle to follow, but 
> have always found
> triggers a little unwieldy for most operations myself. I 
> would have thought
> this to be the case here, but I'd like to hear your experiences on the
> subject.
> 
> 
> Thanks awfully,
> 
> Harry Lowes
> "My enthusiasm for both the job in hand and the welfare of my 
> fellow man
> knows no bounds."
> Database Administrator and bon vivante,
> npower Northern Limited
> 
> 
> 
> -Original Message-
> Sent: 21 June 2002 11:49
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Interesting comments on replication - but something hit me 
> between the eyes.
> 
> Primary Keys should NEVER, EVER be permitted to be updated, 
> whether you are
> using replication or not. Its a basic tenent of relational 
> design. We have
> been using triggers to prevent this for years.
> 
> peter
> edinburgh
> 
> 
> 
> *
> This  e-mail   message,  and  any  files  transmitted   with  it, are
> confidential  and intended  solely for the  use of the  addressee. If
> this message was not addressed to  you, you have received it in error
> and any  copying,  distribution  or  other use  of any part  of it is
> strictly prohibited. Any views or opinions presented are solely those
> of the sender and do not  necessarily represent  those of the British
> Geological  Survey. The  security of e-mail  communication  cannot be
> guaranteed and the BGS  accepts no liability  for claims arising as a
> result of the use of this medium to  transmit messages from or to the
> BGS. The BGS cannot accept any responsibility  for viruses, so please
> scan all attachments.http://www.bgs.ac.uk
> *
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Robson, Peter
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Lowes, Harry (NESL-IT)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

Re: REPLICATION QUESTION - LOng and strange

[Stephane Faroult]

"Sakthi , Raj" wrote:
> 
> Hi Listers,
> alright I've exhausted almost all my resources and I
> am turning to my last resource.
> We have 3 databases.
> Database A  - OLTP
> Database  B - OLTP
> Database  c - DSS
> 
> ORACLE 8.1.6.3 ON HP-UX 11.0
> 
> Database A has a table which is  being replicated to C
> as a read only snapshot and we have long and complex
> summary process (relic of 1998?s) that works off this
> snapshot. Now due to some new merger same table need
> to be created in database B. And yes?the data in table
> B also need to be replicated to the SAME snapshot in
> database C so that the summary process can summarize
> the collective data. The problem is I am sure this
> could be accomplished. THAT IS TWO MASTERS SITES
> FEEDING SAME SNAPSHOT?.!!!
> I have checked the replication manual and Unless I am
> so sleep deprived that I am missing lines I didn?t
> find any reference to this kinda replication setup.
> 
> Any pointers welcome. I am exhausted, so if you don?t
> mind, if RTFMs could refer the relevant section I am
> supposed to RTFM, then it would be great. Rewriting
> the summary process is not an option due to
> unrealistic deadline.
> TIA.
> 
> RS
>

Wouldn't it be possible to replace your current snapshot by a view, the
union of one snapshot on A and one snapshot on B? C could the summarize
both.
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Lowes, Harry (NESL-IT)]

Peter,

Great idea, but would you care to share the impact of these triggers on
performance? I think it's a good principle to follow, but have always found
triggers a little unwieldy for most operations myself. I would have thought
this to be the case here, but I'd like to hear your experiences on the
subject.


Thanks awfully,

Harry Lowes
"My enthusiasm for both the job in hand and the welfare of my fellow man
knows no bounds."
Database Administrator and bon vivante,
npower Northern Limited



-Original Message-
Sent: 21 June 2002 11:49
To: Multiple recipients of list ORACLE-L



Interesting comments on replication - but something hit me between the eyes.

Primary Keys should NEVER, EVER be permitted to be updated, whether you are
using replication or not. Its a basic tenent of relational design. We have
been using triggers to prevent this for years.

peter
edinburgh



*
This  e-mail   message,  and  any  files  transmitted   with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not  necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS  accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. The BGS cannot accept any responsibility  for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lowes, Harry (NESL-IT)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Robson, Peter]

Interesting comments on replication - but something hit me between the eyes.

Primary Keys should NEVER, EVER be permitted to be updated, whether you are
using replication or not. Its a basic tenent of relational design. We have
been using triggers to prevent this for years.

peter
edinburgh



*
This  e-mail   message,  and  any  files  transmitted   with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not  necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS  accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. The BGS cannot accept any responsibility  for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication question

[Bill Pass]

There is also a note (1037317.6) that documents moving
the replication base tables to another tablespace
(which Oracle Recommends).

Funny how alot of the Oracle Recommendations are in
notes instead of the documentation. 

--- Suzy Vordos <[EMAIL PROTECTED]> wrote:
> 
> Hadn't heard that one.  Objects for replication
> metadata are created in
> whatever the default tablespace is for SYSTEM.  The
> database create
> script crdb2.sql changes SYSTEM's default tablespace
> to TOOLS, so
> subsequently that's where the objects are created
> when catrep.sql is
> run.  In my case, that is TOOLS and haven't run into
> any problems. 
> 
> [EMAIL PROTECTED] wrote:
> > 
> > Brian,
> > 
> > That is what I wanted to do, but I
> understood that it would not be *supported* if we
> ran into issues.
> > 
> > Thanks,
> > 
> > Hannah
> > 
> > >  -Original Message-
> > > From: [EMAIL PROTECTED]@SUNGARD   On
> Behalf Of Brian McGraw
> <[EMAIL PROTECTED]>
> > > Sent: Thursday, June 20, 2002 11:49 AM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  RE: Replication question
> > >
> > > Just a note, Johanna.  We put all of our Oracle
> Replication metadata
> > > into separate tablespaces, and had absolutely no
> problems.
> > >
> > > Brian
> > >
> > > --
> > > | Brian McGraw /* DBA */  Infinity Insurance |
> > > | mailto:[EMAIL PROTECTED] |
> > > --
> > >
> > >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Suzy Vordos
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication question

[Suzy Vordos]

Hadn't heard that one.  Objects for replication metadata are created in
whatever the default tablespace is for SYSTEM.  The database create
script crdb2.sql changes SYSTEM's default tablespace to TOOLS, so
subsequently that's where the objects are created when catrep.sql is
run.  In my case, that is TOOLS and haven't run into any problems. 

[EMAIL PROTECTED] wrote:
> 
> Brian,
> 
> That is what I wanted to do, but I understood that it would not be 
>*supported* if we ran into issues.
> 
> Thanks,
> 
> Hannah
> 
> >  -Original Message-
> > From: [EMAIL PROTECTED]@SUNGARD   On Behalf Of Brian McGraw 
><[EMAIL PROTECTED]>
> > Sent: Thursday, June 20, 2002 11:49 AM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  RE: Replication question
> >
> > Just a note, Johanna.  We put all of our Oracle Replication metadata
> > into separate tablespaces, and had absolutely no problems.
> >
> > Brian
> >
> > --
> > | Brian McGraw /* DBA */  Infinity Insurance |
> > | mailto:[EMAIL PROTECTED] |
> > --
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[DENNIS WILLIAMS]

Bill - Thank you very much. This is the type of information I was hoping to
receive. I'm one of those DBAs who prefer to see the potholes before I fall
in them.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, June 20, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


Conflict resolution also has to be considered for log
based replication as well. Same problems exist. If you
think about it Oracles AQ approach is pretty much a
log.

Multi-master replication is still trigger/AQ based in
9i. It's working well for us.

Some of the things you can do to reduce (but not
elleminate) conflict resolution issues are:
1). Stagger sequence generated primary keys by site
2). Put triggers in place to prevent updating of
primary keys (avoids some uniqueness conflicts)
3). Add a last_updated_dt to each table and use that
as your primary method of update conflict resolution
4). Add a "primary" site capability for tie breakers.
Oracle has a built in method, but it requires you add
a site column to each table. If it is not data
dependent, I prefer a custom stored procedure method
where you choose a "primary" site that is not data
dependent.

Deletes are still our biggest problem. Don't really
understand why they can't be applied in the same order
at the remote site (perhaps because we am using
parallel propagation?). But for some reason if we do
massive deletes across multiple related tables in the
same TX, we always end up having to manually
reconcile.

An approach recommended by oracle for this is to add a
deleted_dt column to every table and do deferred batch
deletions. We tried this in conjunction with views and
instead of triggers to hide it from the application. A
couple of problems with this approach is that if you
delete, then try to re-insert with the same alternate
key before the deferred purge process runs, you will
get ORA-1 errors. If you run the deferred deletion
process too often you defeat the purpose of it and
overload the system.


--- [EMAIL PROTECTED] wrote:
> Dennis,
> 
>   All dbs whether SQL Server or Oracle need to deal
> with conflict resolution, thats not strictly an
> Oracle limitation.  As far a Quest goes, they handle
> replication completely different from Oracle. 
> Oracle itself is still using triggers (in 8i at
> least) , ubt now they hide the trigger, Shareplex
> reads the Oracle redo logs.  I believe that 9i uses
> the redo logs and is based (structured) after
> Shareplex itself - there were lots of articles on
> this with the pre-release of Dataguard. Furthermore,
> Oracle places all of its replication metadata in
> SYSTEM tablespace which I dont like, Sharpelex uses
> its own (which the user configures).  As far as
> Shareplex manuals, Quest is the one company that I
> will stand up and say that regardless of anything
> else, their documention is EXCELLENT.  Their
> documentation takes you from Shareplex architecture
> right to directory structure, actual files, usage
> and even scripting.  The sales rep was incorrect. 
> However, I can see them not releasing the manuals
> without a purchase.
> 
>   I believe that they are available on-line for
> download, though I do not know if it is just for
> current customers only.  
> (hehe can't believe I am defending a vendor:>).  But
> when someone does something right, I like to give
> credit.  Also, once you are setup, they are VERY
> stable.  I have my issues with them, but overall I
> feel they do great job at what they do.
> 
> 
> Hannah - Hope it helps any.
> 
> 
> >  -Original Message-
> > From:   [EMAIL PROTECTED]@SUNGARD   On Behalf Of
> DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > Sent:   Thursday, June 20, 2002 10:33 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Replication question
> > 
> > Yechel - Wow, what a blow to be struck with the
> dreaded RTFM first thing in
> > the morning. Thanks Yechiel, I needed that.
> > Actually, I was hoping there was another resource
> besides the
> > manual, for two reasons:
> > 1. This development group is a little irritated
> that they are forced
> > to use Oracle instead of MS SQL, so they are
> taking replication issues as
> > being Oracle limitations.
> > 2. They have been talking to the Quest
> salespeople, who naturally
> > heap disdain on Oracle's standard replication
> (selected Oracle SE because
> > the price was closer to MS SQL). I asked the Quest
> rep if they had a
> > document similar to the Oracle manual. Gosh, he
> couldn't think of one. Since
> > nobody on the list has mentioned one, maybe they
> don't have one. The best
> > resource I

RE: Replication question

[Brian McGraw]

Hmmm.  Maybe that's changed, but we were actually advised to move the
objects when we set them up in v8.

--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L

Brian,

That is what I wanted to do, but I understood that it would not
be *supported* if we ran into issues.

Thanks,

Hannah


>  -Original Message-
> From: [EMAIL PROTECTED]@SUNGARD   On Behalf Of Brian McGraw
<[EMAIL PROTECTED]>
> Sent: Thursday, June 20, 2002 11:49 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Replication question
> 
> Just a note, Johanna.  We put all of our Oracle Replication metadata
> into separate tablespaces, and had absolutely no problems.
> 
> Brian
> 
> --
> | Brian McGraw /* DBA */  Infinity Insurance |
> | mailto:[EMAIL PROTECTED] |
> --
> 
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian McGraw
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Bill Pass]

Conflict resolution also has to be considered for log
based replication as well. Same problems exist. If you
think about it Oracles AQ approach is pretty much a
log.

Multi-master replication is still trigger/AQ based in
9i. It's working well for us.

Some of the things you can do to reduce (but not
elleminate) conflict resolution issues are:
1). Stagger sequence generated primary keys by site
2). Put triggers in place to prevent updating of
primary keys (avoids some uniqueness conflicts)
3). Add a last_updated_dt to each table and use that
as your primary method of update conflict resolution
4). Add a "primary" site capability for tie breakers.
Oracle has a built in method, but it requires you add
a site column to each table. If it is not data
dependent, I prefer a custom stored procedure method
where you choose a "primary" site that is not data
dependent.

Deletes are still our biggest problem. Don't really
understand why they can't be applied in the same order
at the remote site (perhaps because we am using
parallel propagation?). But for some reason if we do
massive deletes across multiple related tables in the
same TX, we always end up having to manually
reconcile.

An approach recommended by oracle for this is to add a
deleted_dt column to every table and do deferred batch
deletions. We tried this in conjunction with views and
instead of triggers to hide it from the application. A
couple of problems with this approach is that if you
delete, then try to re-insert with the same alternate
key before the deferred purge process runs, you will
get ORA-1 errors. If you run the deferred deletion
process too often you defeat the purpose of it and
overload the system.


--- [EMAIL PROTECTED] wrote:
> Dennis,
> 
>   All dbs whether SQL Server or Oracle need to deal
> with conflict resolution, thats not strictly an
> Oracle limitation.  As far a Quest goes, they handle
> replication completely different from Oracle. 
> Oracle itself is still using triggers (in 8i at
> least) , ubt now they hide the trigger, Shareplex
> reads the Oracle redo logs.  I believe that 9i uses
> the redo logs and is based (structured) after
> Shareplex itself - there were lots of articles on
> this with the pre-release of Dataguard. Furthermore,
> Oracle places all of its replication metadata in
> SYSTEM tablespace which I dont like, Sharpelex uses
> its own (which the user configures).  As far as
> Shareplex manuals, Quest is the one company that I
> will stand up and say that regardless of anything
> else, their documention is EXCELLENT.  Their
> documentation takes you from Shareplex architecture
> right to directory structure, actual files, usage
> and even scripting.  The sales rep was incorrect. 
> However, I can see them not releasing the manuals
> without a purchase.
> 
>   I believe that they are available on-line for
> download, though I do not know if it is just for
> current customers only.  
> (hehe can't believe I am defending a vendor:>).  But
> when someone does something right, I like to give
> credit.  Also, once you are setup, they are VERY
> stable.  I have my issues with them, but overall I
> feel they do great job at what they do.
> 
> 
> Hannah - Hope it helps any.
> 
> 
> >  -Original Message-
> > From:   [EMAIL PROTECTED]@SUNGARD   On Behalf Of
> DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > Sent:   Thursday, June 20, 2002 10:33 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Replication question
> > 
> > Yechel - Wow, what a blow to be struck with the
> dreaded RTFM first thing in
> > the morning. Thanks Yechiel, I needed that.
> > Actually, I was hoping there was another resource
> besides the
> > manual, for two reasons:
> > 1. This development group is a little irritated
> that they are forced
> > to use Oracle instead of MS SQL, so they are
> taking replication issues as
> > being Oracle limitations.
> > 2. They have been talking to the Quest
> salespeople, who naturally
> > heap disdain on Oracle's standard replication
> (selected Oracle SE because
> > the price was closer to MS SQL). I asked the Quest
> rep if they had a
> > document similar to the Oracle manual. Gosh, he
> couldn't think of one. Since
> > nobody on the list has mentioned one, maybe they
> don't have one. The best
> > resource I've found so far is a former Sybase DBA
> who was able to confirm
> > that log-based replication has most of the same
> issues as Oracle standard
> > replication has.
> > Thanks everyone for your replies.
> > 
> > Dennis Williams
> > DBA, 20% OCP
> > Lifetouch, Inc.
> > [EMAIL P

RE: Replication question

[johanna . doran]

Brian,

That is what I wanted to do, but I understood that it would not be *supported* 
if we ran into issues.

Thanks,

Hannah


>  -Original Message-
> From: [EMAIL PROTECTED]@SUNGARD   On Behalf Of Brian McGraw 
><[EMAIL PROTECTED]>
> Sent: Thursday, June 20, 2002 11:49 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Replication question
> 
> Just a note, Johanna.  We put all of our Oracle Replication metadata
> into separate tablespaces, and had absolutely no problems.
> 
> Brian
> 
> --
> | Brian McGraw /* DBA */  Infinity Insurance |
> | mailto:[EMAIL PROTECTED] |
> --
> 
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[johanna . doran]

Andy,

Consider yourself solicited!  I am currently using Datamirror for our tandem 
db2 to unix oracle replication.  The product was not chosen for our oracle to oracle 
replication for 2 reasons.  #1 trigger based.  #2 if the source transaction failed to 
be commited at the target, then the source transaction was actually rolled back.

Has this strategy changed?   Also, when I did my original research into rpelication 
products Datamirror products were not using log based replication.  You guys having 
some exciting changes for me over there in beautiful Toronto?

Thanks,

Hannah


ps. you work with Elmer Cecelio?


>  -Original Message-
> From: [EMAIL PROTECTED]@SUNGARD   On Behalf Of Andrew Sit 
><[EMAIL PROTECTED]>
> Sent: Thursday, June 20, 2002 11:19 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Replication question
> 
> Dennis et al:
> 
> Sorry for the shameless plug, but my company has a number of products that
> perform oracle-oracle replication as well as DB2/MVS/SQL/ODBC/etc.-Oracle
> and Oracle-DB2/MVS/SQL/ODBC/etc. replication.
> 
> Yes, I am an engineer for iReflect which does similar things to shareplex
> (log-based replication), but also have distinct differences.
> 
> We are not bound by the issues that oracle replication and shareplex have
> (i.e. only replicating keyed tables, and DML only), we replicate both
> non-keyed tables and DDL operations as well.
> 
> http://www.datamirror.com/products/default.asp
> 
> Sorry again, will only reply to solicitations from now on...
> 
> Andy.
> --
> Andrew Sit
> Systems Engineer
> DataMirror Corporation
> (905) 415-0310 x266 (O)
> (416) 839-9908 (M)
> 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Khedr, Waleed]

I can say that replication is an application solution level which means you
can not turn on the switch to get all the applications/tables replicated
while on the other hand Standby database is a database level solution that
does not have to know anything about the applications/tables hosted by the
database.

Regards,

Waleed 

-Original Message-
Sent: Friday, June 14, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L


Curious, that note suggests Advanced Replication as a failover 
methodology.

Seems that a standby database would be _much_ simpler. 

Any thoughts ( from anyone ) on why one would use AR for failover, rather 
than using a standby database?

Jared





John Weatherman <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/14/2002 09:50 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Replication question


Mitchell,

There are a LOT of good papers in Metalink.  I've been getting my own
education over the last few months.  Replication is a really great swiss
army knife though, you need to do a little looking for what you 
specifically
need to do, then test, test, test.  Oh, and did I mention test? :)  I 
found
Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I have
found Support very helpful/informative in this area.

Good Luck,

John P Weatherman
Database Administrator
Replacements Ltd.

-Original Message-
Sent: Friday, June 14, 2002 12:05 PM
To: Multiple recipients of list ORACLE-L


Hi all

I will work on replication soon. any advice for reference I can get.

Thanks in advance.

Mitchell
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[John Weatherman]

Thanks!

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Friday, June 14, 2002 4:10 PM
To: Multiple recipients of list ORACLE-L


Cross-platform is the whole reason for logical standby -- it's SQL
statements that get applied to the secondary database


--- John Weatherman <[EMAIL PROTECTED]> wrote:
> All very true.  Of course the doc in question was written for 8i, so
> that
> explains some of it. :)  Question: Does logical standby in 9.2 work
> across
> platforms?  Haven't had too much time to look at new 9.2 features I'm
> afraid.
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> 
> 
> -Original Message-
> Sent: Friday, June 14, 2002 2:57 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> or you can use the logical standby feature of 9.2 and then have both
> databases open.
> 
> Replication bothers me when I start to think about synchronous vs
> asynchronous. Async doesn't "hold up" the primary site from
> continuing
> on, but the databases are not true copies of one another. Sync are
> true
> copies but you can hold up the commit waiting for a return from the
> remote site.
> 
> And if it fails, it's messy to clean up
> 
> 
> --- John Weatherman <[EMAIL PROTECTED]> wrote:
> > Jarad,
> > 
> > A standby is simpler, however it has limited use for offloading
> some
> > system load (opening for read access suspends roll forward, so the
> > data is somewhat stale).  By using Master-Master synchronous
> > replication 
> > with good deadlock handlers, you can use BOTH instances so you get
> > the 
> > benefit of not having an unused instance lying around (damagement
> > hates 
> > that), but still have fail over available.  Since you can have
> > different 
> > users/locations attach to different instances, you also get some 
> > scalability advantages. 
> > 
> > In general, I agree a standby is MUCH simpler.
> > 
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Friday, June 14, 2002 1:41 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Curious, that note suggests Advanced Replication as a failover 
> > methodology.
> > 
> > Seems that a standby database would be _much_ simpler. 
> > 
> > Any thoughts ( from anyone ) on why one would use AR for failover,
> > rather 
> > than using a standby database?
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > John Weatherman <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 06/14/2002 09:50 AM
> > Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:RE: Replication question
> > 
> > 
> > Mitchell,
> > 
> > There are a LOT of good papers in Metalink.  I've been getting my
> own
> > education over the last few months.  Replication is a really great
> > swiss
> > army knife though, you need to do a little looking for what you 
> > specifically
> > need to do, then test, test, test.  Oh, and did I mention test? :) 
> I
> > 
> > found
> > Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I
> > have
> > found Support very helpful/informative in this area.
> > 
> > Good Luck,
> > 
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> > 
> > -Original Message-
> > Sent: Friday, June 14, 2002 12:05 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi all
> > 
> > I will work on replication soon. any advice for reference I can
> get.
> > 
> > Thanks in advance.
> > 
> > Mitchell
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: John Weatherman
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing

RE: Replication question

[Rachel Carmichael]

Cross-platform is the whole reason for logical standby -- it's SQL
statements that get applied to the secondary database


--- John Weatherman <[EMAIL PROTECTED]> wrote:
> All very true.  Of course the doc in question was written for 8i, so
> that
> explains some of it. :)  Question: Does logical standby in 9.2 work
> across
> platforms?  Haven't had too much time to look at new 9.2 features I'm
> afraid.
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> 
> 
> -Original Message-
> Sent: Friday, June 14, 2002 2:57 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> or you can use the logical standby feature of 9.2 and then have both
> databases open.
> 
> Replication bothers me when I start to think about synchronous vs
> asynchronous. Async doesn't "hold up" the primary site from
> continuing
> on, but the databases are not true copies of one another. Sync are
> true
> copies but you can hold up the commit waiting for a return from the
> remote site.
> 
> And if it fails, it's messy to clean up
> 
> 
> --- John Weatherman <[EMAIL PROTECTED]> wrote:
> > Jarad,
> > 
> > A standby is simpler, however it has limited use for offloading
> some
> > system load (opening for read access suspends roll forward, so the
> > data is somewhat stale).  By using Master-Master synchronous
> > replication 
> > with good deadlock handlers, you can use BOTH instances so you get
> > the 
> > benefit of not having an unused instance lying around (damagement
> > hates 
> > that), but still have fail over available.  Since you can have
> > different 
> > users/locations attach to different instances, you also get some 
> > scalability advantages. 
> > 
> > In general, I agree a standby is MUCH simpler.
> > 
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Friday, June 14, 2002 1:41 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Curious, that note suggests Advanced Replication as a failover 
> > methodology.
> > 
> > Seems that a standby database would be _much_ simpler. 
> > 
> > Any thoughts ( from anyone ) on why one would use AR for failover,
> > rather 
> > than using a standby database?
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > John Weatherman <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 06/14/2002 09:50 AM
> > Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:RE: Replication question
> > 
> > 
> > Mitchell,
> > 
> > There are a LOT of good papers in Metalink.  I've been getting my
> own
> > education over the last few months.  Replication is a really great
> > swiss
> > army knife though, you need to do a little looking for what you 
> > specifically
> > need to do, then test, test, test.  Oh, and did I mention test? :) 
> I
> > 
> > found
> > Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I
> > have
> > found Support very helpful/informative in this area.
> > 
> > Good Luck,
> > 
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> > 
> > -Original Message-
> > Sent: Friday, June 14, 2002 12:05 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi all
> > 
> > I will work on replication soon. any advice for reference I can
> get.
> > 
> > Thanks in advance.
> > 
> > Mitchell
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: John Weatherman
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > 
> > 
> > 
> >

RE: Replication question

[John Weatherman]

All very true.  Of course the doc in question was written for 8i, so that
explains some of it. :)  Question: Does logical standby in 9.2 work across
platforms?  Haven't had too much time to look at new 9.2 features I'm
afraid.

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Friday, June 14, 2002 2:57 PM
To: Multiple recipients of list ORACLE-L


or you can use the logical standby feature of 9.2 and then have both
databases open.

Replication bothers me when I start to think about synchronous vs
asynchronous. Async doesn't "hold up" the primary site from continuing
on, but the databases are not true copies of one another. Sync are true
copies but you can hold up the commit waiting for a return from the
remote site.

And if it fails, it's messy to clean up


--- John Weatherman <[EMAIL PROTECTED]> wrote:
> Jarad,
> 
> A standby is simpler, however it has limited use for offloading some
> system load (opening for read access suspends roll forward, so the
> data is somewhat stale).  By using Master-Master synchronous
> replication 
> with good deadlock handlers, you can use BOTH instances so you get
> the 
> benefit of not having an unused instance lying around (damagement
> hates 
> that), but still have fail over available.  Since you can have
> different 
> users/locations attach to different instances, you also get some 
> scalability advantages. 
> 
> In general, I agree a standby is MUCH simpler.
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> 
> 
> -Original Message-
> Sent: Friday, June 14, 2002 1:41 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Curious, that note suggests Advanced Replication as a failover 
> methodology.
> 
> Seems that a standby database would be _much_ simpler. 
> 
> Any thoughts ( from anyone ) on why one would use AR for failover,
> rather 
> than using a standby database?
> 
> Jared
> 
> 
> 
> 
> 
> John Weatherman <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/14/2002 09:50 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Replication question
> 
> 
> Mitchell,
> 
> There are a LOT of good papers in Metalink.  I've been getting my own
> education over the last few months.  Replication is a really great
> swiss
> army knife though, you need to do a little looking for what you 
> specifically
> need to do, then test, test, test.  Oh, and did I mention test? :)  I
> 
> found
> Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I
> have
> found Support very helpful/informative in this area.
> 
> Good Luck,
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> -Original Message-
> Sent: Friday, June 14, 2002 12:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all
> 
> I will work on replication soon. any advice for reference I can get.
> 
> Thanks in advance.
> 
> Mitchell
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 

RE: Replication question

[Aponte, Tony]

Title: RE: Replication question






Another potential HA use of AR is that you can use different platforms in an HA configuration.  You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored.

Yet another is during planned downtime when upgrading Oracle and OS versions.  You could upgrade the target while the source is the actively used node.  Then move the users off the source and let the remaining changes post to the target.  Now reverse the replication source/target roles and upgrade the old source (now they new target) an let it be until the next time.  The outage should be shorter.  The same technique could be used to roll back to a usable database after an major application change.  Just change the target and let the users try things out.  If there's a problem point them back to the source and regroup.  It should be much quicker that undoing the changes.


Just some thoughts.


Tony Aponte


-Original Message-

From: John Weatherman [mailto:[EMAIL PROTECTED]]

Sent: Friday, June 14, 2002 2:19 PM

To: Multiple recipients of list ORACLE-L

Subject: RE: Replication question



Jarad,


A standby is simpler, however it has limited use for offloading some

system load (opening for read access suspends roll forward, so the

data is somewhat stale).  By using Master-Master synchronous replication 

with good deadlock handlers, you can use BOTH instances so you get the 

benefit of not having an unused instance lying around (damagement hates 

that), but still have fail over available.  Since you can have different 

users/locations attach to different instances, you also get some 

scalability advantages. 


In general, I agree a standby is MUCH simpler.


John P Weatherman

Database Administrator

Replacements Ltd.




-Original Message-

Sent: Friday, June 14, 2002 1:41 PM

To: Multiple recipients of list ORACLE-L



Curious, that note suggests Advanced Replication as a failover 

methodology.


Seems that a standby database would be _much_ simpler. 


Any thoughts ( from anyone ) on why one would use AR for failover, rather 

than using a standby database?


Jared






John Weatherman <[EMAIL PROTECTED]>

Sent by: [EMAIL PROTECTED]

06/14/2002 09:50 AM

Please respond to ORACLE-L


 

    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

    cc: 

    Subject:    RE: Replication question



Mitchell,


There are a LOT of good papers in Metalink.  I've been getting my own

education over the last few months.  Replication is a really great swiss

army knife though, you need to do a little looking for what you 

specifically

need to do, then test, test, test.  Oh, and did I mention test? :)  I 

found

Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I have

found Support very helpful/informative in this area.


Good Luck,


John P Weatherman

Database Administrator

Replacements Ltd.


-Original Message-

Sent: Friday, June 14, 2002 12:05 PM

To: Multiple recipients of list ORACLE-L



Hi all


I will work on replication soon. any advice for reference I can get.


Thanks in advance.


Mitchell

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: John Weatherman

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).




-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: 

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: John Weatherman

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTE

RE: Replication question

[Rachel Carmichael]

or you can use the logical standby feature of 9.2 and then have both
databases open.

Replication bothers me when I start to think about synchronous vs
asynchronous. Async doesn't "hold up" the primary site from continuing
on, but the databases are not true copies of one another. Sync are true
copies but you can hold up the commit waiting for a return from the
remote site.

And if it fails, it's messy to clean up


--- John Weatherman <[EMAIL PROTECTED]> wrote:
> Jarad,
> 
> A standby is simpler, however it has limited use for offloading some
> system load (opening for read access suspends roll forward, so the
> data is somewhat stale).  By using Master-Master synchronous
> replication 
> with good deadlock handlers, you can use BOTH instances so you get
> the 
> benefit of not having an unused instance lying around (damagement
> hates 
> that), but still have fail over available.  Since you can have
> different 
> users/locations attach to different instances, you also get some 
> scalability advantages. 
> 
> In general, I agree a standby is MUCH simpler.
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> 
> 
> -Original Message-
> Sent: Friday, June 14, 2002 1:41 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Curious, that note suggests Advanced Replication as a failover 
> methodology.
> 
> Seems that a standby database would be _much_ simpler. 
> 
> Any thoughts ( from anyone ) on why one would use AR for failover,
> rather 
> than using a standby database?
> 
> Jared
> 
> 
> 
> 
> 
> John Weatherman <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/14/2002 09:50 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Replication question
> 
> 
> Mitchell,
> 
> There are a LOT of good papers in Metalink.  I've been getting my own
> education over the last few months.  Replication is a really great
> swiss
> army knife though, you need to do a little looking for what you 
> specifically
> need to do, then test, test, test.  Oh, and did I mention test? :)  I
> 
> found
> Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I
> have
> found Support very helpful/informative in this area.
> 
> Good Luck,
> 
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> 
> -Original Message-
> Sent: Friday, June 14, 2002 12:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all
> 
> I will work on replication soon. any advice for reference I can get.
> 
> Thanks in advance.
> 
> Mitchell
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
>

RE: Replication question

[John Weatherman]

Jarad,

A standby is simpler, however it has limited use for offloading some
system load (opening for read access suspends roll forward, so the
data is somewhat stale).  By using Master-Master synchronous replication 
with good deadlock handlers, you can use BOTH instances so you get the 
benefit of not having an unused instance lying around (damagement hates 
that), but still have fail over available.  Since you can have different 
users/locations attach to different instances, you also get some 
scalability advantages. 

In general, I agree a standby is MUCH simpler.

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Friday, June 14, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L


Curious, that note suggests Advanced Replication as a failover 
methodology.

Seems that a standby database would be _much_ simpler. 

Any thoughts ( from anyone ) on why one would use AR for failover, rather 
than using a standby database?

Jared





John Weatherman <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/14/2002 09:50 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Replication question


Mitchell,

There are a LOT of good papers in Metalink.  I've been getting my own
education over the last few months.  Replication is a really great swiss
army knife though, you need to do a little looking for what you 
specifically
need to do, then test, test, test.  Oh, and did I mention test? :)  I 
found
Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I have
found Support very helpful/informative in this area.

Good Luck,

John P Weatherman
Database Administrator
Replacements Ltd.

-Original Message-
Sent: Friday, June 14, 2002 12:05 PM
To: Multiple recipients of list ORACLE-L


Hi all

I will work on replication soon. any advice for reference I can get.

Thanks in advance.

Mitchell
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[Jared . Still]

Curious, that note suggests Advanced Replication as a failover 
methodology.

Seems that a standby database would be _much_ simpler. 

Any thoughts ( from anyone ) on why one would use AR for failover, rather 
than using a standby database?

Jared





John Weatherman <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/14/2002 09:50 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Replication question


Mitchell,

There are a LOT of good papers in Metalink.  I've been getting my own
education over the last few months.  Replication is a really great swiss
army knife though, you need to do a little looking for what you 
specifically
need to do, then test, test, test.  Oh, and did I mention test? :)  I 
found
Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I have
found Support very helpful/informative in this area.

Good Luck,

John P Weatherman
Database Administrator
Replacements Ltd.

-Original Message-
Sent: Friday, June 14, 2002 12:05 PM
To: Multiple recipients of list ORACLE-L


Hi all

I will work on replication soon. any advice for reference I can get.

Thanks in advance.

Mitchell
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[DENNIS WILLIAMS]

Mitchell - My knowledge is mostly from reading at this point, but here are
some thoughts that a colleague provided from his experience:

- backup and recovery is much more complicated in a replicated environment
so it needs to be planned
- replicated databases inevitably get out of sync so some process outside
the usual replication method must be built to re-sync the databases.  this
can either be done proactively or reactively - proactive is more fun.
- a process to monitor the overall health of the replicated environment is a
good idea.  i.e. how latent are the transactions, are the replicated
transactions actually being replicated, have there been any data conflicts.
- schema changes get real fun.  planning ahead again a good idea.
- additional testing is needed to prove the replication will work especially
on the performance front. 

I have found only two books on replication (is that a hint that most sites
avoid it??)
Oracle Distributed Systems by Charles Dye, O'Reilly 1999
Data Replication by Marie Buretta, Wiley 1997

-Original Message-
Sent: Friday, June 14, 2002 11:05 AM
To: Multiple recipients of list ORACLE-L


Hi all

I will work on replication soon. any advice for reference I can get.

Thanks in advance.

Mitchell


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 10:58 AM


> We are just starting to look at replication so each manufacturing plant
can
> have their own server. The applications are being developed in-house. I
feel
> the first issue is to analyze each table and decide how it will be
> replicated and what schema changes need to me made to accommodate
> replication. Instead, one of the developers wants to talk to Quest about
> their solution. It seems to me that you need to make the same evaluation
and
> schema changes where needed. If anyone can point me to a white paper on
> schema changes to consider, that would be appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: mitchell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Replication question

[John Weatherman]

Mitchell,

There are a LOT of good papers in Metalink.  I've been getting my own
education over the last few months.  Replication is a really great swiss
army knife though, you need to do a little looking for what you specifically
need to do, then test, test, test.  Oh, and did I mention test? :)  I found
Note: 138181.1 particularly helpful.  Oh, and plan on some TARs.  I have
found Support very helpful/informative in this area.

Good Luck,

John P Weatherman
Database Administrator
Replacements Ltd.

-Original Message-
Sent: Friday, June 14, 2002 12:05 PM
To: Multiple recipients of list ORACLE-L


Hi all

I will work on replication soon. any advice for reference I can get.

Thanks in advance.

Mitchell
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Replication question

[mitchell]

Hi all

I will work on replication soon. any advice for reference I can get.

Thanks in advance.

Mitchell


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 10:58 AM


> We are just starting to look at replication so each manufacturing plant
can
> have their own server. The applications are being developed in-house. I
feel
> the first issue is to analyze each table and decide how it will be
> replicated and what schema changes need to me made to accommodate
> replication. Instead, one of the developers wants to talk to Quest about
> their solution. It seems to me that you need to make the same evaluation
and
> schema changes where needed. If anyone can point me to a white paper on
> schema changes to consider, that would be appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: mitchell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: REPLICATION: Quest Shareplex

[johanna . doran]

Hi,

I changed the Subject to SHAREPLEX, lets close out the contention thread.  
Could be why there are no responses.   A couple people on the list definitely use it 
and I know I certaintly will have a lot to say about it but have to do it later as I 
am working on Prod issues right now.

Thanks,

Hannah

>  -Original Message-
> From: [EMAIL PROTECTED]@SUNGARD   On Behalf Of Rachel Carmichael 
><[EMAIL PROTECTED]>
> Sent: Wednesday, June 12, 2002 11:33 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: I/O contention with external process reading the oracle logs 
>(online redo logs)
> 
> Shareplex reads the log files so if you can't get the log files
> over the existing line, Shareplex can't read them.
> 
> have you considered using an NFS mounted disk for your archive log
> directory?
> 
> or a process that copies the archived logs to the nfs mounted disk on
> the primary and a another process that copies them off the nfs mounted
> disk on the secondary?
> 
> I had to do something like that when I worked with Sybase, back in the
> 4.7 days, so that I could "backup" the log files realtime.
> 
> 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: REPLICATION/FAIL OVER

[Nikunj Gupta]

Hi,

You can go with Materilaized Views (Snapshots) with Fast / Complete Refresh
depending on the network traffic / bandwidth, amount of data you want to
transfer... in these tables.. You can setup different type of refresh for
each of the table..

Since it is once a day.. Trigger / Replication would not be worth a pain..
But yes.. if you really need Resume Material go ahead with Advanced
Replication.. and other stuff...

If you are on 8i or above.. You can also use TRANSPORTABLE TABLESPACES.

Will that help ?? Have you experimented this already ??

Nikunj



Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, April 20, 2002 01:33 AM


> Dennis
> The changes in 4 tables would be on server1 and cnages in 3 tables would
be
> on server2.please suggest how to do this if possible.
> thx
> -Seema
>
>
> >From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: REPLICATION/FAIL OVER
> >Date: Fri, 19 Apr 2002 14:43:25 -0800
> >
> >Seema -
> > I have only done just a little testing of replication, so I'm hardly
> >the expert. I believe the answer to your question is yes. You can make
db1
> >the master site for the 4 tables and db2 the master site for the 3
tables.
> > The bigger question is whether changes can be made to these tables
> >from either side. If the answer is no, then simple snapshots will be
> >sufficient. If the answer is yes, then you must look at how the
application
> >is designed. Can you make changes to the application to avoid problems in
> >replication?
> > But people tend to approach replication with a set of ideas and then
> >find that they must change those ideas as they learn more. Oracle
> >Replication is not a high-volume method, so you must have a good handle
on
> >how many rows will get changed each day.
> > A good book is "Oracle Distributed Systems" by Charles Dye.
> >Dennis Williams
> >DBA
> >Lifetouch, Inc.
> >[EMAIL PROTECTED]
> >
> >
> >-Original Message-
> >Sent: Friday, April 19, 2002 4:59 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Dennis
> >I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1.
> >If i make one server as master server then is it possible to make
secondary
> >server(snapshot server) once and vice versa.
> >Thanks
> >-Seema
> >
> >
> > >From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: RE: REPLICATION/FAIL OVER
> > >Date: Fri, 19 Apr 2002 13:09:19 -0800
> > >
> > >Seema - Advanced replication is a feature of Oracle Enterprise Edition,
> >so
> > >if you have that, you should be set. Based on your description,
updatable
> > >snapshots may meet your needs, and be simpler to configure and
maintain.
> > >Dennis Williams
> > >DBA
> > >Lifetouch, Inc.
> > >[EMAIL PROTECTED]
> > >
> > >
> > >-Original Message-
> > >Sent: Friday, April 19, 2002 3:49 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Is there any additional software required if i go to advanced
> >replication?
> > >-seema
> > >
> > >
> > >
> > > >From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > >Subject: RE: REPLICATION/FAIL OVER
> > > >Date: Fri, 19 Apr 2002 10:03:57 -0800
> > > >
> > > >Seema - You could buy a separate replication package to do this, but
> >you
> > > >probably couldn't justify the cost.
> > > > You could simply write some scripts to do this. But if you use
> > > >Oracle's Basic Replication, then you get some resume material as a
> >bonus.
> > > >Dennis Williams
> > > >DBA
> > > >Lifetouch, Inc.
> > > >[EMAIL PROTECTED]
> > > >
> > > >
> > > >-Original Message-
> > > >Sent: Friday, April 19, 2002 12:40 PM
> > > >To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >Hi
> > > >I want to do sync two databa

RE: REPLICATION/FAIL OVER

[Seema Singh]

Dennis
The changes in 4 tables would be on server1 and cnages in 3 tables would be 
on server2.please suggest how to do this if possible.
thx
-Seema


>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 14:43:25 -0800
>
>Seema -
>   I have only done just a little testing of replication, so I'm hardly
>the expert. I believe the answer to your question is yes. You can make db1
>the master site for the 4 tables and db2 the master site for the 3 tables.
>   The bigger question is whether changes can be made to these tables
>from either side. If the answer is no, then simple snapshots will be
>sufficient. If the answer is yes, then you must look at how the application
>is designed. Can you make changes to the application to avoid problems in
>replication?
>   But people tend to approach replication with a set of ideas and then
>find that they must change those ideas as they learn more. Oracle
>Replication is not a high-volume method, so you must have a good handle on
>how many rows will get changed each day.
>   A good book is "Oracle Distributed Systems" by Charles Dye.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Friday, April 19, 2002 4:59 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Dennis
>I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1.
>If i make one server as master server then is it possible to make secondary
>server(snapshot server) once and vice versa.
>Thanks
>-Seema
>
>
> >From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: REPLICATION/FAIL OVER
> >Date: Fri, 19 Apr 2002 13:09:19 -0800
> >
> >Seema - Advanced replication is a feature of Oracle Enterprise Edition, 
>so
> >if you have that, you should be set. Based on your description, updatable
> >snapshots may meet your needs, and be simpler to configure and maintain.
> >Dennis Williams
> >DBA
> >Lifetouch, Inc.
> >[EMAIL PROTECTED]
> >
> >
> >-Original Message-
> >Sent: Friday, April 19, 2002 3:49 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Is there any additional software required if i go to advanced 
>replication?
> >-seema
> >
> >
> >
> > >From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: RE: REPLICATION/FAIL OVER
> > >Date: Fri, 19 Apr 2002 10:03:57 -0800
> > >
> > >Seema - You could buy a separate replication package to do this, but 
>you
> > >probably couldn't justify the cost.
> > >   You could simply write some scripts to do this. But if you use
> > >Oracle's Basic Replication, then you get some resume material as a 
>bonus.
> > >Dennis Williams
> > >DBA
> > >Lifetouch, Inc.
> > >[EMAIL PROTECTED]
> > >
> > >
> > >-Original Message-
> > >Sent: Friday, April 19, 2002 12:40 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Hi
> > >I want to do sync two database once in a day.I have one database named
> > >test1
> > >
> > >on one server and another db named test2 on other server.I want to sync
> >10
> > >tables from db test1 to db test2 and 20 tables from db test2 to db 
>test1.
> > >How can I do this?Is is only way to go replication?IS any other way to 
>do
> > >that?If I go replication then can someone suggest which replication
> >method
> > >would be good.
> > >Thx
> > >-Seema
> > >
> > >
> > >_
> > >Chat with friends online, try MSN Messenger: http://messenger.msn.com
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Seema Singh
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EM

RE: REPLICATION/FAIL OVER

[DENNIS WILLIAMS]

Seema - 
I have only done just a little testing of replication, so I'm hardly
the expert. I believe the answer to your question is yes. You can make db1
the master site for the 4 tables and db2 the master site for the 3 tables.
The bigger question is whether changes can be made to these tables
from either side. If the answer is no, then simple snapshots will be
sufficient. If the answer is yes, then you must look at how the application
is designed. Can you make changes to the application to avoid problems in
replication?
But people tend to approach replication with a set of ideas and then
find that they must change those ideas as they learn more. Oracle
Replication is not a high-volume method, so you must have a good handle on
how many rows will get changed each day.
A good book is "Oracle Distributed Systems" by Charles Dye. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, April 19, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L


Dennis
I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1.
If i make one server as master server then is it possible to make secondary 
server(snapshot server) once and vice versa.
Thanks
-Seema


>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 13:09:19 -0800
>
>Seema - Advanced replication is a feature of Oracle Enterprise Edition, so
>if you have that, you should be set. Based on your description, updatable
>snapshots may meet your needs, and be simpler to configure and maintain.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Friday, April 19, 2002 3:49 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Is there any additional software required if i go to advanced replication?
>-seema
>
>
>
> >From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: REPLICATION/FAIL OVER
> >Date: Fri, 19 Apr 2002 10:03:57 -0800
> >
> >Seema - You could buy a separate replication package to do this, but you
> >probably couldn't justify the cost.
> > You could simply write some scripts to do this. But if you use
> >Oracle's Basic Replication, then you get some resume material as a bonus.
> >Dennis Williams
> >DBA
> >Lifetouch, Inc.
> >[EMAIL PROTECTED]
> >
> >
> >-Original Message-
> >Sent: Friday, April 19, 2002 12:40 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hi
> >I want to do sync two database once in a day.I have one database named
> >test1
> >
> >on one server and another db named test2 on other server.I want to sync 
>10
> >tables from db test1 to db test2 and 20 tables from db test2 to db test1.
> >How can I do this?Is is only way to go replication?IS any other way to do
> >that?If I go replication then can someone suggest which replication 
>method
> >would be good.
> >Thx
> >-Seema
> >
> >
> >_
> >Chat with friends online, try MSN Messenger: http://messenger.msn.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORA

RE: REPLICATION/FAIL OVER

[Seema Singh]

Dennis
I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1.
If i make one server as master server then is it possible to make secondary 
server(snapshot server) once and vice versa.
Thanks
-Seema


>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 13:09:19 -0800
>
>Seema - Advanced replication is a feature of Oracle Enterprise Edition, so
>if you have that, you should be set. Based on your description, updatable
>snapshots may meet your needs, and be simpler to configure and maintain.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Friday, April 19, 2002 3:49 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Is there any additional software required if i go to advanced replication?
>-seema
>
>
>
> >From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: REPLICATION/FAIL OVER
> >Date: Fri, 19 Apr 2002 10:03:57 -0800
> >
> >Seema - You could buy a separate replication package to do this, but you
> >probably couldn't justify the cost.
> > You could simply write some scripts to do this. But if you use
> >Oracle's Basic Replication, then you get some resume material as a bonus.
> >Dennis Williams
> >DBA
> >Lifetouch, Inc.
> >[EMAIL PROTECTED]
> >
> >
> >-Original Message-
> >Sent: Friday, April 19, 2002 12:40 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hi
> >I want to do sync two database once in a day.I have one database named
> >test1
> >
> >on one server and another db named test2 on other server.I want to sync 
>10
> >tables from db test1 to db test2 and 20 tables from db test2 to db test1.
> >How can I do this?Is is only way to go replication?IS any other way to do
> >that?If I go replication then can someone suggest which replication 
>method
> >would be good.
> >Thx
> >-Seema
> >
> >
> >_
> >Chat with friends online, try MSN Messenger: http://messenger.msn.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
>
>
>
>_
>MSN Photos is the easiest way to share and print your photos:
>http://photos.msn.com/support/worldwide.aspx
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for

RE: REPLICATION/FAIL OVER

[DENNIS WILLIAMS]

Seema - Advanced replication is a feature of Oracle Enterprise Edition, so
if you have that, you should be set. Based on your description, updatable
snapshots may meet your needs, and be simpler to configure and maintain.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, April 19, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L


Is there any additional software required if i go to advanced replication?
-seema



>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 10:03:57 -0800
>
>Seema - You could buy a separate replication package to do this, but you
>probably couldn't justify the cost.
>   You could simply write some scripts to do this. But if you use
>Oracle's Basic Replication, then you get some resume material as a bonus.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Friday, April 19, 2002 12:40 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi
>I want to do sync two database once in a day.I have one database named 
>test1
>
>on one server and another db named test2 on other server.I want to sync 10
>tables from db test1 to db test2 and 20 tables from db test2 to db test1.
>How can I do this?Is is only way to go replication?IS any other way to do
>that?If I go replication then can someone suggest which replication method
>would be good.
>Thx
>-Seema
>
>
>_
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: REPLICATION/FAIL OVER

[Gene Sais]

Seema,

Excuse me for spitting out ideas.  You mentioned replication as one method and were 
unsure of this method. You also expressed interest in alternative methods besides 
replication of which I mentioned a few.   Good luck in your search.

Gene

PS. BTW, replication is not a good tool for HA.  But then again, thats another 
question.

>>> [EMAIL PROTECTED] 04/19/02 04:24PM >>>
Sais
I am takling about replication.The assumption is tables are having millions 
of rows.In case if one Db server down i want to fail over to another one 
also.Which option in replication would be good Is it Multimaster 
replication.
Thx
-Dinesh


>From: "Gene Sais" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 10:08:50 -0800
>
>Now that depends on how big the tables are?  A few options off the top of 
>my head:
>
>1) Drop tables, export, import.
>2) Replication.
>3) Truncate, insert from select as.
>4) Spool data, sql*load it.
>
>so many ways to skin a cat...
>
>I would probably play w/ replication.
>
> >>> [EMAIL PROTECTED] 04/19/02 01:39PM >>>
>Hi
>I want to do sync two database once in a day.I have one database named 
>test1
>on one server and another db named test2 on other server.I want to sync 10
>tables from db test1 to db test2 and 20 tables from db test2 to db test1.
>How can I do this?Is is only way to go replication?IS any other way to do
>that?If I go replication then can someone suggest which replication method
>would be good.
>Thx
>-Seema
>
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Seema Singh
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Gene Sais
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: REPLICATION/FAIL OVER

[DENNIS WILLIAMS]

Seema - Another alternative you may want to check out is transportable
tablespaces, since you just want to sync the databases up once/day. I think
this will require less maintenance than replication.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, April 19, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L


Sais
I am takling about replication.The assumption is tables are having millions 
of rows.In case if one Db server down i want to fail over to another one 
also.Which option in replication would be good Is it Multimaster 
replication.
Thx
-Dinesh


>From: "Gene Sais" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 10:08:50 -0800
>
>Now that depends on how big the tables are?  A few options off the top of 
>my head:
>
>1) Drop tables, export, import.
>2) Replication.
>3) Truncate, insert from select as.
>4) Spool data, sql*load it.
>
>so many ways to skin a cat...
>
>I would probably play w/ replication.
>
> >>> [EMAIL PROTECTED] 04/19/02 01:39PM >>>
>Hi
>I want to do sync two database once in a day.I have one database named 
>test1
>on one server and another db named test2 on other server.I want to sync 10
>tables from db test1 to db test2 and 20 tables from db test2 to db test1.
>How can I do this?Is is only way to go replication?IS any other way to do
>that?If I go replication then can someone suggest which replication method
>would be good.
>Thx
>-Seema
>
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Gene Sais
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: REPLICATION/FAIL OVER

[Seema Singh]

Is there any additional software required if i go to advanced replication?
-seema



>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 10:03:57 -0800
>
>Seema - You could buy a separate replication package to do this, but you
>probably couldn't justify the cost.
>   You could simply write some scripts to do this. But if you use
>Oracle's Basic Replication, then you get some resume material as a bonus.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Friday, April 19, 2002 12:40 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi
>I want to do sync two database once in a day.I have one database named 
>test1
>
>on one server and another db named test2 on other server.I want to sync 10
>tables from db test1 to db test2 and 20 tables from db test2 to db test1.
>How can I do this?Is is only way to go replication?IS any other way to do
>that?If I go replication then can someone suggest which replication method
>would be good.
>Thx
>-Seema
>
>
>_
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: REPLICATION/FAIL OVER

[Seema Singh]

Sais
I am takling about replication.The assumption is tables are having millions 
of rows.In case if one Db server down i want to fail over to another one 
also.Which option in replication would be good Is it Multimaster 
replication.
Thx
-seema


>From: "Gene Sais" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 10:08:50 -0800
>
>Now that depends on how big the tables are?  A few options off the top of 
>my head:
>
>1) Drop tables, export, import.
>2) Replication.
>3) Truncate, insert from select as.
>4) Spool data, sql*load it.
>
>so many ways to skin a cat...
>
>I would probably play w/ replication.
>
> >>> [EMAIL PROTECTED] 04/19/02 01:39PM >>>
>Hi
>I want to do sync two database once in a day.I have one database named 
>test1
>on one server and another db named test2 on other server.I want to sync 10
>tables from db test1 to db test2 and 20 tables from db test2 to db test1.
>How can I do this?Is is only way to go replication?IS any other way to do
>that?If I go replication then can someone suggest which replication method
>would be good.
>Thx
>-Seema
>
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Gene Sais
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).