During your DBA career lifetime, how many times you faced a problem on a database and you tried to find out the recent implemented changes on this DB?
It is crucial for DBAs –whether they work separately or in a team to track their own technical activities in one journal; this not only sounds professional, but also critical to keep a log of all DB changes and maintenance activities.
This template can help you track your technical activities in a simple and quick way:
Example of how I use it:
All you want to do is to customize this template to be compatible with your database environments; you need to fill these sections at the bottom of the sheet with databases and DBA names:
Under “Change Type list” I’ve listed the most common DBA activities, feel free to amend or add more activities.
Cleanup Logs on Oracle RAC 12c+