Change Non-archive Oracle data to archive

Resolution: The 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 and save the database when there is a problem with the database. However, when you build a database, you can find that the database is not archived. in this case, you need to archive the database. The modification method is very simple, but it must be

Resolution: The 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 and save the database when there is a problem with the database. However, sometimes the database is created and it is found that the database is not archived. in this case, you need to change it to archive. The modification method is very simple, but it must be

Resolution: The 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 and save the database when there is a problem with the database. However, sometimes the database is created and it is found that the database is not archived. in this case, you need to change it to archive. The modification method is very simple, but you must note that you cannot modify it when the database is running. you need to stop the database first, then mount the data control file, and then modify it to the archive mode, finally, start the data file so that the database is fully started. The steps are 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