Re: Backup setup sane?

From: Robert Klemme <>
Date: Fri, 16 Oct 2009 07:39:11 -0700 (PDT)
Message-ID: <>

On 16 Okt., 15:35, hpuxrac <> wrote:
> On Oct 16, 4:39 am, Robert Klemme <> wrote:

> I really prefer to do any DELETing in separate scripts under separate
> schedules.

Is this because of load or safety (i.e. to have some time between the backup and the deletion to inspect backup and prevent deletion from running backup had issues)? From the documentation it seems RMAN would not delete archive logs for example if the backup failed.

>  I also prefer to handle archivelogs separate from database
> backups.

Why is that?

> This is what one of my backup scripts looks like:
> rman << EOF
> connect target
> run {
> allocate channel d1 type disk format '/u03prod/disk/rman_prod_%M_%D_%Y_
> %U.bkp';
> backup validate check logical database;
> backup incremental level 1
> for recover of copy
> with tag 'disk_incremental'
> database;
> recover copy of database with tag 'disk_incremental';
> restore database validate;
> release channel d1;}
> exit;

> I am not a big fan of the autobackup of the controlfile and spfile and
> followup an rman backup with manual steps to get both of those
> available "where I can control them" instead of rman.

Again, why is that? I mean, you can configure the location where RMAN places control files.

> sqlplus / as sysdba << EOF1
> create pfile='/home/oracle/prod_pfile.ora' from spfile;
> create pfile='/u03prod/disk/prod_pfile_`date +"%m_%d_%Y"`_`date
> +"%T"`.ora' from
>  spfile;
> alter database backup controlfile to trace as '/u03prod/disk/
> prod_controlfile_tr
> ace_backup_`date +"%m_%d_%Y"`_`date +"%T"`.ora';
> exit;
> EOF1
Other than the noted points are there any things I missed or issues (like flooding a file system with things that are not automatically purged) I created with my setup?

Kind regards

robert Received on Fri Oct 16 2009 - 09:39:11 CDT

Original text of this message