After yet another post by someone whose database has crashed without running in archivelog mode and without having multiplexed redo logs, it makes me think it’s about time Oracle changed the default installation to include both these things.
Over the last few versions, Oracle have consistently made the database easier to install and use, but they still leave these gaping holes. Yes, archivelog mode is set if you choose to setup backups during the installation, but there’s nothing to stop you defaulting this setting even when backups are not initiated during the installation.
I realise some people will react by saying it’s up to the DBA to make this decision, but there are obviously lots of people out there that either don’t understand the issue, or don’t even know about it. It would seem sensible to me that Oracle install the product in the safest mode possible. Afterall, it’s no problem backing them out if you don’t need them.
I for one would rather have people complaining about disks filled with archived redo logs, than having unrecoverable databases.
Rant over. 🙂