Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Which tablespace offline mode will cause a checkpoint to occur?

Re: Which tablespace offline mode will cause a checkpoint to occur?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Thu, 19 Jun 2003 18:32:47 GMT
Message-ID: <2b04fv0qtke0nlv8fo4l5vb83vatv2bebs@4ax.com>


On Thu, 19 Jun 2003 14:24:51 GMT, Hans Forbrich <forbrich_at_telusplanet.net> wrote:

>Peter wrote:
>
>> What I am not sure about is that if a checkpoint occurs for this
>> tablespace right before it is taken offline, then when it is taken
>> online again, its SCN will be lagging behind SCN of other tablespaces.
>> How is this reconciled?
>

If only this tablespace's SCN is incrementaed before it is taken offline then the other online tablespaces' SCN will lag behind instead. How is this reconciled?
Thanks

>Where is the SCN stored?
>
>Why does it matter that the SCN is lagging?
>
>Under what conditions does it need to be reconciled?
>
Received on Thu Jun 19 2003 - 13:32:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US