Re: dataguard

  • From: Veres Lajos <vlajos@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 13 Dec 2006 00:01:21 +0100 (CET)

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: