Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

October 11, 2007

Oracle High Availability Best Practices Summary

Filed under: Oracle Best Practices — H.Tonguç Yılmaz @ 12:00 am

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 allocationa 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


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: