<div>
Your database isn't 'open'.
</div>


<div>
I tried to open database like this..<br />
<br />
still shows error<br />
<br />
SQL&gt; alter database open;<br />
alter database open<br />
*<br />
ERROR at line 1:<br />
ORA-01172: recovery of thread 1 stuck at block 57 of file 3 <br />
ORA-01151: use media recovery to recover block, restore backup if needed 
</div>


I tried to open database like this..

still shows error

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 57 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed

<div>
recover database;<br />
Media recovery complete;<br />
alter database open;<br />
<br />
Data base is working perfectly fine;<br />
<br />
Thanks a lot dear expert..
</div>


recover database;
Media recovery complete;
alter database open;

Data base is working perfectly fine;

Thanks a lot dear expert..

<div>
<div class="content wysiwyg-content">
I &nbsp;could not figure out the error.<br />
SQL&gt; select * from dba_data_files;<br />
select * from dba_data_files<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; *<br />
ERROR at line 1:<br />
ORA-01219: database not open: queries allowed on fixed tables/views only <br />
<br />
<br />
SQL&gt; spool off
</div>
</div>


I  could not figure out the error.
SQL> select * from dba_data_files;
select * from dba_data_files
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only 


SQL> spool off

dba_data_files

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.