Tag Archives: Redo log files

Check the Redo log file archived Status

Check the Redo log file archived Status

Check database is in archive log mode

archive log list;

Check the redo log current status

select group#, thread#, sequence#, status, archived from v$log;

GROUP# THREAD# SEQUENCE# STATUS     ARC
------ ------- --------- ---------- ---
1      1       20        CURRENT    NO
2      1       18        INACTIVE   NO
3      1       19        ACTIVE     NO


Run the checkpoint command to write the archive data into datafile & status from active to inactive

alter system checkpoint;
select group#, thread#, sequence#, status, archived from v$log;

GROUP# THREAD# SEQUENCE# STATUS    ARC
------ ------- --------- --------- ---
1      1       20        CURRENT   NO
2      1       18        INACTIVE  NO
3      1       19        INACTIVE  NO

Check the Redo log are archived otherwise archive them

alter system archive log all;
select group#, thread#, sequence#, status, archived from v$log;

GROUP# THREAD# SEQUENCE# STATUS           ARC
------ ------- --------- ---------------- ---
1      1       20        CURRENT          NO
2      1       18        INACTIVE         YES
3      1       19        INACTIVE         YES