RE: dataguard
- From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
- To: <vlajos@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 12 Dec 2006 13:24:42 -0600
As far as I know, you have to stop the replication (recovery) and
open the standby database readonly .. when you done "select", you
resume recovery process by "alter database recover managed standby database;".
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Veres Lajos
Sent: Tuesday, December 12, 2006 1:07 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: dataguard
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@xxxxxxxxxxxxxx
+36 20 438 5909
--
//www.freelists.org/webpage/oracle-l
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information. Any
review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security
System.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
