Status:
1. Invalid- File not accessible
2. Stale- File contents are incomplete.
3. Blank- File is in use.
Drop the log member and recreate one using folowing command...
ALTER DATABASE ADD LOGFILE MEMBER
'' TO GROUP n;
where n is your logfile group number.
Hope it helps...
Sandy




Reply With Quote