Re: move datefiles (almost) online

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 10 Mar 2003 02:44:27 +0200
Message-ID: <3e6bdf37$1_2@news.estpak.ee>

> Hi Tanel,
>
> I guess this won't work.
>
> The "read-only"-datafiles are NOT the same datafiles
> we put online afterwards.
>
> Those have to be recovered because they miss an "END BACKUP"
> as well as the checkpoint from being taken offline.

Hi!

Yes, it will work. Files in read only tablespaces are not written to. Why would they be called read only then ;)
Also, they don't have to worry about missing END BACKUP, because no BEGIN BACKUP is done on them, actually no begin backup command can be issued on read only tablespace. They aren't checkpointed either after read only is set.

They are just datafiles which are only read, they may go offline and become online again without any additional recovery. And it doesn't matter what is the file name when becoming online again, what matters, is the contents of file header and the relevant controlfile entry (checkpoint SCN in datafile header and stop SCN in controlfile entry).

Tanel. Received on Sun Mar 09 2003 - 18:44:27 CST