Problem Description

When trying to access a table on a database I got the following error:

• ORA-01219: database not open: queries allowed on fixed tables/views only

I then opened an SQLPLUS window and tried to open the database and got the following errors:

• ORA-01172: recovery of thread 1 stuck at block 1949 of file 2
• ORA-01151: use media recovery to recover block, restore backup if needed

 

Solution

To solve the problem I mounted the database and ran SQL command "recover database;". I was then able to open the database and access the data. 

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  1253124 bytes
Variable Size             511705340 bytes
Database Buffers          553648128 bytes
Redo Buffers                7135232 bytes
Database mounted.


SQL> recover database;


Media recovery complete.


SQL> alter database open;

Database altered.