Unable to connect to the database

[ankur_khare]

Our SAP instance had stopped as the dispatcher services had stopped.

During analysing we tried to connect to the database through SAPDBA..by normal stratup option,

But the following error occured.

SAPDBA: Trying to open instance PRD

using ALTER DATABASE OPEN ...

SQL*Plus: Release 9.2.0.3.0 - Production on Thu Dec 31 09:28:19 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected.

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-01113: file 11 needs media recovery

ORA-01110: data file 11: 'J:\ORACLE\PRD\SAPDATA1\PRD620_1\PRD620.DATA1'

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.3.0 - Production

SAPDBA: Error during start instance 'PRD'.

Press <return> to continue ...

HOW CAN THIS BE RESOLVED AND HOW CAN I CONNECT TO THE DATABASE

[former_member220071 · Accepted solution]

Hi

The problem might be with your Database

The error clearly show ORA-01113: file 11 needs media recovery

try to recover the system file by giving the following command

SQL> recover datafile 'J:\ORACLE\PRD\SAPDATA1\PRD620_1\PRD620.DATA1';

or try

"RECOVER DATABASE;"

Regards

Abhijeet

Edited by: Abhijeet Siras on Dec 31, 2009 4:53 PM

[ankur_khare · Accepted solution]

The Problem has been resolved.

The recover database worked . Only thing was I was not able to reach to the oracle SQL prompt as welll.

But the Nicks command help worked out.

Thanks everyone.

And yes Nick You were right the server had shutdown during the backup time.

[Former Member]

SQL> startup mount;

SQL> spool end_backup.sql

SQL> select 'alter database datafile '

|| file# || ' end backup;'

from v$backup where status = 'ACTIVE';

SQL> spool off;

SQL> @end_backup.sql

SQL> alter database open;

I hope you had a shutdown at the time of backup(refer SAP Notes4162 and 4161).

Regards

Nick Loy