We help IT Professionals succeed at work.

Oracle 10g Issue "ORA-01242: data file suffered media failure:"

bml104
bml104 asked
on
Medium Priority
897 Views
Last Modified: 2012-05-12
We have a oracle database server that we can no longer get in. The service "oracleDBConsole" will not start.

in my alert file i have the following error

ORA-01242: data file suffered media failure:

When i login to sql plus it gives me the error

"ORA-01033: Oracle initialization or shutdown in progress"

Did I mention i have no future experiance with oracle?
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
>>Did I mention i have no future experiance with oracle?

Do you have Oracle Support?  If so please contact them!

Oracle has an alert log that logs all issues with the database.

On the database server, look under the Oracle installation folder.  There you should find an admin folder.

Under that a folder with the database name.  Under that a bdump folder.

Look for a file, depending on your OS, alert<DATABASE_NAME>.log

Open that with an editor and go to the bottom.  There should be some error stating why the database didn't start up.

Commented:
First, do you have a backup of the database ?  if so what type of backup ?  database export or cold backup ( with DB shutdown )
second, Is you database in ARCHIVELOG mode. ?  In which case do you have a Hot backup ( using RMAN, backup scripts,etc..) . Let me know this first...

Also, can you please do the following
1) logon to sqlplus as sysdba
2) run this statement and show the results.
   SELECT file#, status from v$datafile;
 
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
>>First, ...

first why don't we wait and see what the error in the alert log is.

Commented:
Yes...agreed..the contents of alert log first....Thanks !
Commented:
Sorry for the delay on this but it was a crazy week. I don't remember how i logged in to the database but it was some sort of safe mode. Once in i ran the following.

      sqlplus
      Enter user-name: system or sys / as sysdba
      Enter password: password
      SQL> shutdown abort
      SQL> shutdown
      SQL>startup mount
      SQL>recover database
      SQL>alter database open;
      SQL>exit

Author

Commented:
Someone sent me a script to resolve the issue