Oracle log status

OracleDatabase Log status

We queryV $ logThe view shows the log status.

SQL> select group #, ARCHIVED, status fromv $ log;

 GROUP # ARC STATUS

-----------------------------

1 NO CURRENT

2 YESINACTIVE

3 YES ACTIVE

 

CurrentIndicates the currently used log file, which is active.CurrentLogs are required.

ActiveIndicates the status of the active log. The log may be archived or not archived.

InactiveIndicates that the log is inactive. This log is not required when the instance is restored, but is used when the media is restored.

UnusedIndicates that the log may have been added but not used.

SQL> alter system switch logfile;

 

System altered.

 

SQL> select group #, ARCHIVED, status fromv $ log;

 

GROUP # ARC STATUS

-----------------------------

1 YES ACTIVE

2 NOCURRENT

3 YES ACTIVE

 

SQL> alter system switch logfile;

 

System altered.

 

SQL> select group #, ARCHIVED, status fromv $ log;

 

GROUP # ARC STATUS

-----------------------------

1 YES ACTIVE

2 YESACTIVE

3 NO CURRENT