Re: replication question

[Rahul Dandekar]

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 ----- Original Message ----- From: James Ambursley To: Multiple recipients 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 much data is sent to the replicated site.     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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:[EMAIL PROTECTED]] 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