On startup Oracle reads the header block of every file to check that the
last scn number written to the file matches the control file information to
see if recovery is required. It seems to me that the documentation used to
say two header blocks per file, but I think that Oracle actually needs a
certain amount of room and that the number of header blocks may be only one
for larger Oracle block sizes. You should check the Database Admin Guide
for your release.
Biju Thomas <tbiju_at_hotmail.com> wrote in article >>..
>..... We find that even
> though the tablespaces are made read only, during startup of oracle, it
tries to
> touch all the physical files.
>
> ** What is Oracle trying to verify during startup on the physical files
of read
> only tablespaces? How much of the file should be available to complete
this
> verification? (In ASM, we can keep part of the file on disk and rest on
tape)?
>
Received on Fri Nov 13 1998 - 08:40:44 CST
