Hi,

Database is running on Archivelog Mode

I took the cold backup on Saturday

Today morning(Monday) I found all the datafiles,controlfiles are missing. But I have all the archivelog files from the saturday backup.

To restore the database to the current state, I followed the following steps

1. Copy the Datafiles, controlfiles from the saturday backup
2. set oracle_sid=winter
3. startup mount
4. recover database using backup controlfile;(Oracle successfully applied all the archive logfiles)
5 alter database open resetlogs;

But I am getting the following error
ora-01113: file 1 needs media recovery

Did I miss any step? Can anyone to help to solve the above problem?

Thanks
Seelan