Re: What *really* happens at ALTER TBSP END BKP ?

From: Tanel Poder <tanel_at_@peldik.com>
Date: Fri, 4 Jul 2003 15:46:21 +0300
Message-ID: <3f05772a$1_1@news.estpak.ee>

Hi!

> take place naturally anyway. (It is true, however, that until the headers
> are synchronised, you are a little vulnerable to an unexpected instance
> failure... Oracle would demand you perform a media recovery on subsequent
> startup to correct the SCN mismatch, when in fact no real media recovery
is
> required). Assuming you don't suffer from instance failures on a regular
> basis, however, the extra checkpoint those books recommend is a bit
> unnecessary.

Actually you just have to issue end backup command to files in backup mode after instance crash. Oracle just doesn't know whether the file is in backup mode because of a crash or because it's restored from older backup. No media recovery is needed if you don't lose your controlfiles (checkpoint progress is also recorded in controlfile, thus Oracle knows it can recover using just online logs).

Tanel. Received on Fri Jul 04 2003 - 07:46:21 CDT