How to Enable ARCHIVELOG Mode for the Oracle Database
The archive mode, also known as ARCHIVELOG mode, instructs an Oracle database to automatically save a copy of its redo logs. Those logs contain a list of all the changes that are made to a database. Enabling the ARCHIVELOG mode can be particularly useful when trying to troubleshoot a specific issue related to your database. You can enable ARCHIVELOG mode using the Oracle console.
Other People Are Reading
Instructions
-
-
1
Open the Oracle console. Depending on the software you use to manage your Oracle database, you might access the console by entering a specific address in your Internet browser or launching a dedicated application such as the Oracle Enterprise Manager Console.
-
2
Type "startup mount" without quotes in the console and press "Enter." This will put your Oracle database in mount mode without actually opening it. Databases that are currently open can not be switched to ARCHIVELOG mode.
-
-
3
Enter "alter database archivelog;" in the console and press "Enter" to enable ARCHIVELOG mode.
-
4
Type "alter database open;" and press "Enter" to load and open the database.
-
1
