Database not open: queries allowed on fixed tables/views only Error
<p>**My oracle database error due to electricity problem and pc shutdown during importing database **  My DB Version 10.2.0  </p>

<pre><code>ORA-01219: database not open: queries allowed on fixed tables/views only
</code></pre>

<p>I tried possible solution found on <a href="https://stackoverflow.com/questions/22940636/ora-01219-database-not-open-queries-allowed-on-fixed-tables-views-only">Stackoverflow</a> but no luck</p>

<p>Here what I try on SQLplus</p>

<pre><code>SQL&gt; shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQL&gt; startup mount
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                  1250380 bytes
Variable Size             167775156 bytes
Database Buffers          427819008 bytes
Redo Buffers                7135232 bytes
Database mounted.

SQL&gt; select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL&gt; alter database open;
alter database open
*
ERROR at line 1:
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\NRAT\REDO03.LOG'
</code></pre>

<p>Why this error and how can I solve this? Please help</p>