Thanks for the question, Nilesh.
Asked: November 26, 2016 - 6:40 am UTC
Last updated: November 27, 2016 - 8:02 am UTC
Version: Oracle 11.2.0.2.0
Viewed 1000+ times
You Asked
Does archive of redo logs get completed when STATUS of redo log is active ? and what happens when STATUS of redo log is inactive in background ?
Scenario that i tried
Three groups of Redo log size 50mb each and Archiving is Enabled and inserted 670000000 records
and Connor said...
We need a little more precision on what you mean by "status".
1) STATUS on V$LOG
UNUSED - Online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log.
CURRENT - Current redo log. This implies that the redo log is active. The redo log could be open or closed.
ACTIVE - Log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It may or may not be archived.
CLEARING - Log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED.
CLEARING_CURRENT - Current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header.
INACTIVE - Log is no longer needed for instance recovery. It may be in use for media recovery. It may or may not be archived.
2) STATUS on V$ARCHIVED_LOG
A - Available
D - Deleted
U - Unavailable
X - Expired
Is this answer out of date? If it is, please let us know via a Comment