Re: using VCS to automate Oracle primary/standby failovers

In article <c976cb73.0406071118.20c5e27_at_posting.google.com>,  sl1433_at_hotmail.com (Beeblebrox) wrote:

> Hello,
>
> I'm familiar with using VCS to failover services using shared storage
> between hosts. But can I configure VCS to automate failing over to an
> Oracle standby DB that does *not* use shared storage?
>
> VCS would not be responsible for transferring the archivelogs or
> redologs to the standby DB, although it would be nice if ensuring that
> all required logs were on the standby was part of the mechanism
> (again, not required, though. We already have a mechanisms in place
> that do that). VCS would be required to perform the steps to turn the
> primary into the standby (if it's up) and the standby into the
> primary.
>
> Is this possible? Or can VCS only be used in a
> shared-storage/disk-import config?

Sure, you could do this. But, why would ever want to? If I understand your question, you want to have an oracle instance that's failed continue on another system with with a different set of data. Why? When the failed system came back, you'd have to databases that are totally out of sync.

Unless the database is read-only, I don't see a reason to do this.

-- 
DeeDee, don't press that button!  DeeDee!  NO!  Dee...