Oracle DBA

Backup, Recovery & Flashback

Question

ARCHIVELOG versus NOARCHIVELOG mode: what recovery capability differs?

Answer

ARCHIVELOG preserves filled online redo for media and point-in-time recovery. NOARCHIVELOG reuses redo without archiving it, limiting recovery to backups taken after a clean shutdown. Use ARCHIVELOG for production recoverability.

This is 6 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples