Hi,
I newly setup master to master replication : I followed the steps. It is 9i so no need to run catrep :
1) Create replication administrator repadmin
2) Grant privileges and register repadmin as propagator and receiver
3) Create public database links, private database link in repadmin.
4)
Robert -
I have studied this issue quite a bit and my opinion (based on reading,
not experience) is that the success in replication is in the organization,
not the technology. The question is whether your organization and
application are ready for replication. It sounds like you have some
exper
One good book to have is "Oracle Built-in Packages" from O'Reilly. It does
more than merely show the syntax for the packages, but shows how the
packages are used. There is a chapter on Advanced Replication. I have
found this book to be one of the more useful books tha
Hello Robert
We are working with advance replication in 8.1.6.3.4.
You need the following in the instances:
global_names = true
unique global name in each database
job_queue_processes = 10 ( at least)
archive enabled
I will send you offline the script that I use to create replication.
It does al
We'll need to set up multi-master replication between two 8.1.7 databases within the
next few months. We're not experienced with replication beyond relatively simple
snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed
resources we can use to get up to speed? I
Paul Baumgartel
.com>cc:
Sent by: Subject: Re:
Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL? See
the Supplied PL/SQL Packages reference; here's the description:
EXECUTE_DDL Procedure
This procedure supplies DDL that you want to have executed at some or
all master sites. You can call this procedure only from the master
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun Solaris
2.7.
In the replication group, we would like to add a new column to a replicated
table.
Not only that, we would like to add this new column to the primary key of this
replicated table.
What are the steps that
Hi,
For Oracle 9i (9.0.1):
"Updatable materialized view" is "Basic Replication" (available and included
in both EE and SE)
"Multi-master replication" is "Advanced Replication" (available and included
only in EE)
BTW, there are slightly different feature
Sarath - My understanding is that basic replication is included with Oracle
Standard Edition and advanced replication is included with Oracle Enterprise
Edition. The boundary between what is basic and what is advanced is not made
very clear, but I believe that updatable snapshots is part of basic
i am installing Oracle 8.1.7. is the snapshot feature
part of advanced replication? should i have to take
the license for advanced replication to use this
feature.
Thanks
Sarath
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http
e recipients of list ORACLE-L
> Subject: Re: Oracle Advanced Replication
>
> Adar,
>
> How do you take care of backups?
> I mean, what kind of backups do you take? How are you addressing the
> scenario of incomplete recovery?
> Following are some of my doubts.
>
>seems to be converting the DML based on internal algorithm, which throws my
>indexing approach out of the window. Oracle Support has been of no help,
>other then suggesting different indexing for failover site.
>
>Gary Weber
>Senior DBA
>Charles Jones, LLC||Superior Inf
Title: RE: Oracle Advanced Replication
Not
yet, support for those objects are scheduled for this winter.
Nick
-Original Message-From: Ji, Richard
[mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002
12:58 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Oracle
of a serious
problem
> (11 seqptember)
> you will not lose all your data, only the data since the last archive.
>
> 5) Test, Test, Test again all failure scenarios, and test again each
month,
> quarter or whatever.
>
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED
whatever.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Peter Barnett [SMTP:[EMAIL PROTECTED]]
> Sent: Fri, February 15, 2002 1:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Advanced Replication
>
> We ar
Title: RE: Oracle Advanced Replication
Nick,
Does SharePlex support user defined object
types?
Richard
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 2:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle
-L
> Subject: RE: Oracle Advanced Replication
>
> All this talk of replication is really nice.
>
> SharePlex for Oracle, can handle master to master replication. Conflicts
> are handled via pl/sql procedures inside the database, where you can
> determine exactly what
Title: RE: Oracle Advanced Replication
All this talk of replication is really nice.
SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict
y 14, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L
We are looking at Advanced Replication as a fail over
option for a web site. Straight forward installation,
both boxes on the same subnet on their own dmz. The
servers will be located on the same rack in the
computer room. Very few tabl
---u
possible down time of a standby?
one out-of-synch condition with Advanced Replication can cause you hours of
down time.
I'd suggest you continue to question the consultants about the choice of AR
as a failover solution.
If you're running at least 8.1.7, standby is normall
; Bummer...
>
> Pete
>
> --- [EMAIL PROTECTED] wrote:
> > Pete,
> >
> > Have you considered using a standby database?
> >
> > More suitable for failover than Advanced
> > Replication, and
> > much easier to implement and maintain.
> >
> >
; Quest's SharePlex.
> In the worst case, maybe my reply will encourage
> someone with
> replication experience to reply.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Thursday, February 14,
Pete,
Have you considered using a standby database?
More suitable for failover than Advanced Replication, and
much easier to implement and maintain.
Jared
Peter Barnett <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/14/02 03:03 PM
Please respond to ORACLE-L
To: Mu
PROTECTED] wrote:
> Pete,
>
> Have you considered using a standby database?
>
> More suitable for failover than Advanced
> Replication, and
> much easier to implement and maintain.
>
> Jared
>
>
>
>
>
>
> Peter Barnett <[EMAIL PROTECTED
le recipients of list ORACLE-L
We are looking at Advanced Replication as a fail over
option for a web site. Straight forward installation,
both boxes on the same subnet on their own dmz. The
servers will be located on the same rack in the
computer room. Very few tables storing data from an
appl
We are looking at Advanced Replication as a fail over
option for a web site. Straight forward installation,
both boxes on the same subnet on their own dmz. The
servers will be located on the same rack in the
computer room. Very few tables storing data from an
application that is tracking click
Ray,
Advanced replication definitely does NOT require using
replication manager. Being an anti-gui person, I use
the repapi calls almost exclusively. Starting with
8.1.6 replication manager is java-based and therefore
you should be able to run it from any java-capable
client, although I
Ray,
Any kind of replication is a nightmare (oops, challenge!) to
administer. Oracle, Quest, EMC, homegrown, whatever. As you add more
schemas and objects to the equation you'll need at least person
dedicated to it.
As for the advanced replication manuals, hmm. The 8i set has 2 -
&quo
I was beginning to think advanced replication looked like
a reasonable solution for an applicaiton. Then I read:
Replication environments supporting both multimaster and snapshot
replication can be challenging to configure and manage. To help
administer these replication environments, Oracle
If you there is error in the DEFERROR view, and you are sure that there are
no error in replication you can try to delete it manually:
execute
dbms_defer_sys.delete_error(deferred_tran_id,'REPLICATION_SITE');
HTH,
Sonja
-Original Message-
Sent: Wednesday, April 04, 2001
When running master to master replication, we experience an error that
caused a deferred sys transaction error. The cause of the original error is
fixed and we attempted to run DBMS_DEFER_SYS.EXECUTE_ERROR to rerun the
transaction in error. This fails with the same original error of ORA-01403.
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
35 matches
Mail list logo