Archived redo logs

When a database is running in archive log modus, Oracle requires that online redo logs be archived before they're overwritten by a log switch. The archiving happens either manually or automatically by the archiver process.

An online redo log is usually archived by arch. There are two ways to start arch: First by the init parameter log_archive_start. This requires a restart of the database. The second way is to manually start the archiver:

alter system archive log start

However, the archiver will not be started automatically the next time the database is started.

In order to manually archive the online redo logs, the following statement must be executed in mount status:

alter database archivelog manual;

The following command archives all redo log file groups that are full but have not been archived.

alter system archive log all;

See v$archive_dest.

See v$archived_log.