💥 How to Enable Archive Log Mode in Oracle Database (Step by Step)


 💥 Intro: Explain why ARCHIVELOG mode is important (for backups, Data Guard, recovery).

Steps:


1. Connect as sysdba.



2. Shutdown immediate.



3. Startup mount.



4. ALTER DATABASE ARCHIVELOG;



5. Open database.



6. Verify with ARCHIVE LOG LIST;.

Conclusion: Enabling archivelog is critical for production databases.





---

Comments