| Media Recovery (ORA-01113) [message #134871] |
Sun, 28 August 2005 12:15  |
A.Mohammed Rafi
Messages: 15
Registered: September 2004
|
Junior Member |
|
|
Hai,
I installed oracle 9i database on my home pc it was working fine.
But since last week there was a problem.
When I use to login with learning\learning@test the following error occurs,
ORA-01033: ORACLE initialization or shutdown in progress
Then I logged in using sys/change_on_install as sysdba and then I shutdown the database and the instance was shutdown with the message given below,
SQL> shutdown normal;
ORA-01109: database not open
When I started the database in the sql prompt the following message appears,
SQL> startup;
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORACLE\ORADATA\TEST\USERS01.DBF'
The USER01.DBF is created by me during the installtion of the Oracle Designer and its size is 25 MB. Since there is no data backup is not necessary.
Please let me know how to rectify the above problem.
Thanks in advance.
With Warm Regards,
A.Mohammed Rafi.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
