v$log : How redo log file can have a status ACTIVE and be already archived?
fcjunicJul 28 2010 — edited Jul 30 2010Hello all,
I would like to understand the difference between the STATUS of a redo log file and the fact that the redo log is already archived or not...
I read that active status means that "it is needed for instance recovery." But why is it needed for recovery if it is already archived ?
Can someone explain me ?
Thx.