**My oracle database error due to electricity problem and pc shutdown during importing database ** My DB Version 10.2.0
ORA-01219: database not open: queries allowed on fixed tables/views only
I tried possible solution found on Stackoverflow but no luck
Here what I try on SQLplus
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> 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> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
SQL> 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'
Why this error and how can I solve this? Please help