Re: freeware for data guard

C. (http://symcbean.blogspot.com/) wrote:
On Jun 8, 3:17 pm, learner <Zabal...@xxxxxxxxx> wrote:
Howdy experts,
I am looking for a solution to replicate Oracle DB to DR site. My boss
does not want me to use dataguard and is asking me to find a freeware
solution. If anyone of you is aware of some data replication solution
please let me know. I know all about rsync, but he wants something
better than rsync that could replicate data real time.
Any information in this regard will be helpful.

Thanks .

There are very good reasons that rsync does not work in real time.
There are realtime replication solutions - like DRBD. From the tone of
your question your going to have lots of problems when you try to
bring up a database on top of realtime file-level replication that has
unexpectedly stopped.

Define realtime. If you can pause a database and do a 'sync' command to get everything written to disk, you can LVM snapshot the underlying LVM filesystem and duplicate *that* for backup.

If you can afford a proper DR solution then you can afford Dataguard,
if you can't afford Dataguard, you won't have realtime failover
capability.

...or migrate your apps to MySQL and use the built-in replication.

C.


Agreed.
.

Relevant Pages

  • Re: Up to date data in warehouse
    ... Can replication only be used between sql servers? ... > DTS is not good for Realtime ... >> a) real time olap ...
    (microsoft.public.sqlserver.dts)
  • Re: freeware for data guard
    ... There are realtime replication solutions - like DRBD. ... If you can afford a proper DR solution then you can afford Dataguard, ...
    (linux.redhat)
  • Re: speed of light
    ... It was also called "line by line replication" by someone else. ... If Dataguard is causing us grief, ... An additional problem with Dataguard is that it requires the database ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Re: Version blues
    ... DB2 and is licensed separately. ... (similar to a RAC or Dataguard assuming you have true HA on your disk). ... That's more similar to replication not RAC. ...
    (comp.databases.oracle.server)
  • Re: Combining snapclones with DataGuard
    ... am using snapclones, how can I also use DataGuard? ... (Assuming that I am already snapclone'ing the database to the ... -Works well in conjunction with SnapMirror (array-based replication)" ...
    (comp.databases.oracle.server)