Quote Originally Posted by paragp1981
I think you can recover from control file loss in no catalog mode provided you have configured "controlfile autobackup on"

Please see "Table 2-25 RESTORE CONTROLFILE Scenarios" table from below link.
http://download-west.oracle.com/docs...rcmsynta46.htm
Yes, you can restore from autobackup. I missed that. But what if autobackup location is gone too? Imagine you have all your rman backups sitting on the tape(netbackup or whatever other tsm ) and no controlfile! How would you restore your database?