Re: Synchronous backup of two instances

From: Peter Kallweit <peter.kallweit_at_vector-consulting.de>
Date: Tue, 11 Jan 2005 08:50:49 +0100
Message-ID: <34heqpF49aop1U1@individual.net>

Joel Garry wrote:

> Peter Kallweit wrote:
>

>>Hi Mark,
>>
>>thanks for your answer.
>>
>>How can I define the point in time?
>>One possibility I see is the time (in steps of seconds(?)). But in

>
> one
>

>>second there can be many transactions. So I think, this option has

>
> not
>

>>the necessary granularity. Is this correct?

>
>
> Correct, but not the only option. See the backup and restore manuals.
> You can recover until a specific system change number.
>

I've seen the SCN. But as I understood, it is only unique inside one database instance. Can I use it across instances?

>>Which other options do I have to bring all the databases to the same
>>point in time?

>
>
> Perhaps you don't want to, as there can be a delay in updating. You
> want to make consistent _transactions_, right? So the issue becomes,
> how to be sure a specific distributed transaction is recovered
> properly. The details become very site specific.
>
> In other words, "it depends."

Your absolutely correct, I want consistent transactions. Can you give me a hint where to start for the details?

Thanks,
Peter Received on Tue Jan 11 2005 - 01:50:49 CST