This section deals with the choices a DBA (as part of a team) must make to provide as much uptime as possible for an Oracle database. Consider this section to be essential in providing quality service and data protection for your customers. Each new version of Oracle provides an ever-deepening pool of features to maximize the availability of the database that comes as standard with the Enterprise License. These are the items that will be covered in the following section:
Archivelog mode
Database compatibility parameter and apfile, pfile management
Storage—RAID, SAME, ASM, OMF
Mirrored files—control files, redo logs
Autoextending data files with MaxSize
Auditing, log files, and Max Dump File Size
Data Dictionary Healthcheck
SQL*Net hardening, tuning, and troubleshooting
At this point, it is time to remind you about documenting changes to the database—start a formal logging procedure whether it is a spreadsheet, Wiki log, or Word document. Start a system...