My RMAN script of full backup

From: Big George <jbeteta_at_gmail.com>
Date: Fri, 27 Apr 2012 12:30:29 -0700 (PDT)
Message-ID: <5c357771-4f1a-429d-bac5-a3a4f3542ba2_at_v22g2000vby.googlegroups.com>



Hello,
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;
        backup
         incremental level 0
         format '\\192.168.12.19\g$\SRV4-arclogs\MTDPROD\RMAN\FULL

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

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