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 :

archivelog01

Setup Destination Folders for Archivelog in Initialisation File :

 archivelog02

Validate Parameters files by restarting the database :

archivelog03

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

archivelog04archivelog05

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.

Cheers

extradrmtech

Since 20 years I work on Database Architecture and data migration protocols. I am also a consultant in Web content management solutions. I am an 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. When not writing code, I like to dance salsa and swing and have fun with my little family.

You may also like...