Backup & Recovery
Check ARCHIVELOG mode before you need to recover
Understand ARCHIVELOG and NOARCHIVELOG, check your database mode, and plan the switch before a recovery incident.
All articles
3 articles
SQL
Auto-increment in Oracle without a trigger: Identity Columns
Use Identity Columns in Oracle 12c and later instead of managing a sequence and trigger. Learn the three generation modes and what to check during migration.
DBA
Oracle STARTUP and SHUTDOWN: what happens at each stage?
Understand NOMOUNT, MOUNT and OPEN, the four shutdown modes, and why SHUTDOWN ABORT requires instance recovery.