Re: 200% reliable media => NOARCHIVELOG ??

From: <jpope_at_mojo.europe.dg.com>
Date: Thu, 25 Aug 94 09:56:56 GMT
Message-ID: <1994Aug25.095656.12402_at_mojo.europe.dg.com>


Gordon Hollingworth (gordon_at_crystal.dircon.co.uk) wrote:

: Alex Stebletsov <alex_at_ncbol.msk.su> wrote:
: >> if I have 200% reliable media (like failt-tolerant RAID), i.e.
: >> media failures are absolutely impossible, may I operate
: >> Oracle in NOARCHIVELOG mode ?? (considering Oracle 6)
 

: Better to be safe than sorry. Even if I had 5000% reliable media, I would
: always run in ARCHIVELOG mode. It helps to have something in addition to fall
: back on.
 

: Best Regards,
: Gordon Hollingworth
: Oracle DBA/UNIX Admin.
: --
: gordon_at_crystal.dircon.co.uk
: +-----------------------------------------------------------------+
: | The Crystal Tower, Enfield, London 081-447-8244 V21-V32bis,HST |
: | InterNet: crystal.dircon.co.uk FidoNet: 2:254/220 |
: +-----------------------------------------------------------------+

This may protect you against media failure, but how about human failure?

I know this doesnt happen too often, but if someone comes to you and says 'I've just accidentally deleted some important tables' - how do you propose to get them back?? Only with your archived redo logs of course ... Received on Thu Aug 25 1994 - 11:56:56 CEST

Original text of this message