Miscellaneous

ARCHIVE LOG MODE

How does one put a database into ARCHIVELOG MODE?

STARTUP MOUNT

ALTER DATABASE ARCHIVELOG;

ARCHIVE LOG START;

ALTER DATABASE OPEN;

The following parameters needs to be set for databases in ARCHIVELOG mode:

log_archive_start         = TRUE

log_archive_dest_1        = 'LOCATION=/arch_dir_name'

log_archive_dest_state_1  = ENABLE

log_archive_format        = %d_%t_%s.arc

This should allow you to open the database. However, after using this parameter your database will be inconsistent (some committed transactions may be lost or partially applied).

_allow_resetlogs_corruption = true

One can select from V$BACKUP to see which datafiles are in backup mode BEGIN/END.