What do the values in this column indicate:
Particularly 'STALE' & 'INVALID'?
I added a logfile member to a logfile group and it was created with a Status of 'Invalid'.
Printable View
What do the values in this column indicate:
Particularly 'STALE' & 'INVALID'?
I added a logfile member to a logfile group and it was created with a Status of 'Invalid'.
INVALID means that the file is inaccessible, STALE means that the file's contents are incomplete.
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
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
'./oracle/redolog/redolog2_02' TO GROUP n;
where n is your logfile group number. (Redolog member name with full path given here is sample, see with your scenario)
Hope it helps...
Sandy