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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.