Tuesday, June 3, 2008

Redo Log File Status

Redo log file is very crucial for database recovery...and most of time we confuse about "status" of v$log file for redo log files.
1. UNUSEDWhenever you create any redo log file ...that time v$log view showing status "UNUSED"2. CURRENTAfter Creation when redo log "lgwr" process use that file ....that time v$log view showing status "CURRENT"3. ACTIVEIf database running in archivelog mode then after log switch "arch" process use log file and create archivelog file that time v$Log file view showing status "ACTIVE"4. CLEARINGWhenever any log file is corrupted or missing ( which is not "active" or not "current") then we use "alter database clear logfile" statement to recreate corrupted log file ... that time v$log view showing status "CLEARING" after clearing it is showing "UNUSED"5. INACTIVEDuring archivelog file creation v$log view showing status "ACTIVE" and when archivelog file is created then it is showing "INACTIVE" for particular one redo log file at a time.6. CLEARING_CURRENTIf any error occured during "alter database clear logfile" then v$log file view showing "CLEARING_CURRENT".

No comments: