-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
"Greatest Rewards come only with Greatest Commitments!"
-
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
"Greatest Rewards come only with Greatest Commitments!"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|