2

**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

Community
  • 1
  • 1
Firefog
  • 3,094
  • 7
  • 48
  • 86

1 Answers1

2

It seems your REDOLOG it's not synced so you either recover from a backup, or maybe you have another REDOLOG file on group 3 and can overwrite 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\NRAT\REDO03.LOG' with that one. Since you were importing data, maybe you don't mind losing the latest modifications. In that case go for RESETOGS option alter database open resetlogs;. Please read the links carefully since some of this actions will make you loose data.

vercelli
  • 4,717
  • 2
  • 13
  • 15