Archive Log Enabling in Oracle Database with Examples

Enabling Archive Logging

Archive logging is necessary in order to guarantee that a full recovery is possible.

In the init.ora file, add:

LOG_ARCHIVE_DEST = /data5/archive
LOG_ARCHIVE_FORMAT = arch%s.arc
LOG_ARCHIVE_MAX_PROCESSES=2

Shut down the Oracle instance.

In server manager:

> connect
> startup mount
> alter database archivelog
> alter database open
> shutdown immediate


Run a complete cold backup - this sets the starting point 
if a restore is needed.