Re: Oracle and DRBD - a real HA alternative?
Date: Fri, 22 Jan 2010 08:38:24 +0000
Message-ID: <3f5690af1001220038l440e38abt9b2f50e54b21af24_at_mail.gmail.com>
On Fri, Jan 22, 2010 at 3:49 AM, Mark Brinsmead <pythianbrinsmead_at_gmail.com> wrote:
>
> Well, if you have Data Guard, you should use it. But there is no Data Guard
> with Standard Edition.
Yes you are right there is no DataGuard in SE and there is a Standby Database and it can you used with your own script or with ex. DBVisit software (www.dbvisit.com)
>
> Your original method has its own advantages, though. You don't need to
> license the standby database server until you failover. (although you will
> be limited in the number of times you start the Oracle software --
> presumably for failover tests -- before you do have to license the standby
> server.)
From license point of view storage replication is better but I see one
weak point of that configuration - in case of redo log corruption on
primary this same
corruption will be transferred to standby and in worst case you will
be not able to open standby at all
(maybe with _allow_resetlogs_corruption=true but this not a solution).
I have similar situation once with EMC and SRDF replication and we
have to restore DB from backup.
regards,
Marcin Przepiorowski
http://oracleprof.blogspot.com/
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 22 2010 - 02:38:24 CST