Some more questions on Oracle Dataguard Logical Standby

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.

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.

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 Received on Wed Aug 25 2004 - 22:42:53 CDT