Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Checkpoint ...
Yep, you're correct, everything is frozen in datafiles when they're in read
only mode (you can have read only datafiles on read only media if you want).
Also, no controlfile records (like checkpoint cnt, checkpoint scn) for read
only datafiles are not changed, I've verified this with controlfile dumps
and diff just in case.
As you said, it's logical.
Tanel.
> I don't believe that datafiles in Read Only tablespaces have the scn
updated. I've not tested it, but it is logical.
>
> Daniel Fink
>
> Satheesh.Babu_at_iflexsolutions.com wrote:
>
> >
> > All,
> > Whenever checkpoint happens datafile header scn and controlfile scn
> > will be in sink. Is my assumption is right? Is there any other scenarios
> > where checkpoint only update controlfile and doesn't update datafile
> > header? Agreed, during "begin backup" mode datafile header will be
> > frozen.. Other than that any scenarios?
> >
> > Thanks and Regards,
> > Satheesh Babu.S
> >
> > DISCLAIMER:
> > This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended recipient
you should not disseminate,distribute,store,print, copy or deliver this
message.Please notify the sender immediately by e-mail if you have received
this e-mail by mistake and delete this e-mail from your system.E-mail
transmission cannot be guaranteed to be secure or error-free as information
could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or
contain viruses.The sender therefore does not accept liability for any
errors or omissions in the contents of this message which arise as a result
of e-mail transmission. If verification is required please request a hard-copy version.> > (or the name of mailing list you want to be removed from). You may
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: <Satheesh.Babu_at_iflexsolutions.com
> > INET: Satheesh.Babu_at_iflexsolutions.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: tanel.poder.003_at_mail.ee Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Jan 16 2004 - 09:44:35 CST
![]() |
![]() |