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
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
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
SQL> recover database;
Media recovery complete.
SQL> alter database open;