RE: Oracle Data Guard
- From: <JayMiller@xxxxxxxxxxxxxxxx>
- To: <rjamya@xxxxxxxxx>, <litanli@xxxxxxxxx>
- Date: Mon, 3 Apr 2006 14:31:06 -0400
LOL.
But seriously, we've been using standby databases and then Dataguard
since v. 7.2 here and it works very well.
The automatic log shipping feature really came into its own in 9i, I
wasn't very happy with it in 8i (we continued to use our scripts for
that version). As of 9i it's very easy to switch back and forth between
production and standby instances, graceful failovers were still easy in
8i, just a lot more steps.
The only real consideration is what degree of data loss you can
accommodate since if your production database explodes you will lose any
data in the current redo log and any archive logs that have not yet been
fully copied over to the standby. We force a log switch every 15
minutes to minimize potential data loss.
Thanks,
Jay Miller
Sr. Oracle DBA
x68355
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Monday, April 03, 2006 1:32 PM
To: litanli@xxxxxxxxx
Cc: oracle-l
Subject: Re: Oracle Data Guard
LOL,
This is a rather creative way of getting Carel Jan's attention ...
Raj
On 4/3/06, Li Li <litanli@xxxxxxxxx> wrote:
>
> Hi, All,
>
> Anybody has used Oracle Data Guard before? What's your experiece with
it?
> like it or dislike it? Any challenge? Any best practice?
>
> Thank you for your sharing!
>
> -Li
--
----------------------------------------------
Got RAC?
--
//www.freelists.org/webpage/oracle-l
-----------------------------------------
This message is confidential and sent by TD Waterhouse solely for
use by the intended recipient. If you are not the intended
recipient, you are hereby notified that any use, distribution or
copying of this communication is strictly prohibited. This should
not be deemed as an offer or solicitation, to buy or sell any
product. Any 3rd party information contained herein was prepared by
sources deemed reliable, but is not guaranteed. TD Waterhouse does
not accept electronic instructions that would require an original
signature. Information received by or sent from TD Waterhouse is
stored, subject to review, and may be produced to regulatory
authorities or others with a legal right to such.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
