Recovery from Cold Backup

[Rohit]

Hi

We have a complete cold Backup taken on Sunday. The database crashed on wednesday. None of the database files are available. The only files we have are the taped backup archive files till wednesday.

Is there a possibility of recovering the database until the recent archive which we have in the tape using the cold backup...

Thanks

[davey23uk]

yes, if you have all the archive logs since the cold backup then you can recover to your last log

[Rohit]

thanks for your reply.
But How do we proceed with the recovery when all the datafiles are missing including the contrrol file. All we have is the control file taken as a backup with the cold backup

[hacketta1]

You can still recover with your backup controlfile. I'm assuming here that you've lost your redologs, controfiles, and datafiles:

1) Restore all backup datafiles, and controlfile. Also restore the password file and init.ora if you lost those too. Don't restore your redo logs if you backed them up.

2) Make sure that ORACLE_SID is set to the database you want to recover

3)startup mount;

4)recover database using backup controlfile;

At this point Oracle should start applying all your archive logs, assuming that they're in log_archive_dest

5)alter database open resetlogs;

6) TAKE A FULL BACKUP!

HTH

Good Luck!

Austin

[Rohit]

Bingo , You got it .

Yes it worked perfect . Thanks a lot..