| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: replication question
Well, you could open standby DB only for read only access (8i) whereas in replication, both or
all (more than 2) databases could be up and open to users all the times.
Each DML causes substantial overhead as each transaction needs to be propogated and applied at all the master sites (whereas in Oracle Parallel Server, there is centralized database accessed by multiple instances, there is no need for this).
So, if you donot need two databases at two geographically separate locations, open for users, then Standby DB or OPS might be better option. Again, in OPS, if the hardware cluster fails then you are in trouble...
About speed, if you could tune up sending of logs and application of it, then Standby database would consume substantially lesser resources than replication, hence higher throughput... The primary database in Standby DB just needs to send the archivelogs (simple file transfer) and then log application happens on the secondary server... Whereas, in replication, the database would have to propogate and apply each and every transaction individually....
+Rahul
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 sent to the replicated site.
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Kevin Lange
Sent: Monday, March 04, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: 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 databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need.
-----Original Message-----
From: Rahul Dandekar [mailto:rvd_oracle_at_hotmail.com]
Sent: Monday, March 04, 2002 6:43 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: replication question
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 you are planning multimaster replication, then better
spend a couple of months studying it and testing on test boxes...
Make 100% sure that your application really needs the replication
and there is no other simpler option...
Just 2 cents...
+Rahul
----- Original Message -----
From: 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 to other database at a specific time.
Do I need Advanced replication or basic replication . ?
How can I understand that replication is supported in my both databases. ?
Bunyamin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul Dandekar
INET: rvd_oracle_at_hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Mar 04 2002 - 13:23:29 CST
 |
 |