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
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 recipien
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
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:
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.SCH
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,
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 multim
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 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 recipien
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,
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 ord
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 manu
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? :)
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 pr
ent 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
;
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
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 Metali
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
>
>
> 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:
ms 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 We
hy 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
> > Pleas
;
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
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
gt; 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 a
t; 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
-
> 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 Repl
ssues 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]>
> > S
gt; -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
>
ues.
> >
> > Thanks,
> >
> > Hannah
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED]@SUNGARD On
> Behalf Of Brian McGraw
> <[EMAIL PROTECTED]>
> > > Sent: Thursday, June 20, 2002 11:49 AM
>
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
*
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
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 o
Hello John
We are doing master to master replication.
Both are 8.1.6 on NT.
When we need to rebuild we delete and create both databases
and import the data into both.
Then we run a script that dynamically generate the proper procedure calls
for all the tables in the schema and run them.
I thin
Depends on your need.
You can have read only snapshots, updatable
snapshots
or multimaster...
Again if you think of multimaster... then you would
need to make decision
based on your application requirements about sync
or async
I donot have any expereince of snapshot
replication.
But, if yo
Thank you Rahul ,
Do you accept visa or bank check ?
:)
Bunyamin
- Original Message -
From:
Rahul
Dandekar
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 04, 2002 2:43
PM
Subject: Re: replication question
Depends on your need.
You can have
database
to be replicated to another database then simple replication is all you
need.
-Original Message-From: Rahul Dandekar
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
replication question
Depends on
PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent:
Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: replication question
The
way I see it . the question comes down to whether or not you need
two way replication or just one way. If
would
suggest the Standby approach.
Kevin
-Original Message-From: James Ambursley
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
replication question
Is
replication faster than a standby database. As I
supporting data
updates.
- Original Message -
From:
Kevin Lange
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 04, 2002 10:43
AM
Subject: RE: replication question
The
way I see it . the question comes down to whether or not you need
two way
of list ORACLE-L
Sent: Monday, March 04, 2002 1:24
PM
Subject: RE: replication question
Is
replication faster than a standby database. As I understand it, the
standby database will be receive arch logs at preset intervals. Does
replication have the same functionality and
: Multiple recipients of list ORACLE-LSubject: RE:
replication question
Is
replication faster than a standby database. As I understand it, the
standby database will be receive arch logs at preset intervals. Does
replication have the same functionality and about how much data is
I believe that schema changes are only automatically
propagated to all sites by using the Replication Manager or the DBMS_REPCAT
package.
Nancy
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of ALEMU AbiySent:
Monday, November 12, 2001 1:40 AMT
"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 b
43 matches
Mail list logo