Re: alarming experience with controlfile autobackup on
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 26 Oct 2012 09:22:04 +0200
Message-ID: <508A3A1C.8000300_at_nordea.com>
On 25.10.2012 18:33, Sigrid Keydana wrote:
>
> Hi all,
>
> Now the basic danger, with CONTROLFILE AUTOBACKUP ON, I thought, was that if the following occurs:
>
> step 1: do backup
> step 2: perform structural change, e.g., add tablespace
> step 3: wait till autobackup has been created (this was another strange thing, I've found no way to influence this myself, not even by a database restart!)
> step 4: someone does a DELETE OBSOLETE. The controlfile from the backup will be deleted as obsolete, we have the more recent one now only ...
> step 5: delete all DB files
>
> ... I might not be able to perform incomplete recovery until just before the structural change.
>
>
Date: Fri, 26 Oct 2012 09:22:04 +0200
Message-ID: <508A3A1C.8000300_at_nordea.com>
On 25.10.2012 18:33, Sigrid Keydana wrote:
>
> Hi all,
>
> Now the basic danger, with CONTROLFILE AUTOBACKUP ON, I thought, was that if the following occurs:
>
> step 1: do backup
> step 2: perform structural change, e.g., add tablespace
> step 3: wait till autobackup has been created (this was another strange thing, I've found no way to influence this myself, not even by a database restart!)
> step 4: someone does a DELETE OBSOLETE. The controlfile from the backup will be deleted as obsolete, we have the more recent one now only ...
> step 5: delete all DB files
>
> ... I might not be able to perform incomplete recovery until just before the structural change.
>
>
One could still create controlfile manually - while hard it is possible to make
-- Pole na kazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> pos : Senior DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A st, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem: 0000021828, dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku, VIII Wydział Gospodarczy Krajowego Rejestru Sądowego, o kapitale zakładowym i wpłaconym w wysokości: 277.493.500,00 złotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 26 2012 - 09:22:04 CEST