Here we have mentioned some of the Oracle database best practice for standalone as well for RAC database. It will give value add to your setup.
- 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
