Re: My RMAN script of full backup
From: joel garry <joel-garry_at_home.com>
Date: Fri, 27 Apr 2012 14:23:27 -0700 (PDT)
Message-ID: <fa1561fa-028c-4121-906d-9cf7d0c0a09b_at_wp13g2000pbb.googlegroups.com>
On Apr 27, 12:30 pm, Big George <jbet..._at_gmail.com> wrote:
> 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?
Date: Fri, 27 Apr 2012 14:23:27 -0700 (PDT)
Message-ID: <fa1561fa-028c-4121-906d-9cf7d0c0a09b_at_wp13g2000pbb.googlegroups.com>
On Apr 27, 12:30 pm, Big George <jbet..._at_gmail.com> wrote:
> 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?
Not entirely, see http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642
A manually backed up controlfile does not get automatically restored. Note that the controlfile gets backed up automatically when you backup file 1, but that is considered a manual backup. You should set CONFIGURE CONTROLFILE AUTOBACKUP ON One viewpoint is you can't have too many controlfile backups, another is you can get confused and shoot yourself in the foot.
It ain't a backup procedure unless it has successfully restored. You need to test various scenarios, and understand enough to deal with anything reality throws at you. You need to understand when to back off and let Oracle do the right thing automatically.
jg
-- _at_home.com is bogus. Redwood City, huh? http://www.utsandiego.com/news/2012/apr/27/nassco-built-spy-vessel-sale/Received on Fri Apr 27 2012 - 16:23:27 CDT