Changing the database mode

This article contains information, on how to change the Oracle database mode.

How to change Oracle database mode?

Executing the following operations will result in the temporary unavailability of the Oracle database environment.

You can find more information about the changing database mode in:

Database 2 Day DBA

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

sqlplus / as sysdba

You can close this tool using the following command:

QUIT;

Verifying the settings

To verify, that the database mode is configured correctly (as ARCHIVELOG) run the following command:

SELECT LOG_MODE FROM v$database;

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

Changing the database mode

You can change 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 changed successfully using the following command:

SELECT LOG_MODE FROM v$database;