1748145 Members
3582 Online
108758 Solutions
New Discussion юеВ

Re: missing data file

 
SOLVED
Go to solution
George_Dodds
Honored Contributor

missing data file

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
13 REPLIES 13
T G Manikandan
Honored Contributor

Re: missing data file

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


svrmgrl>shutdown
svrmgrl>recover database;

Thanks



T G Manikandan
Honored Contributor
Solution

Re: missing data file

Sorry

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

Thanks
George_Dodds
Honored Contributor

Re: missing data file

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
T G Manikandan
Honored Contributor

Re: missing data file

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.
George_Dodds
Honored Contributor

Re: missing data file

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
T G Manikandan
Honored Contributor

Re: missing data file

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.
Volker Borowski
Honored Contributor

Re: missing data file

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.
George_Dodds
Honored Contributor

Re: missing data file

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
T G Manikandan
Honored Contributor

Re: missing data file

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

Thanks
G Manikandan