Re: dataguard

On Tue, 12 Dec 2006, Carel-Jan Engel wrote:


On Tue, 2006-12-12 at 22:55 +0100, Veres Lajos wrote:

On Tue, 12 Dec 2006, Sam Chakkanat wrote:


What is size of your application?  How many tables? volume.  Depending, Oracle 
Streams may also be an option.


Rman dump is about 3 G.
Exp dump~ 1.8 G.
We have 70-80 tables.
Most of selects uses a single (products) table.
If we could spread the queries against that table that would be a big
gain too.

More important: how much redo are you generating? That might be an


About 5-6 G/day.


indication whether streams is feasible as well. Kirtikumar Deshpande
used to be on this list (haven't seen him here for a while though), he
knows a lot about streams. At first sight streams could be a useful
alternative to you.


I think I should check this ,,streams'' thing.


Or this operations exclude the other?

Yes, this is true up to 10gRx.

11xyz will support read-only access during redo apply. So, you probably
have to wait for about a year or so. Or get in the Beta program.


Stability is important too.
Beta things arent really acceptable.

Thanks for your response.

--
Veres Lajos
vlajos@xxxxxxxxxxxxxx
+36 20 438 5909
--
http://www.freelists.org/webpage/oracle-l

Other related posts: