My RMAN script of full backup

From: Big George <>
Date: Fri, 27 Apr 2012 12:30:29 -0700 (PDT)
Message-ID: <>

I have a doubt about my RMAN script of full backup, which run every Sunday.

run {

        allocate channel c1 type disk maxpiecesize=4G;
        CROSSCHECK archivelog all;
         incremental level 0
         format '\\\g$\SRV4-arclogs\MTDPROD\RMAN\FULL

filesperset 8 spfile format '\\\g$\SRV4-arclogs\MTDPROD\RMAN
database ; backup current controlfile format '\\\g$\SRV4-arclogs
\MTDPROD\RMAN\FULL\ctl_%d_%s_%T_%p.ctl' ;
SQL 'alter system archive log current'; backup format '\\\g$\SRV4-arclogs\MTDPROD\RMAN\FULL\ARC_ %d_%T_%s_%p.bak' archivelog all delete all input; restore spfile to pfile '\\\g$\SRV4-arclogs

As you see, I backup my level 0 backuppieces and my controlfile separately.

I backup controlfile separately because it would be easier to identify it and move it to a new host, in case we have to restore database from a disaster recovery.

Is that correct? Or could I have problems with that controlfile when restoring my full backup? Received on Fri Apr 27 2012 - 14:30:29 CDT

Original text of this message