Oracle : Setup ArchiveLOG mode

Archive logging is essential for production databases where the loss of a transaction might be fatal. It is generally considered unnecessary in development and test environments. A general view on a database oracle Instance is Like below :


Setup Destination Folders for Archivelog in Initialisation File :


Validate Parameters files by restarting the database :


Now it is time to activate Archivelog Mode and verify that it is setup in place :


Notice the oldest log sequence online after the switch command. In the destination files you see archive created by forcing alter switch on control log sequence Files.



Since 30 years I work on Database Architecture and data migration protocols. I am also a consultant in Web content management solutions and medias protecting solutions. I am experienced web-developer with over 10 years developing PHP/MySQL, C#, VB.Net applications ranging from simple web sites to extensive web-based business applications. Besides my work, I like to work freelance only on some wordpress projects because it is relaxing and delightful CMS for me. When not working, I like to dance salsa and swing and to have fun with my little family.

You may also like...