V$LOGFILE - Status column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: V$LOGFILE - Status column

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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'.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    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!"

  4. #4
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    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
  •  



Click Here to Expand Forum to Full Width