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