Changing Oracle database mode

This article describes how to change the Oracle database mode.

Executing the following operations will temporarily make the Oracle database environment unavailable.

Prerequisites

Before starting the Oracle database backup task, make sure that the database mode is set to ARCHIVELOG. To verify that the mode is configured correctly or to change it, open the command line as the user configured in the backup plan and run the sqlplus tool using the following command:

sqlplus / as sysdba

You can then close this tool using the QUIT; command.

---

Verifying the settings

To verify that the database mode is correctly set to ARCHIVELOG, run the following command:

SELECT LOG_MODE FROM v$database;

Incorrect database mode example.

If the database mode is set to NOARCHIVELOG, change it to ARCHIVELOG.

---

Changing the database mode

You can switch the database mode from NOARCHIVELOG to ARCHIVELOG using the following commands:

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

QUIT;

Now, verify that the database mode has been changed successfully by running the following command:

SELECT LOG_MODE FROM v$database;

---

Useful links and items

Database 2 Day DBAdocs.oracle.com