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:
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:
You can close this tool using the following command:
Verifying the settings
To verify, that the database mode is configured correctly (as ARCHIVELOG) run the following command:
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:
Now, verify that the database mode has changed successfully using the following command:
Last updated