"Johannes" <johannes_at_merckle.de> wrote in message news:<a9i43c$3fmf9$1_at_ID-3532.news.dfncis.de>...
> Hi all!
> We are affliceted by mass corruption of datablocks in all of the datafiles
> lieing on
> one RAID5. Probably caused by changing a dead device online.
> Does anyone know this with Mylex DAC controllers?
>
> As the files are mainly needed for mass data upload, i thought it would by
> ok to
> set the tablespace within this datafiles readonly during the restore process
> from the tapes.
> So the DB could be remain available for restricted use.
> As I'm not sure and don't want to add another critical part, what do you
> think, is the reaction
> if insert/update shall be performed? Stop of the transaction with rollback?
>
> Thx
> Joh
You seem to suggest to restore the datafiles while the database is
operational.
Unless the datafiles go to a different location, you are definitely
going to screw up everything. If the datafiles go to the original
location, the database needs to be DOWN! I'm flabbergasted why you
think otherwise.
--
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Wed Apr 17 2002 - 02:44:14 CDT
