Change non-archive Oracle database to archive Oracle Database

Archive mode is very important in the real production environment of Oracle. You can use archive mode for hot backup, and then quickly recover data when a database problem occurs, saving the database. But sometimes the database is built, and it is found that the database is not archived. In this case, we need to change it to archive. How should we change it.

In fact, the modification is quite simple, but you must remember that you cannot modify it when the database is running. You must first stop the database, then mount the data control file, and then modify it to the archive mode, finally, start the data file to make the database fully started. The procedure is as follows:

First, stop the database and then mount the database.

Startup Mount

Then change the archive mode.

Alter   Database Archivelog

Then start the data file.

Alter   Database   Open

In this way, our database is successfully changed from non-archive mode to archive mode.