Switching between Oracle archive mode and non-archive mode

Oracle never archives logs to archive log:

sql> shutdown immediate;

The database is closed.

The database has been uninstalled.

The Oracle routine has been closed.

sql> startup Mount;

The Oracle routine has been started.

The database is loaded.

sql> ALTER DATABASE Archivelog;

The database has changed.

sql> ALTER DATABASE open;

The database has changed.

Create an archive path (Oracle installation user right), for Linux environments, created under root or Oracle database installation User:

After logging in to the database, use the following command to modify the path:

Sql>alter system set log_archive_dest_1= ' Location=/oracle/app/arch ' scope =both; (Modify archive path)

sql> archive log list; (see if the archive path was modified successfully)

Oracle changes from archived logs to non-archived logs:

Sql>archive log list;

sql> shutdown immediate;

The database is closed.

The database has been uninstalled.

The Oracle routine has been closed.

sql> startup Mount;

The Oracle routine has been started.

The database is loaded.

sql> ALTER DATABASE Noarchivelog;

The database has changed.

Sql>archive log list;

sql> ALTER DATABASE open;

The database has changed.

Switching between Oracle archive mode and non-archive mode