9.2.0.5 oracle database startup issue 1

[nyck]

I'm attempting to start one of my 9.2.0.5 databases and its failing with the following:-

sqlplus ' / as sysdba'

SQL*Plus: Release 9.2.0.5.0 - Production on Mon Jul 21 09:19:57 2008

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 270501320 bytes
Fixed Size 742856 bytes
Variable Size 234881024 bytes
Database Buffers 33554432 bytes
Redo Buffers 1323008 bytes
ORA-03113: end-of-file on communication channel

How can I get this database started?

 

[KenCunningham]

Is there anything in the alert log to indicate why this is happening? Has the database crashed recently?

I want to be good, is that not enough?

 

[nyck]

Below is from the alert log:-

Errors in file /ora1/app/oracle/admin/BSNLICS1/bdump/bsnlics1_lgwr_1634432.trc:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/tss_india/oracle/oradata/u2/BSNLICS1/control02.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 110: Media surface error

Not good, me thinks the database has had it, would you agree?

 

[KenCunningham]

It looks like you have a trashed disk - do you have a backup of the database and a support contract for the hardware?

I want to be good, is that not enough?

 

[stefanhei]

You should be able to get your db up and running again - there should be more control files in your db (normally 2 more) which you can use to replace your corrupted file once you have the hardwaretroubles done.

 

[nyck]

Yeah it looks like the disk is failing, we have no support on this particular server as its very old. I have advised the user that they let me dump the other databases and move them to a different server. Also we do not have the Legato modules as the company will not pay for them, so I need to look through the savegroups to see if there is a backup where the database is not being accessed.

 

[nyck]

Resolved the issue

I edited the config file for the failing database and removed the entry for the failing control file.

I have suggested that the user allows me to take a dump of all three databases and then import them onto a different oracle server as the current one is going to collapse in a heap any time now.

thanks for all the help

 

[KenCunningham]

Good news - well done!

I want to be good, is that not enough?