My Oracle Support Banner

How to Enable/Disable Archive Log Mode In 10g and 11g (Doc ID 371139.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


The goal of this document is to describe how to enable or disable archiving for version 10G and newer databases.

Currently your database is in NoArchive Log mode and you would like to turn Archiving on. You understand that Log_Archive_Start parameter is deprecated in 10g. You did not find any article for how to enable Archive log mode in 10g. All articles deal with 9i or earlier Oracle versions and talk about the 3 archive log mode parameters to be enabled.

Prior to changing the archive status of the database a clean backup should be accomplished after the database has been gracefully shutdown via shutdown normal or shutdown immediate.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.