Database Best Practice
Uncompromising Dedication to Core Tasks
In some environments projects can evolve into to an endless stream where sight is lost as to the most important database tasks. To ensure business\mission continuity your DBA resources need to attend to these core tasks before all others. Not allocating adequate resources to these is a mistake found in those environments where downtime and loss of revenue are acceptable. It is a good idea to review your database shop's workload routinely to make sure this foundation remains in place.
Core System DBA tasks:
- Database backups.
- Daily checks and routine monitoring of local and remote databases.
- Data synchronization technology required support (Data Guard, Streams etc.).
- Oracle database product patching.
- Disaster recovery testing.
For more Oracle articles and best practices go here.