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.