Oracle Database
12c · 19cArchitecture, backup & recovery, PL/SQL, listener and instance internals.
- About Oracle Databasetutorial
- Backup & recovery with RMANtutorial
- Oracle Instance Recoverytutorial
- About SQL*Plustutorial
- About Oracle PL/SQLtutorial
Practical reference · written by a working DBA
Oracle & Unix,
with the scenarios
you actually hit in production.
Short, no-fluff guides on RMAN backup & recovery, PL/SQL, flashback, instance recovery, listener errors, and Oracle certification — drawn from real DBA work since 2014.
26
tutorials & scenarios
12c–19c
Oracle versions covered
~5 min
average read
10+ yrs
DBA experience behind every post
01 Browse by topic
Unix for DBAs
AIX · LinuxThe text-processing & shell skills every Oracle DBA needs day-to-day.
- About Unix for DBAstutorial
- Learn the
awkcommandslides - Learn the
sedcommandtutorial - vi editor — essentialstutorial
- Mail Excel/text from SQL*Plusscenario
Oracle Certification
OCA · OCPA working DBA's view of which path to pick and how to prep.
- Current Oracle DB certificationsguide
- Tips for OCA/OCP preparationguide
- DBA or PL/SQL — which path?guide
02 Featured scenarios All scenarios →
RMAN's MAXPIECESIZE, SECTION SIZE and MAXSETSIZE — what each actually controls
Three RMAN parameters DBAs reach for when backups don't fit, don't parallelize, or hit filesystem limits — with the smallest example that demonstrates each one.
scenario · oracle 12c +
Flashback techniques using UNDO
Recover a dropped row without restoring from backup — query, version, transaction.
scenario
Errors connecting via listener — a checklist
ORA-12154, ORA-12541, ORA-12514 — what each is really telling you.
scenario