L&G,
Is it possible to establish further downstream snapshot replication from a
snapshot site in 8.1.7.0.0/Solaris 2.8? I know this can be done in 8.1.7.4.x
and 9i and I can not build multi-master replication due to restrictions :-(
i.e. I'd like to perform: master --> snapshot (new master) --> s
Some issues to think about here:
Do they really need all the data from production?
Or are they just saying that without any justification...
Do they know what questions they are going to ask?
Or is this a fishing expedition.
Are they going to understand ad-hoc development will continue to not oc
"ad-hoc queries"
as in, we'll write something that will bring your database to its knees
that kind of reporting, it's better to have a separate database
--- "Thater, William" <[EMAIL PROTECTED]> wrote:
> Weaver, Walt scribbled on the wall in glitter crayon:
>
> > Okay, we have a request for q
cipients of list ORACLE-L
> Subject: RE: A basic replication question
>
> Weaver, Walt scribbled on the wall in glitter crayon:
>
> > Okay, we have a request for quite a few of our customers for
read-only
> > copies of their databases they can do their ad-hoc queries on. These
>
Weaver, Walt scribbled on the wall in glitter crayon:
> Okay, we have a request for quite a few of our customers for read-only
> copies of their databases they can do their ad-hoc queries on. These
> read-only databases need to as closely matched to the production
> database as possible, i.e., ex
I have attached some generic scripts for creating the snapshots and
refresh procedures. The only item missing is the database link.
Basic outline:
1. create database link
2. create snapshot logs on primary
3. create snapshots on copy
4. run a full refresh
5. run a fast refresh
6. setup jobs with
Walt,
I presented a paper at IOUG Live 2003 and wrote an article on DBAZine on an
issue similar to this. Although the issue addressed was something much more
complex; the article does have scripts to set up a basic readonly snapshot
(or MV) replication. The article is at http://www.dbazine.com/nan
Okay, we have a request for quite a few of our customers for read-only
copies of their databases they can do their ad-hoc queries on. These
read-only databases need to as closely matched to the production
database as possible, i.e., exact, from their point of view.
I've looked into some options to
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
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
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 replicat
Hello Ed
We are using replication for one application, Dealing room.
This is synchronous replication between 2 computers sitting
in the same room connected by dedicated cable.
The target is to have up to date second database in case of machine failure.
I got lost quickly in the manual and finall
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
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,
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
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,
>
>
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
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,
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
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
, but replication is great for carrying out major data migrations!
peter
edinburgh
> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> Sent: 26 August 2002 19:19
> To: Multiple recipients of list ORACLE-L
> Subject: RE: General Replication question
>
>
&
We are using advanced replication for three instances.
It's labor intensive, fraught with error, and
requires continual babysitting.
For us, it is doing what we want. Near real time
copies of the primary instance, and instant failover
capability (well, instant as soon as the tnsnames.ora
is cha
Subject:Re:General Replication question
Ed,
I've shied away from replication beyond snapshots due to the
requirement to
not modify objects that are registered with the replication manager. Seems
that
as soon as I tell the duhveloper that he/she can not modify the structure,
but
will have
Ed - We have flirted with the replication thing here for some time. I have
had the same questions as you, trying to take classes, for example. I don't
think replication is widely used, but there are plenty of sites out there.
The conclusion I've come to is that the secret to a successful
repli
Ed,
I've shied away from replication beyond snapshots due to the requirement to
not modify objects that are registered with the replication manager. Seems that
as soon as I tell the duhveloper that he/she can not modify the structure, but
will have to come talk to me. At this point they don
I'm curious, based on a discussion I had with a DBA here at work, how
many people use the replication features of Oracle. I often see
replication listed as one of the selling points of Oracle, but it's also
very hard to get a class on replication because they are always closing
classes for poor r
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:
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
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
"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
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 an
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
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
*
ues.
> >
> > Thanks,
> >
> > Hannah
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED]@SUNGARD On
> Behalf Of Brian McGraw
> <[EMAIL PROTECTED]>
> > > Sent: Thursday, June 20, 2002 11:49 AM
>
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
>
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
-
> 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
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
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
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
;
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
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
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
>
>
> 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:
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
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
;
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
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
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
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? :)
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
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.
Simple question, but I can't seem to find the answer in the oracle docs:
Let's say I insert a record into an updatable snapshot, and then I update
the same row. When I refresh the snapshot, will the same two DML
operations be played back in order to the master, or will it only
replicate a single
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
Hi All,
I have recently been handed the task of setting up master-master
replication on our existing production environment (yes, I am in
test to start!). Because this is an established site with a lot
of historical data, we would like to use Offline Instantiation
as detailed in Note 68657.1. W
: replication question
I
have used both.
Replication, like archive log movement , happens whenever you set it up
to happen. That can be anywhere from every minute to once a day to
beyond. It just depends on your needs. In the case of my old job,
we had replication happening at
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
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
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
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
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
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
:
Bunyamin K. Karadeniz
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 04, 2002 3:33
AM
Subject: replication question
Dear Gurus,
The clients will enter records to a database all
day and I will update the other database .
I need to replicate 10 tables in a
Dear Gurus,
The clients will enter records to a database all
day and I will update the other database .
I need to replicate 10 tables in a database to
other database at a specific time.
Do I need Advanced replication or basic
replication . ?
How can I understand that replication is suppo
AMTo: Multiple recipients of list
ORACLE-LSubject: Replication question
I'm setting up a
basic replication on a 8.1.7 oracle database and I'm wondering if a schema
change is also replicated along with data changes. If I modify the
structure of a table on the master sit
I'm setting up a
basic replication on a 8.1.7 oracle database and I'm wondering if a schema
change is also replicated along with data changes. If I modify the
structure of a table on the master site, is that modification is propagated to
my snapshot site ?
Please
help
We had the same problem and
unfortunately that is true!
Sonja
-Original Message-From: andrey
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 05, 2001 3:56
PMTo: Multiple recipients of list ORACLE-LSubject:
Advanced replication question
Dear list
!
Could not find
Dear list
!
Could not find
this in the docs :
it looks like
i can replicate tables only among schemas with same names in different
DBs
( I.e i can only replicate SCOTT's
objects into SCOTT schemas in remote DBs)
Is this true
?
If not , please
advice what
Dear list
!
Could not find this
in the docs :
it looks like i
can replicate tables only among schemas with same names in different DBs (
I.e i can only replicate SCOTT's objects into SCOTT schemas in remote DBs)
.
Is this true
?
If not , please
advice what should i do or where can i read
69 matches
Mail list logo