Error on connecting to Oracle, only sys as sysdba could connect but wih no access to objects. If I tried to shutdown I got this message.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
On starting up I get the following.
SQL> startup
ORACLE instance started.
Total System Global Area 496049544 bytes
Fixed Size 454024 bytes
Variable Size 209715200 bytes
Database Buffers 285212672 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01113: file 148 needs media recovery
ORA-01110: data file 148: 'H:\ORACLE\ORADATA\CALLS_TAB38.DBF'
It seems one of the data files was corrupt.
Solution
========
SQL>shutdown
SQL>startup mount
SQL>recover database
SQL>alter database open;
Thursday, March 12, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment