Try this:

In RMAN

Startup nomount
Restore controlfile;
Alter database mount;
Recover database;
Alter database open resetlogs;


>Merci / Thanks
>Yves Leonard,
>Chef de Projet / Project Leader,
>DDS / SDD,
>RH Coats, 13-I
>Télép>ĥ>one / phone : 613-951-3233,
>couriel / email : yves.[Email address protected]
>

-----Original Message-----
From: Irfan Ahmad [mailto:oracledba-ezmlmshield-x84345203.[Email address protected]
Sent: February 1, 2007 8:41 AM
To: LazyDBA Discussion
Subject: Wants to Restore Control file

hi everyone
I am using rman for backups in my tested db. Now, I have lost all controlfiles but i have all backups which contain in backupset which was created with rman. Now i want to restore all my controlfiles through rman.
Plz suggest me how i restore my controlfiles .
Also remember that i am connecting with target db with out catalog and my db is also going in nomount stage.

Irfan Ahmad


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page