Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REDO LOG Group status

User_JNHXJNov 15 2021

Hello all, im new to database administration and i wanted to know a little bit information about redo log group status
select status,group# from v$log;
STATUS GROUP#
---------------- ----------
INACTIVE 1
INACTIVE 2
CURRENT 3
above is the example of my redo log group status when opened the database
after that i do some couple of insert and i issue " alter system switch logfile;"

from what i know switching redo log file make the dbwr write the dirty buffer to buffer cache so why when i issue "select status,group# from v$log;" there is an active status on group# 3 instead of only current status on group# 1 ? does oracle only write the dirty buffer for redo log group with active status and not with current status?
STATUS GROUP#
---------------- ----------
CURRENT 1
INACTIVE 2
ACTIVE 3

please explain if my understanding about redo log status is wrong thank you.

Comments
Post Details
Added on Nov 15 2021
1 comment
751 views