Re: alarming experience with controlfile autobackup on
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Oct 2012 09:22:04 +0200
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@xxxxxxxxxx>
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
