Archive log mode in Oracle Database
📄 Video Description:
Learn how to enable Archive Log Mode in Oracle Database with this easy step-by-step guide. Archiving is crucial for database recovery, RMAN backups, and high availability systems.
Full Video: • Oracle database mode change noarchivelog t...
In this tutorial, you’ll learn:
✅ What Archive Log Mode is
✅ Why it’s important for backup and recovery
✅ How to check if it's enabled
✅ How to enable archive logging (using SQL*Plus or Oracle Enterprise Manager)
🧠 Suitable for: Oracle DBAs, students, and IT professionals working on Oracle 11g, 12c, 19c, or later.
🧰 Commands Used in the Video:
-- Check archive log status
archive log list;
-- Shutdown database
shutdown immediate;
-- Mount the database
startup mount;
-- Enable archive log mode
alter database archivelog;
-- Open the database
alter database open;
-- Verify
archive log list;