How to Remove the Archive Log Mode From an Oracle Database

ARCHIVELOG mode allows online database backups.

Oracle produces an enterprise-quality series of database solutions for small to very large operations. Your database is valuable and must be protected in the event of hardware or software failures. ARCHIVELOG mode protects Oracle databases from not only operating system and software failure, but also disk failure, by preparing backups while the database is running. However, you may wish to disable ARCHIVELOG mode for your database.

Instructions

1. Perform a backup of the database before changing archiving parameters.

2. Verify the database log mode. Launch SQL*Plus by executing the command "sqlplus / as sysdba" from the command prompt. Execute the command "archive log list;" from the SQL prompt. The "Database log mode" paramater should be set to "Archive Mode" and "Automatic Archive" should be set to "ENABLED."

3. Shutdown all instances of the database by executing the command "shutdown immediate" from the SQL prompt.

4. Restart the database in mounted mode by executing the command "startup mount" from the SQL prompt.

5. Execute the command "alter database noarchivelog;" to disable ARCHIVELOG mode.

6. Open the database by executing "alter database open;" from the SQL prompt.

7. Executing "archive log list;" to verify that the parameters have been changed.

References

• Burleson Consulting: Disable Archive Log Mode
• Oracle FAQs: Oracle database Backup and Recovery FAQ
• Oracle Distilled: Enable/Disable Archive Log Mode 10g/11g