DBA RAC Tips Best Practice Guidelines for Standalone and RAC Databases

DBA  RAC Tips : Best Practice Guidelines for Standalone and RAC Databases

•  Use SPFILE

•  Use temporary tablespaces

•  Register all instances with remote listeners

•  Use Database Resource Manager

•  Use resumable space allocation

•  Use Automatic Segment Space Management

•  Use locally managed tablespaces

•  Use Automatic Undo Management

•  Enable block checking

•  Enable Flashback Database

•  Enable ARCHIVELOG mode and use a flash recovery area

•  Use auto-tune checkpointing

•  Log checkpoints to the alert log

•  Multiplex production and standby redo logs

•  Set CONTROL_FILE_RECORD_KEEP_TIME long enough

•  Create two or more control files