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
Peter - Since nobody seems to be answering your question, I guess you get
the second tier here. I have not used Oracle Replication, but I have studied
it some. The first thing I seem to always hear about Oracle's Replication is
that you must be careful or it won't be able to keep up.
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
Does anyone know why catrep.sql puts things in the SYSTEM schema, instead of
just placing them all inside SYS?
I found this in the catrep.sql script:
Rem **
Rem For SYS to be able to grant select on defcalldest and deftrandest
R
1) Oracle 8.1.6.3.4 on NT.
2) Multi master replication.
3) OLTP application that does not assign RBS to transactions.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: A. Bardeen [SMTP:[EMAIL PROTECTED]]
> Sent: Sun, January 27, 2002 5:1
What are the versions of the db's involved?
Are you doing updatable snapshots or multi-master
replication?
My guess is that the replication trigger that is
populating the deferred transaction queue is firing
before the RBS is set as part of the application or
another trigger.
If this
Hello All
As a first step I am applying to all you knowledgeable persons on the list.
(Metalink and itar will follow)
I have an application that worked fine until I activated synchronous
replication on that schema.
After the replication was build the user activated a program that access
Oracle
Systems - A big consideration is whether your application is designed to be
replicated. I have been able to find two books on replication:
Oracle Distributed Systems by Charles Dye. O'Reilly. 1999. This is specific
to Oracle, and is pretty good.
Data Replication - Tools and Technique
I have to agree here. You need to read up on it. If you have specific
questions
after that then go to the list.
-Original Message-
Sent: Sunday, January 20, 2002 7:55 PM
To: Multiple recipients of list ORACLE-L
Oracle 8i Replication Manual
http://otn.oracle.com/docs/products/oracle8i
Hi,
What do u want to achive by replication ??
HA - High avilability OR
LB - Load Balancing
For HA what you can do is go for a standby. For LB u hv to go to OPS or even
OPFS can do both
Regards
OraEtM!!
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple reci
Firstly I would go read all Oracle Documentation regarding Replication before doing anything else, This is an area that need a high level of understanding.
Do you want a hot standby, are you trying to replicate GL entrys from a database into Financials. After a read of the documents and when
Oracle 8i Replication Manual
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76959/toc.htm
;-)
-Joe
At 10:15 PM 1/20/02, you wrote:
>Hi All
>
>We have got two Oracle Databases physically connected.We want to replicate
>one database with the other dat
Hi All
We have got two Oracle Databases physically connected.We want to replicate
one database with the other database.We are quite new to this
subject.Kindly guide us with the procedure of replication and the
conditions to be considered for replication.
Thanks in advance
Regards
Systems
We are using replication as a way to protect ourselves against hardware
failure.
We have a new application for dealers room(foreign exchange deals).
There was a need to recover after hardware BANG.
We are using one machine as database server and the other as backup.
There is no access or update
Its been a long time since I have done replication but one thing
I would advise is include it during your logical design phase. Once
you have the schema built and ready to go, adding replication afterwards
really limits you. You can do it no problem, you choices just become
more limited
Yechiel,
What strategy do you guys use for conflict resolution? Do you have scripts
for that?
TIA
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, January 13, 2002 4:30 AM
> Hello Bill
>
> Replication is not s
Hello Bill
Replication is not so hard to do.
Just call for Oracle expert.
I needed to do replication and got nowhere FAST.
After An oracle expert came, we worked for about 6 hours and I got a script
that does synchronic replication
between 2 dB's.
Basically you have to do the followin
Title: RE: replication
uh oh... with that said, I guess I better jump in.
and follow suit with your format...
SharePlex for Oracle by Quest Software
(www.quest.com/shareplex)
Pros: Extremely fast (50+GB of data per day)
Low overhead (3-7% overall.)
Messages are
12:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: replication
>
>
> Greetings,
>
> I am looking for advice regarding Oracle replication. We are on
> 8.1.6 EE, and will be upgrading to Oracle9 later this year. At that
> time, we also plan to establish another Orac
Bill,
Tread very carefully along Replication path while considering 4 GBs of data
to be replicated daily. If all transactions are inserts, it may fly. If you
have updates or deletes, you may encounter huge performance hit on
destination site. Also, consider the fact the Replication will slow
Greetings,
I am looking for advice regarding Oracle replication. We are on
8.1.6 EE, and will be upgrading to Oracle9 later this year. At that
time, we also plan to establish another Oracle instance on a
separate sun machine; 1 instance will serve as a staging area, the
second will be a
9 Jan 2002, [EMAIL PROTECTED] wrote:
> We have a replication between production and reporting database.
>
> Prodn Server Reporting server
>
> HP-UX 10.2HP-UX 10.2
> oracle 7.3.4.4.1 oracle 7.3.4.4.1
>
> The os and oracl
Hi,
We have a replication between production and reporting database.
Prodn Server Reporting server
HP-UX 10.2HP-UX 10.2
oracle 7.3.4.4.1 oracle 7.3.4.4.1
The os and oracle patches on the production server and reporting server are
in sync
Remco,
I'm inclined to agree with John on this one. For
example, chapter 3 of the REPAPI manual discusses the
setup of multi-master replication. Although the
example it shows uses the REPADMIN user for all
purposes, it explains that you can register different
users to use as the propagato
Sorry, don't agree ...
-Oorspronkelijk bericht-
Van: Garner, John (NESL-IT) [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 19 november 2001 11:15
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Replication: general overview
The oracle documentation is good
-Ori
The oracle documentation is good
-Original Message-
Sent: 19 November 2001 09:50
To: Multiple recipients of list ORACLE-L
Hi list,
Does anybody know any links to docs that give a general technical
overview of how oracle deals with replication ? I'm especially
interested
Hi list,
Does anybody know any links to docs that give a general technical
overview of how oracle deals with replication ? I'm especially
interested in a schema that shows what oracle-user is doing what in the
process of replication. I've got it to work on our databases, and have
ma
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
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
Hi,
it depends on what kind of replication you want.
We're using "normal" snapshots (read only and updatable) and multi
master replication.
There is an organisational issue concerning multi master replication.
You have to be sure about how you want to replicate. We went wi
Hi Gurus
We are considering implementing replication, on our server.
Microsoft 2000 Oracle 816.
Does anyone know of any problems, or "I wish I had known that before."
type of issues of doing this?
Many Thanks
Denham
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Ahh but it does not have to sit there just waiting !!!
We had a DEC TruCluster, with the ASE failover software
(available software everywhere). This was NOT OPS
We still used our failover box but for less powerful
and less critical app. We decided that during failover,
we could tolerate sligh
part ... chaning DNS and brining the Standby up in real mode. But our
down
> time is less than an hour. That is acceptable in our work. It was also
> the simplest to create and maintain.
>
> As for replication, at my old job we replicated DB2 data down to Oracle
> every
ng the Standby up in real mode. But our down
> time is less than an hour. That is acceptable in our work. It was also
> the simplest to create and maintain.
>
> As for replication, at my old job we replicated DB2 data down to Oracle
> every 5 minutes. There were times
Don't we all ...
-Original Message-
Sent: Thursday, August 16, 2001 1:33 PM
To: Multiple recipients of list ORACLE-L
)
>
>Rachel is 100% right (do we ever expect differently ??)
>
you shouldn't... I make mistakes all the time
__
>
>Rachel is 100% right (do we ever expect differently ??)
>
you shouldn't... I make mistakes all the time
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ:
than an hour. That is acceptable in our work. It was also
the simplest to create and maintain.
As for replication, at my old job we replicated DB2 data down to Oracle
every 5 minutes. There were times when communications lagged and the
replications broke. This caused a lot of problems because
__Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date: 8/16/2001 9:06 AM
Standby... even if I have to be paged in the middle of the night to bring it
up and live.
replication is a nightmare to implement unless you plan for it. St
Standby... even if I have to be paged in the middle of the night to bring it
up and live.
replication is a nightmare to implement unless you plan for it. Standby is a
breeze to implement and maintain.
>From: Andrey Bronfin <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
&
ted to
the secondary one .
I thought of 2 possible approaches :
multimaster asynchronous replication and a standby database.
The problem is that AFAIK , there is no automatic failover in case of
standby DB , i.e.. U need to issue "ALTER DATABASE ACTIVATE STANDBY
DATABASE; " or something l
Replication is included with the RDBMS. It is not an additional option that
you buy separately (yet).
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Message-
> From: Ron Thomas [SMTP:[EMAIL PROTECTED]]
> Sent: Monday,
Does anyone know the approximate price to order the replication option for 8.1.7EE? I
can't seem to
find any information on this at the oracle store.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"Either lead by example, or become a terrible warning"
--
Please see the offici
Andrey,
Don't even think about implementing this until you've
read the manuals and thoroughly understand the
concepts. Replication can be very unforgiving when
you don't properly design and configure it. You may
also find that your application is not even suited for
it.
>
Dear gurus !
I need to implement multimaster replication (asynchronous) among 2
databases.
A couple of general questions before i start :
- Is it a must for the 2 DBs to be of the same version (release) ?
- Is it a must for the 2 DBs to run on the same O/S, hardware etc ... ?
- Do U have to
Dear gurus !
Finally , they caught me ;-(
I need to implement multimaster replication (asynchronous) among 2
databases.
A couple of general questions before i start :
- Is it a must for the 2 DBs to be of the same version (release) ?
- Is it a must for the 2 DBs to run on the same O/S
I need to implement the
standby database for the Txn. Proc. Prod. system. I have a few doubts. If the
failure/disaster happens to prod DB, and can't open the DB, then How to transfer
the contents of online logs to standby database? My logs would switch once every
hour, and so, I would los
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
David Turner wrote:
>
> I have heard numbers of about 100-800 transactions per minute as the limit for Oracle
> replication, but does anyone know if this would include procedural replication. If so
> does anyone out there know of some better solutions for replicationg a really high
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
I have heard numbers of about 100-800 transactions per minute as the limit for Oracle
replication, but does anyone know if this would include procedural replication. If so
does anyone out there know of some better solutions for replicationg a really high
number
of transactions across a WAN
in relocating. ( again :)
Jared
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Fri, 25 May 2001, Jack C. Applewhite wrote:
> > We have a Standby database and I love it - especially compared to the
> > complexities of replication!
> >
> > Once y
On Friday 25 May 2001 10:52, Jeremiah Wilton wrote:
> Things that can weight the decision on the side of standby:
> - Frequent DDL changes - requires outage for MM rep.
Argh!!! I sent my previous reply to *everyone*.
I *hate* when that happens. I was a long time Pine user and
am still not use
I too have had the wonderful experience of supporting multi-master
replication. We had 3 sites and there was a lot of work maintaining it. I
have not had the opportunity to implement a standby-database yet but from
talking with those who have setting up and maintaining a standy-by database
Thank you for your excellent feedback. And, thank you
for reminding me that replication requires quiescing
the databases for DDL changes! :-( Ughh, as soon as I
read that I quickly remembered spending late nights
doing application upgrades from 2 years ago and the
hassle I had to go through
transactions is OK.
- It is economically acceptable to have a whole system sitting idle.
Things that can weight the decision on the side of MM replication:
- Both systems must be usable.
- low rate of DDL changes
- low rate of DML
- good network between systems
- No committed data loss is acceptable
'm looking for feedback on setting up a
high-availability architecture for our production
database. In a nutshell, we are a 24-hour shop and I
need to be able to keep a secondary database
(failover) in sync with the primary in case the
primary fails. I have supported advanced replication
(async
Walter,
We have a Standby database and I love it - especially compared to the
complexities of replication!
Once you set up the standby database, automate the mechanism for
transferring archived redo logs from your production db to the standby,
applying them, and deleting them once applied, it
Hi,
I'm looking for feedback on setting up a
high-availability architecture for our production
database. In a nutshell, we are a 24-hour shop and I
need to be able to keep a secondary database
(failover) in sync with the primary in case the
primary fails. I have supported advanced replic
wil lresume
pushing, unless it failed 16 times and was marked
broken in which case it will need to be manually run
or marked unbroken.
Even with synchronous replication it shouldn't hang
indefinitely. Eventually a timeout will be reached
and an error will be returned since the transaction
c
:56 AM
To: Multiple recipients of list ORACLE-L
Nihar,
Don't remove the network link!!
O.KI'm not a replication guru, but my thoughts are that the way
replication is setup, the commit can only happen if the data can be
replicated as it should. If there is no network connect
Nihar,
Don't remove the network link!!
O.KI'm not a replication guru, but my thoughts are that the way
replication is setup, the commit can only happen if the data can be
replicated as it should. If there is no network connectivity, the instance
cannot get to one of the othe
hi gurus
My Asynchronus multimaster replication is working fine. But the moment i
remove the physical connectiviy (network link),it hangs without even
updating local data base. i mean it's not allowing me to commit insert
statement at one location.
Can anybody helps me in this.
t
Eric,
My paper applies to all platforms as platform
independence is one of the many strengths of
replication.
As to your websites... must be a Y-chromosome thing ;)
Take care,
-- Anita
--- "Eric D. Pierce" <[EMAIL PROTECTED]> wrote:
> A.,
>
> Just out of curiosity
A.,
Just out of curiosity, is your paper pertinent to NT/Win2K? Is the
replication done strictly within Oracle?
what about stuff like this?:
http://www.nsisw.com/main/pages/products.html
regarding your private question about rifts in space/time continuums,
the world is probably safe for
Ron,
if you have lot of tables or, if you have lot of DDL changes on the objects
which you want to replicate, don't do it. It's very difficult to maintain it
and every time you do DDL on these objects, you have to suspend replication
(which isn't always possible and easy for that m
Ron,
Replication is not for the faint of heart and it would
behoove you to research this to see if replication is
really the right way to accomplish your goal.
How much time is needed to maintain a replication
environment is entirely dependent on how well the
environment was designed and
I'd agree, replication can be a pain when you are first learning how
to do it. I've also had some problems with the Replication Manager gui
crashing/hanging on me. You might want to spend the extra time and
learn how to do everything from the command line. Besides, real dbas
We have advanced multimaster replication.
I have spent about 70% of my time looing into replication related isues.
I came to site with no experience of replication, no documentation about
the environment and no transfer of knowledge since the previous dba already
left.
Now this may be because
We have a small but critical application running on NT. The user wants to
implement replication. We have never done replication for Oracle. Can
someone give me an idea of how much difficult it is to maintain a replicated
database on NT. How much of my time will I need to allocate to keeping
Henrik,
It's been replaced by the replication forum on
technet:
http://technet.oracle.com
Choose Discussion Forums underneath Collaboration on
the left hand menu.
HTH,
-- Anita
--- Henrik Ekenberg <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Is there anybody that k
Henrik Ekenberg wrote:
> Is there anybody that know where I can find the mailing list for Oracle
> Replication Special Interest Group. ?
I've been a subscriber for a while. About two weeks ago I got the attached
message saying they've converted it from a mailing list to an OT
Hello,
Is there anybody that know where I can find the mailing list for Oracle
Replication Special Interest Group. ?
Thanks for your help.
Regards
Henrik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henrik Ekenberg
INET: [EMAIL PROTECTED]
Fat City Network
On Fri, 11 May 2001,A. Bardeen scribbled on the wall in glitter crayon:
->Bottom line... if you implement replication without
->knowing what you're doing it's only a matter of time
->before your luck will run out and you'll have
->problems. Keeping your resume up to
Jared,
I'm replying to the list since I don't see Nihar's
email address.
Multi-master replication would be an ideal candidate
for this situation as long as there is a primary key
on the table or one or more columns which can be used
to simulate a PK. It's always important t
FYI I am forwarding this to the list, so please address
replies to the original sender.
-- Forwarded Message --
Date: Fri, 11 May 2001 12:45:43 +0530
Hi jared
This is Nihar from india. I am having some query regarding Oracle
Replication.
Basically i am having 2 diffrent
recipients of list ORACLE-L
Subject:Looking for a good book in Oracle
replication...Thanks
Regards,
Waleed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Regards,
Waleed
--
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
-
Hi!
I am currently working on a system architecture. We are thinking about using
multi-master replication. I am pretty new to that area...
Initially we will have three master databases replicating to each other.
If we want to scale the system, can we easily integrate a fourth master
database
Hi
I am trying to setup multimaster replication
environment. I have two machines. On on windows NT and
one on linux. I followed all the steps listed in
oracle8i Api reference manuals till chapter 3. But
when I update emp table. It corresponding updations
are not reflected in second database
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, Apri
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
I installed (NT) 8.1.7 on a secondary server and am trying to get
replication going (master to updateable snapshot). OEM is not responding to
any of the setup commands for the snapshot. Anybody know any secrets?
I tried all this with an 8.1.6 to 8.1.6 and had no problems (other than
stock market
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
Why donot you use transportable tablespace concept. If you need more about
it let me know .
--Neena
Larry Taylor wrote:
> Can anyone tell me which would be better to use for copy a 12 gig schema
> from one 8.1.6 database to any 8.1.6 database, Standby-Database or
> Replication?
>
esday, January 31, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
>i would just copy all of the datafiles and such over to the other machine
>and bring it up. I don't know, is that considered standby or replication?
>Not up on the lingo
>Kevin
It's neither. What you
nal Message-
Sent: Wednesday, January 31, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
>i would just copy all of the datafiles and such over to the other machine
>and bring it up. I don't know, is that considered standby or replication?
>Not up on the lingo
>Kevin
It
considered standby or replication?
>Not up on the lingo
>Kevin
It's neither. What you described is just copying a database from one server
to another. Standby and replication requires setup that's more than just
copying datafiles.
Richard Ji
-Original Message-
Taylor
!!
-Original Message-
Sent: Wednesday, January 31, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
>i would just copy all of the datafiles and such over to the other machine
>and bring it up. I don't know, is that considered standby or replication?
>Not up on the lingo
>Ke
nd bring it up. I don't know, is that considered standby or replication?
>Not up on the lingo
>Kevin
It's neither. What you described is just copying a database from one
server
to another. Standby and replication requires setup that's more than just
copying datafiles.
Richard
>i would just copy all of the datafiles and such over to the other machine
>and bring it up. I don't know, is that considered standby or replication?
>Not up on the lingo
>Kevin
It's neither. What you described is just copying a database from one server
to another. S
i would just copy all of the datafiles and such over to the other machine
and bring it up. I don't know, is that considered standby or replication?
Not up on the lingo
Kevin
-Original Message-
Taylor
Sent: Wednesday, January 31, 2001 12:52 PM
To: Multiple recipients of list ORA
Can anyone tell me which would be better to use for copy a 12 gig schema
from one 8.1.6 database to any 8.1.6 database, Standby-Database or
Replication?
I tried to export/import, I lost data and constraints. So now I'm
considering
replication or standby database.
Do you have a good sol
301 - 395 of 395 matches
Mail list logo