Re: What happens during open resetlogs?

I just wanted to add that if there is ever some form of distributed transactions via DB Links, then the highest SCN of the Database will be propogated to all nodes. I believe the value of the COMMIT_POINT_STRENGTH init .ora parameter may play a role here, but I am a little vague on the details.

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is always inevitable; Discouragement is invariably optional

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

On 8/24/06, Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
>
> Yes, any datafiles opened for read-write will start getting checkpointed,
> thus having (near)current SCN in them..
>
> Tanel.
>
> ------------------------------
> *From:* Ram Raman [mailto:veeeraman_at_gmail.com]
> *Sent:* Friday, August 25, 2006 00:24
>
> *To:* tanel.poder.003_at_mail.ee
> *Cc:* alever_at_libero.it; oracle; oracle-l
> *Subject:* Re: What happens during open resetlogs?
>
>
>
> I have wondered what happens during the transportable tablespaces but I
> got the answer today. Thanks for the explanation.
>
> And I am guessing if we plug in a TTS with a lower SCN it will bump the
> SCNs in the new incoming files.
>
>
>
>

--

--
http://www.freelists.org/webpage/oracle-l