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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
