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.