Re: SharePlex

Hi!

> If the Load is not high on the Production server and what
> I meant by load is the Transaction Load. As it Financial
> system , so it all depend on the Modules

More like on number users and their activities..

> --> Physical Standby databse - This option is good
> * If there is not much load on the production server and so
> the Realtime loading can be done thru Data Guard. [ This is
> possible with 9i and I am not sure with 8i]

You probaby meant Logical standby here, because physical standby suits high-load environments well, since no additional processing has to be done on primary db if in archivelog mode (not counting requirement for logging operations in here).

> But from Nelso Emailm the physical standby is not at all good
> option as he want to use the other server for Reporting purpose
> with all data should be very close to production server

Depending on MTTR requirements, one solution would be to just to recover standby database few times a day, at lunchtime, for example. This may create some inconveniences to users though.
Note that even when running Apps on shareplex-replicated-standby-database isn't probably supported, then for Cognos it doesn't matter, it only deals with content of tables anyway, and SP should be able to tranfer data correctly.

> So as Nelson is on 8i and as he also cannot go for Oracle 9i
> as that require him to go for Oracle Apps to 11.5.9 or so

Wrong, 9i is certified with Apps starting from 11.5.7.

Tanel.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).