DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 'stale' redo log files

  1. #1
    Join Date
    Dec 2002
    Posts
    18

    'stale' redo log files

    Hi all,

    Is the 'STALE' status of the redo log files in V$LOGFILE critical?

    Just curious,
    Thanks,
    toshi

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    This status means the logfile contains incomplete redo info. This status prevents the logfile from being dropped without being archived first. You should not worry about this status unless it happens repeatedly. Becuase "stale" does not mean "invalid". When this redo group becomes current, this state will automatically become valid.
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    Sometimes when you restart your db or newly created log group, v$logfile will show 'STALE' status. One easy way to check is issuing:

    alter system switch logfile;
    then check v$logfile again.

    The 'STALE' status' should disappear.

  4. #4
    Join Date
    Dec 2002
    Posts
    18

    Thumbs up

    thank you all for your replies

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