RE: Streams for one-time single source replication
- From: "Ruel, Chris" <Chris.Ruel@xxxxxxx>
- To: "rjoralist3@xxxxxxxxxxxxxxxxxxxxx" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Feb 2014 21:02:08 +0000
Yeah, it's not like riding a bike...I'm lucky if I remember the details of what
I did a month ago :)
So, I guess, if I had to make the decision, do I want simpler (but, might take
longer) I would go with DG Physical and drop the stuff you do not need
afterward.
To be more efficient, and perhaps learn a nice technology along the way (only
to forget it in 2 months) you could do Streams. It's not like it is that hard
unless you start running into things like the apply process stopping randomly
or hitting conflicts, using triggers, etc.
While I am not experienced with it myself, some DBA's at my company have used
GoldenGate for replication...however, that costs $$$.
Chris Ruel * Oracle Database Administrator
cruel@xxxxxxx * Desk:317.759.2172 * Cell 317.523.8482
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rich Jesse
Sent: Thursday, February 06, 2014 3:56 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Streams for one-time single source replication
Chris replies:
> How big is the entire database vs. the subset of schemas?
Entire DB (incl temp, undo, system, etc) is ~1TB. Subset of schemas is 800GB,
with a lot of whitespace in there.
> Also, I don't want to discourage you from Steams altogether. I had
> originally assumed you would want the whole database kept in sync
> which would have made DataGuard the obvious choice for me.
I have actually setup both a physical and logical standby, but it was a
lifetime ago (8 years?) and I left that job before that project was completed.
"Use it or lose it" applies, I guess. :)
Thanks!
Rich
--
//www.freelists.org/webpage/oracle-l
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this E-mail,
you are
hereby notified that any dissemination, distribution, copying, or action taken
in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please notify
the
sender immediately and permanently delete the original and any copy of this
E-mail
and any printout. Thank You.**
--
//www.freelists.org/webpage/oracle-l
Other related posts:
