topic Re: missing data file in Operating System - HP-UX

missing data file

George_Dodds — Tue, 21 May 2002 10:20:55 GMT

when trying to start up oracle database i keep being advised that file 6 is missing.
This database is used by ITO.

The tape that would have had that file on is long gone as this server has not been used in a while.

Is there a way of clearing out all of the ito alerts that are in the database so i can start from scratch?

os hpux 11

oracle ver 8.0.6

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 11447272 bytes
Fixed Size 52200 bytes
Variable Size 6811648 bytes
Database Buffers 4505600 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '/u01/oradata/openviewd/OPC_1_1.dbf

Re: missing data file

T G Manikandan — Tue, 21 May 2002 10:31:52 GMT

First of all check whether your /u01 file system is mounted and the datafile is there.

svrmgrl>shutdown
svrmgrl>recover database;

Thanks

Re: missing data file

T G Manikandan — Tue, 21 May 2002 10:33:09 GMT

Sorry

svrmgrl>shutdown
Now mount the database using
svrmgrl>startup mount
svrmgrl>recover database;

Thanks

Re: missing data file

George_Dodds — Tue, 21 May 2002 11:06:41 GMT

T.G. cheers for the info, recovery started fine but received erros at the end.

Any ideas?

ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [29360198], [1], [5035], [305
2], [32], [],

Cheers

George

Re: missing data file

T G Manikandan — Tue, 21 May 2002 11:51:09 GMT

Do you have a backup of that datafile.

You can open the database
by starting the database,bringing the datafile offline and opening the database.
I am not sure what that particular datafile contains.Might be some useful information for OV.

Let's try this
svrmgrl>startup mount
svrmgrl>alter database datafile 'datafile-name' offline
svrmgrl>alter database open;

Then we will try restoring that speific datafile
svrmgrl>alter database recover datafile 'datafile-name'
svrmgrl>alter database datafile 'datafile-name' online

Just post the log.

Re: missing data file

George_Dodds — Tue, 21 May 2002 11:59:26 GMT

Unfortunatley i dont have an up to date backup of the data file as the backup dlt's were pillaged when the server was taken out of production.

I do have a couple of old backup tapes with the file on but that all.

Maybe i might have to reintstall the database.

Ta

George

Re: missing data file

T G Manikandan — Tue, 21 May 2002 12:04:39 GMT

Try using the above procedure eventhough you do not have backup of that datafile.
If that specific datafile is corrupt we can drop it and re-create it.
First try opening your database making that datafile offline.

Re: missing data file

Volker Borowski — Tue, 21 May 2002 12:06:11 GMT

Hi,

I found a SAP note for an ORA-600[3020]
The solution states to start over the recovery from scratch and since you have no tapes, I guess there will be no luck for you.
I think you will need to reinstall the application.

Sorry
Volker
------------------------
During database recovery, an ORA-600 [3020] occurs and the recovery process stops.

Oracle writes a change phasor for every modification of a data block to the Online redo log file. To synchronize the change phasors with several modifications, a change number (version number) is incremented for every block.

If you now try to import a change with the number 453 during the recovery when the block in fact has the version number 451, the recovery stops with ORA-600 [3020] since it assumes that one or more changes are
missing.
The error can be caused by hardware problems and affects both redo log files and database files.

Re: missing data file

George_Dodds — Tue, 21 May 2002 12:52:45 GMT

Got a feeling i'm going to have to do the same for the other .dbf files as it came up saying that another one needs media recovery.

Never mind i'm learning lots more than i did about oracle Thanx T G :)

Dont worry Volker if worst comes to worst i'll hit it with a big hammer then reinstall but at least i get to play in the meantime.

Cheers

George

Re: missing data file

T G Manikandan — Tue, 21 May 2002 13:20:00 GMT

Hello,
Also post your alert.log file for your recovery.

Thanks
G Manikandan

Re: missing data file

George_Dodds — Tue, 21 May 2002 13:40:25 GMT

Will do as soon as i find it!

Cheers

George

Re: missing data file

T G Manikandan — Wed, 22 May 2002 04:58:34 GMT

Re: missing data file

steven Burgess_2 — Wed, 22 May 2002 05:19:40 GMT

George

Nice hat!!

Steve

Re: missing data file

George_Dodds — Wed, 22 May 2002 09:57:08 GMT

HP are logged on playing with ito at the moment, as soon as they are finished i will get the info for you.

Cheers

George