Step-by-step DBA guides for Oracle, PostgreSQL, MySQL and SQL Server

How to use this guide

  1. Pick your databaseOracle, PostgreSQL, MySQL or SQL Server.
  2. Pick a topicArchitecture, install, patching, backup and more.
  3. Open a guideFollow the steps, then copy the commands.

Test on a non-production system first. Guides marked "Makes changes" modify the server or its data.

Popular guides

Daily DBA checklist
  1. Confirm the database and listener/service are up.
  2. Check last night's backup finished and passed verification.
  3. Review free space on data files, logs and disks.
  4. Look for long-running, blocked or failed sessions and jobs.
  5. Scan the error log and alerts for new warnings.
  6. Check replication or standby lag.