Databse recovery

[samahit]

I have a database which operate in no archivelog mode(oracle7.1 and unix(svr4).Today morning when I started the database from sql*dba ,Following things has happened.

The databse got mounted after that the sqldba prompt never came ,I logged in as another OS user and checked the altet log file it is showing datafile no17 is not found at this time,rename it properly,now my problem is since I don't know which is the datafile no 17.
I took the backup control file to trace,Physically I checked each file from control file exists in the OS.
I donot have a backup.
I killed the other process where I had given startup command
.Then again I logged on and shutdown.after shutdown it is closing the database,then dismounted then instance got closed.I don't understand when the databse not opened,why it is showing this.how to recover from this.
if anybody is having any idea pl.let me know
thanks.
If anybody is not clear of above scenario then pl. write back.I will give the details

[vinit]

Have you checked if there are any files physically missing or if all are available ?
Since your database is not in archivelog mode you can do only 2 things

1. Restore all control , redo and datafiles from a previous cold backup and start entering data since then.

2. Do an offline drop of the tablespace to start your db. You will loose all data pertaining to that tablespace.

[samahit]

Yes I have checked all datafiles are there in place.Problem is I don't have any backup.How do I rename one datafile which is there in data dict. not in control file.Since I have to drop that data file after opening the database.the mis0017 file to be renamed properly and should be taken offline drop in mount stage.I belive the check piont number is same in all control ,data and redo.so no need to restore from last backup.
any idea?

[vinit]

First take a complete backup of all files.
Try to re-create your controlfiles and include your datafile 17. Then try to mount your db. Get back on the status.

[anandkl]

Mount ur database and query v$datafile to get a list of available datafile and check it with ur controlfile backedup to trace.
This query will give you the name of the datafile as well as the datafile no.With this result you will be able to know which files are missing and ur can add them by with alter database add datafile.
First take a backup of ur database.

cheese
anandkl

[samahit]

I belive v$datafile gives the record from control file,I have checked the control file to trace,it gives the exact number of file with v$datafile,only by checking altet file I could able to trace the data file 17 is missing ,how do I know the exact name of the datafile 17.is it possible.

I cannot recreate the control file with that missing file name as I donot know the exact file name .

[mallard]

The datafile name is in v$datafile.....the column name is 'name'.