Veres,
What is size of your application? How many tables? volume. Depending, Oracle Streams may also be an option.
But DML redirect to master only may need some work, if application cannot support that. (or use specific service names for application? )
Your standby database can be logical/physical depending upon the application and the business need. And you could
defer the apply at the standby to leverage the stand by server as a "read only".
Hope this helps.
Sam Chakkanat
- Veres Lajos <vlajos_at_ludens.elte.hu> wrote:
> Hello,
>
> (I never used dataguard before. Sorry for my lame questions.)
>
> Is it possible to syncronize nearly on-line and use the "backup" database
> as a select-only node with loadbalancing?
> Our system is 99% read-only. Dataguard seems to be good for
> redundancy/failsafe, but it would be great if we could use the "backup"
> machines CPU too.
>
> TNS can spreads SELECTs between the two nodes, and redirect DMLs to
> only the master?
> (Isnt a big problem if TNS cant, then the applications DB layer
> should do it.)
>
> Other solution could be a Master->Slave replication, but I think it
> wont be as solid.
>
> Exists any other Oracle solution for "cumulate computers power"?
> I heard about RAC, but seems a bit expensive for us. (Shared storage)
>
> Any comment, experience, suggestion, (rtfm keyword) would be really
> appreciated.
>
> Thanks.
> --
> Veres Lajos
> vlajos_at_ludens.elte.hu
> +36 20 438 5909
> --
> http://www.freelists.org/webpage/oracle-l
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 12 2006 - 13:30:20 CST