Convert Database to Archive Log Mode

Contents:- Convert database into Archive log mode, Archive Log Dynamic Performance View

Steps to Convert Database into Archive Log Mode

SQL> Select log_mode from v$database;

SQL> Shut Immediate

SQL > Startup Mount

SQL > Alter system set log_archive_dest_1='location=/+flash/archivelog';

SQL> Alter database archivelog

SQL> Alter Database open

SQL> Select Log_mode from v$database

SQL> Archive Log List

Archive Log Setting

Guaranteeing Archive Log Success

If you have specified more than one destinations for archive log files, you should specify minimum number of them are required to succeed in order for the archive to be considered successful. Do using LOG_ARCHIVE_MIN_SUCCEED_DEST to 2.  The online log file is not reused  until this number is met.

You can use this parameter with the log_archive_dest_n model, then this parameter can have values ranging from 1 to 10 and if you use this parameter model log_archive_dest then the values can be 1 or 2.

Mandatory and Optional

Mandatory: When you define the location then you can specify it mandatory

Ex: log_archive_dest_1=’location=/u01/app/archive mandatory’

If any mandatory destination fails, then oracle database considers the archiving of the log to have not succeeded and the online redo log files is not allowed to be overwritten.

The default is optional. 

Archive Log Dynamic Performance View

Sql> SELECT * FROM v$ARCHIVED_LOG;

Sql> SELECT * FROM v$ARCHIVE_DEST;

To Find Online (Archive Redo Log File)

SQL > select sequence#, member  from v$log l, v$logfile f  where f.group# = l.group#  order by 1;