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_at_ludens.elte.hu
+36 20 438 5909
--
http://www.freelists.org/webpage/oracle-l