Table of Contents

About

Oracle Database lets you save filled groups of Oracle Database - Redo Log (Transaction Log Files) files to one or more offline destinations, known collectively as the archived Oracle Database - Redo Log (Transaction Log Files), or more simply the Oracle Database - Mode Archive Log / Archiving. The process of turning redo log files into archived redo log files is called archiving. This process is only possible if the database is running in ARCHIVELOG mode.

When you run your database in ARCHIVELOG mode, you enable the archiving of the redo log : the Oracle Database - Mode Archive Log / Archiving.

Data Dictionary

select   
   thread#, 
   sequence#,
   applied,
   to_char(first_time,'DD-MON-YY:HH24:MI:SS') "First Time",
   to_char(next_time,'DD-MON-YY:HH24:MI:SS') "Next Time"
from      
   v$archived_log;

Reference