database not open

[atanu]

Dear Sirs,

Problem : Database is not opened.

After entering the 'startup' command the following errors are showing.

ORA-01157: cannot identify data file 6 - file not found
ORA-01110: data file6: '/home/decsrv1/usr4/people/oracle/u01/app/oracle/product/8.0.4/dbs/datafile_mtech99'

The data file 'datafile_mtech99' is missing. Please, suggest me how to open the databse.

Thanks,

Atanu Basu.

[julian]

It looks like you will have to restore the file from backup first and recover.

[SANJAY_G]

What backup strategy do you follow for the database? The recovery will depend on what kind of backup do you have and whether you are running in ARCHIVELOG OR NOARCHIVELOG mode?

Sanjay

[atanu]

Originally posted by julian
It looks like you will have to restore the file from backup first and recover.

We have just started to use Oracle. No backup of the data file has been taken. We want only to run the database server with the existing data files.

[atanu]

Originally posted by SANJAY_G
What backup strategy do you follow for the database? The recovery will depend on what kind of backup do you have and whether you are running in ARCHIVELOG OR NOARCHIVELOG mode?

Sanjay

We have just started to use Oracle. No backup of the data file has been taken. We want only to run the database server with the existing data files.

[SANJAY_G]

If you are not worried about the lost data then do a offline drop on that datafile and you should be able to open the database.

Sanjay

[francisc]

if you dont't have a backup then
from server manager:

startup mount;
alter database datafile '/home/decsrv1/usr4/people/oracle/u01/app/oracle/product/8.0.4/dbs/datafile_mtech99' offline drop;
alter database open;