LG,
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) --
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
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
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
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.,
: 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
read-only databases need to as closely matched to the production
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 quite a
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
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
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
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
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
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 multimaster
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
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
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.
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
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
When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the
necessary underpinnings for multimaster replication of an object, it
creates a package called object_name$RP. This package contains code
to be run when rows are inserted, updated, or deleted. There are,
however, no trigges
, 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
Ed - We have flirted
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
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
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
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
: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 to come talk to me
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
-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
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
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
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
, 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
[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
: [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
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
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
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
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
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
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
:
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
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
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
]
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 Metalink. I've been getting my
own
education over
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
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.
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
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
:
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 database
Thank you Rahul ,
Do you acceptvisa 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 your
]
[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 both
-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 understand it, the
standby database will be receive
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 about how
: 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 happeningat different
: 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 site
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
Dear list
!
Could not find
this in the docs :
itlooks like
i can replicate tablesonly 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
62 matches
Mail list logo