Lost control files of Target Database

[habeebksa]

Hi, I lost my control files of target database. How to recover the database from RMAN backup. I take full database backup using RMAN weekly.

thanks,

[davey23uk]

using the restore command, which part of the docs did you get stuck on

[hrishy]

Hi

I hope you do backup the controlfiles right ?

regards
Hrishy

[gopu_g]

Hi
use the command

RMAN>restore controlfile;

The rman backup keep the snapshot of the spfile.
gopu

[habeebksa]

Hi, I cannot mount the database. Both the target database and catalog database are on same machine. The Restore database command does'nt work, RMAN displays error: Database not mounted.

Iam logging to RMAN by giving

$ rman target system/devrman;

[gopu_g]

Hi
First u want to restore the spile.

RMAN>restore spfile;

then u restore the controlfie.
RMAN>restore controlfile;

then mount the database;
RMAN>startup mount;
then the database will be in the mount stage,then you can restore the database using the command restore dataabase;
gopu

[simply_dba]

$ rman target system/devrman;

You should connect as sys with sysdba