Recovery Probelm

[seelan]

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

[julian]

If the database is recovered with the

"RECOVER DATABASE USING BACKUP CONTROLFILE;"

option without specifying the "UNTIL CANCEL" option, then upon "ALTER DATABASE OPEN RESETLOGS;" you will always get the ORA-1113 error.

Steps to workaround this issue:

1. Recover database again using:

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

2. Cancel recovery by issuing the "CANCEL" command.

3. Open the database using:

SVRMGR> ALTER DATABASE OPEN RESETLOGS;

[seelan]

Thank you julain.

After giving until cancel option, it is working fine

Thanks
Seelan