How to Enable/Disable Archive Log Mode In 10g and 11g
(Doc ID 371139.1)
Last updated on JANUARY 08, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterOracle 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.
Goal
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.
NOTE:
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.
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.
Solution
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
Goal |
Solution |
References |