Home » RDBMS Server » Backup & Recovery » Media Recovery (ORA-01113)
Media Recovery (ORA-01113) [message #134871] Sun, 28 August 2005 12:15 Go to next message
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.
Re: Media Recovery (ORA-01113) [message #134911 is a reply to message #134871] Mon, 29 August 2005 00:00 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


1. Is ur database is in Archive log mode or not ??


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

2. dont u need this file any more ?


This discussion might help u

http://www.orafaq.com/forum/m/131262/72347/#msg_131262

If it doesnt then clarify the above .


regards,
tarun
Re: Media Recovery (ORA-01113) [message #134940 is a reply to message #134911] Mon, 29 August 2005 02:43 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
if Db in archivelog mode, then use command recover database at the mount stage. That should resolve the issue for you.

Regds
Girish

Previous Topic: Rman
Next Topic: Answer to Question --Practically How to work with RMAN?
Goto Forum:
  


Current Time: Fri Mar 29 07:31:52 CDT 2024