OraFAQ Forum: Server Administration » Media Recovery (ORA-01113)

Home » RDBMS Server » Server Administration » Media Recovery (ORA-01113)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Media Recovery (ORA-01113) [message #134869]

Sun, 28 August 2005 11:52

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.

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134870 is a reply to message #134869]

Sun, 28 August 2005 11:58

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hi,
Open SQL* Plus, connect as sysdba.
Do the following:

SQL> SHUTDOWN
SQL> STARTUP MOUNT
SQL> RECOVER DATABASE
SQL> ALTER DATABASE OPEN;

I hope that your problem will be solved this way.

Regards.

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134872 is a reply to message #134870]

Sun, 28 August 2005 12:21

A.Mohammed Rafi
Messages: 15
Registered: September 2004

Junior Member

Hai,

Thanks for your kind help.

When I issued the command given by you the following message appears,

SQL> shutdown;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
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.
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1: 'E:\ORACLE\ORADATA\TEST\REDO03.LOG'

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORACLE\ORADATA\TEST\USERS01.DBF'

Still the problem exists.

Please help me to proceed further.

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134873 is a reply to message #134872]

Sun, 28 August 2005 12:35

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

which operating system you'r using?

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134874 is a reply to message #134873]

Sun, 28 August 2005 12:36

A.Mohammed Rafi
Messages: 15
Registered: September 2004

Junior Member

Microsoft Windows 2000 Professional [Version 5.00.2195]

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134875 is a reply to message #134874]

Sun, 28 August 2005 12:41

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Did you remove something from your computer by add/remove programs?
I'm afraid that your database is corrupted.
Can ou check if you can restore your operating system to a previous stage where it was working properly?
If yes then restore the operating system to that stage and then repeat the above mentioned process again.

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134876 is a reply to message #134875]

Sun, 28 August 2005 12:48

A.Mohammed Rafi
Messages: 15
Registered: September 2004

Junior Member

I use to install some programs and while uninstall I never use to delete the shared dll which is asked during the uninstall process.

Could you guide me in this process of restoring the OS to previous stage when it was working fine with oracle ......

Do you think is it the only solution.

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134878 is a reply to message #134876]

Sun, 28 August 2005 13:12

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hi,
Even if you don't delete these dlls, you can face this problem after uninstalling a particular program.
I checked with your operating system but there is no option to restore the operating system to a previous working stage. Under windows XP we have this option.
I don't think that this is the only solution. There may be another solution. This RECOVER DATABASE command should work.
Can you restart your computer and then close all Oracle services and restart the services again and run these commands?

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134879 is a reply to message #134878]

Sun, 28 August 2005 13:14

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Can you check this command as well.....
RECOVER MEDIA

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #134936 is a reply to message #134879]

Mon, 29 August 2005 02:36

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

incomplete recovery of your database is possbile. Use cancel/time based incomplete recovery & then open database with resetlogs option.

Regds
Girish

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #135048 is a reply to message #134878]

Mon, 29 August 2005 11:41

A.Mohammed Rafi
Messages: 15
Registered: September 2004

Junior Member

As you said I restarted the machine and the closed all the services and then started the services. Then I issued the commands and the output is shown below :

SQL> shutdown;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
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.
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1: 'E:\ORACLE\ORADATA\TEST\REDO03.LOG'

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORACLE\ORADATA\TEST\USERS01.DBF'

Still the problem exists........

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #135049 is a reply to message #134936]

Mon, 29 August 2005 11:42

A.Mohammed Rafi
Messages: 15
Registered: September 2004

Junior Member

thanks for your help.

could you please let me know the steps to proceed.........

Report message to a moderator

Re: Media Recovery (ORA-01113) [message #135113 is a reply to message #135049]

Tue, 30 August 2005 00:18

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

Instead of using recover database command use recover databse until cancel. After that issue command: alter database open resetlogs.

Regds
Girish

Report message to a moderator

Previous Topic:	Oracle Releasing locks very slowly
Next Topic:	ORA-1207 (8.1.7)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 11:16:58 CST 2025