mv versus advanced replication
- From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
- To: <ajoshi977@xxxxxxxxx>
- Date: Thu, 7 Sep 2006 15:37:23 +1000
Logical standby is available from 9i onwards. I would either go with MV
or Logical standby if I could. Advanced Replication is a night mare to
administer and is to be avoided unless you want 2 ways replication,
which is indeed very complicated in the first place.
Re: ** mv versus advanced replication
* From: A Joshi <ajoshi977@xxxxxxxxx>
* To: strickland.mark@xxxxxxxxx, Jared Still <jkstill@xxxxxxxxx>
* Date: Wed, 6 Sep 2006 07:56:18 -0700 (PDT)
Thanks Mark and Jared.
I should have specified that we are not on 10G so logical standby is
not
really an option. So I am looking at MV or advanced replication. Thanks
Hi,
I have a 250 GB database and need to replicate it with almost all
the
tables. I am thinking of doing MV replication. Other option is advanced
replication. What are pros and cons of using MV as opposed to advanced
replication. I think some of the maintenance to be done is less in case
of MVs
and it is simpler to understand and setup. Any advantages for advanced
replication? What about data integrity on target. I think advanced
replication
checks before applying changes so any loss of transaction is detected.
Is there
any check in case of MV? Any tools to check the data on target? I think
the
performance impact degradation on source for both is almost same.
Thanks for your help.
Mark Strickland <strickland.mark@xxxxxxxxx> wrote:
Then exponential it is. Most definitely not scalable. Bottom line:
the amount of time required to complete each row-level DML statement
gets longer as time goes on. My previous, quite-lengthy thread goes
into the gory details. Won't add to that thread until I get final
resolution from Oracle Support.
Mark
--
//www.freelists.org/webpage/oracle-l
------------------------------------------------------------------
Leng Kaing
Senior Oracle DBA
Hansen Technologies; 2 Frederick St; Doncaster 3108
Ph: +61-3-9840-3832
Notice:
This e-mail and any attachments are confidential and may contain legally
privileged information and/or copyright material of Hansen Technologies Limited
or third parties. Copying, distributing, disclosing, commercialising or
otherwise acting in reliance on this e-mail and any attachments is strictly
prohibited unless you are the addressee of this e-mail and have written
permission to do so. If you have received this e-mail in error please delete
this e-mail (including any copies and attachments) and contact Hansen
Technologies Limited by return e-mail or by telephone on + 61 3 9840 3000. Any
views expressed in this e-mail are those of the individual sender and may not
necessarily reflect the views of or be a commitment by the organisation, except
where the individual sender has the authority and expressly states them to be
so.
Other related posts:
