<div>
<a href="http://download.oracle.com/docs/cd/B13789_01/server.101/b10755/dynviews_1128.htm" rel="ugc">The docs</a> say it's because &quot;the file is in use&quot;, it's the most normal thing in all my DBs too, nothing to worry about:<br />
<br />
Status of the log member:<br />
<br />
INVALID - File is inaccessible<br />
<br />
STALE - File's contents are incomplete<br />
<br />
DELETED - File is no longer used<br />
<br />
null - File is in use
</div>


<div>
you are perfectly right...<br />
status won't work in v$logfile..<br />
ok in v$log..
</div>


<div>
<div class="content wysiwyg-content">
could please tell me my redolog file status files are blank..<br />
SQL&gt; select status from v$logfile;<br />
<br />
STATUS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
------- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
</div>
</div>


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

The docs (http://download.oracle.com/docs/cd/B13789_01/server.101/b10755/dynviews_1128.htm) say it&#39;s because &quot;the file is in use&quot;, it&#39;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&#39;s contents are incomplete

DELETED - File is no longer used

null - File is in use

you are perfectly right...
status won&#39;t work in v$logfile..
ok in v$log..

v$logfile

could please tell me my redolog file status files are blank..
SQL&gt; select status from v$logfile;

STATUS                                                                          
-------                                                                         
                                                                                
                                                                                
                     

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.