Oracle High Availability Best Practices Summary
I have written on Oracle Maximum Availability Architecture(MAA) and 11g High Availability New Features before. Below is a quick reference prepared for 10g Release 2 single instance, RAC and standby instances;
- Multiplex redo log files,
- Use resumable space allocation - a simple example,
- Create at least two control files and multiplex them,
- Enable Flashback Database,
- Use Spfile,
- Use Automatic Undo Management,
- Use Automatic Segment Space Management,
- Use Locally Managed Tablespace Management,
- Use Locally Managed Temporary Tablespace Management,
- Enable Archivelog Mode,
- Use Flash Recovery Area,
- Resynchronizing the Recovery Catalog and setting time long enough for CONTROL_FILE_RECORD_KEEP_TIME parameter(default is 7 days),
- Specify a database default permanent and temporary tablespace other than SYSTEM and SYSAUX,
- Enable Block Checking,
- Use Auto-Tuned Checkpointing,
- Use Database Resource Manager,
- Log checkpoints to the alert.log,
..
All above practices, and much more of them you may comment, affect the performance, availability and mean time to recover(MTTR) of your database. For more information please read Oracle® Database High Availability Best Practices 10g Release 2 (10.2) Guide and Oracle® Database Backup and Recovery Advanced User’s Guide 10g Release 2 (10.2) Guide
