v$logfile

could please tell me my redolog file status files are blank..
SQL> select status from v$logfile;

STATUS                                                                          
-------                                                                        
                                                                               
                                                                               
                     
nobleitAsked:
Who is Participating?
 
Franck PachotCommented:
Hi,
The status you're interrested in is probably the one in v$log. v$logfile shows the members - all the same.
Regards,
Franck
0
 
AkenathonCommented:
The docs say it's because "the file is in use", it's the most normal thing in all my DBs too, nothing to worry about:

Status of the log member:

INVALID - File is inaccessible

STALE - File's contents are incomplete

DELETED - File is no longer used

null - File is in use
0
 
nobleitAuthor Commented:
you are perfectly right...
status won't work in v$logfile..
ok in v$log..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.