Re: 200% reliable media => NOARCHIVELOG ??
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