Re: Some more questions on Oracle Dataguard Logical Standby

Prem K Mehrotra wrote:

> We will be using Oracle 9i (9.2.0.5) on a mission critical database
> which
> should be up 24x7 running on HP UNIX 11.
>
> We want to use logical standby database for reporting. My questions
> are:
> 1. Is logical standby on 9.2 a stable product. I know there have been
> many
> bug fixes in 9.2.0.5. But is logical standby database in 9.2.0.5
> really ready
> for mission critical work.

My first reaction was that "mission critical" and "9i logical standby" do not belong together in the same sentence. But you are aware of the many bugs afflicting the implementation, so that at least is something. That said, I'd still be inclined to wait until 10g before going logical. But you're asking in the right group for anyone with a working 9i logical to step forward and let us all know how it went/is going

> 2. Logical standby requires supplemental logging on primary key,
> unique index columns. What kind of overhead this supplemental logging
> will generate because performance is also critical. Also, will no of
> archived log increase significantly because of additional redo
> logging.

The overhead could be very considerable. It depends on how sensible your primary keys are. The sort of multi-column natural keys I've seen would not translate happily into minor supplemental logging.

> We already have license for Quest Shareplex which we bought a few
> years ago,
> but we need to renew the license. I had created a thread on shareplex
> a while
> ago. Sonehow whoever had setup shareplex before I came did not make
> people
> aware of its reporting facility. Now we want to use reporting. Choice
> is to renew shareplex license or use Oracle's logical standby database
> with
> 9.2.0.5. We cannot use Oracle 10G because of mission critical nature
> of the application.
>
> Thanks a lot in advance for any responses.
>
> Prem

I think Hans has hit the nail on the head in his reply to you: get Oracle to do some work. There's some cash available which could either be making its way to Shareplex, or to Oracle Corporation. Time to make them earn their money by demo'ing and speccing a solution for you.

Regards
HJR Received on Thu Aug 26 2004 - 23:12:45 CDT