Restore controlfile in NOCATALOG mode

We have already discussed that how we shall backup and restore controlfile while we are in catalog mode using catalof database. You can find it here http://letstalkoracle.blogspot.in/2015/03/backup-restore-controlfile-using-rman.html

Now what if  we are not in catalog mode, means we are not using any catalog database. Can we still backup and restore the controlfile? The answer is yes.

Let's see how,

First we shall have to open RMAN, and connect to the target database in this way:

RMAN> connect target/

Now the backing up of the controlfile is the same as we do in case of CATALOG MODE.

Now coming to the restore part,

We can't write just RESTORE CONTROLFILE in nocatalog mode,

We have to write  it this way

RMAN> restore controlfile from '/RMAN backup location/backup piece name';

Consider this as an example,

RMAN> restore controlfile from '/u01/app/oracle/backup/1hq16igb_1_1';

And our controlfile will be restored fully.

And the rest of the procedure is the same as we do in case of catalog mode. You can find it here, http://letstalkoracle.blogspot.in/2015/03/backup-restore-controlfile-using-rman.html

That's all for now. Do not hesitate to correct or include any points or information that I have mentioned wrongly or missed completely. Your feedback is highly appreciated.

Thanks
Subhajit