Re: Unable to distinguish the difference in RMAN configuration

On Fri, 19 Mar 2004 02:04:25 -0800, Aravind wrote:

> Hi
> I have a problem. We configured RMAN in one machine and it is keeping
> backup set of only last backup(ie 1 DAYS backup) even tough we gave
> recovery window as 5 days. But on the other machine five backup files
> are stored , where in both two machines the RETNENTION POLICY IS SAME.
> I will put the script we used for backup
>
> The Shell script we are using is
>
>
> [oracle_at_devdb02 script]$ cat<backupscript
> #!/bin/sh
> LOGS=/backup/log/nightly_backup_`/bin/date '+%m%d%y'`.log
> ORACLE_SID=prod
> ORACLE_BASE=/disk1/oracle/product
> ORACLE_HOME=/disk1/oracle/product/9201
> LD_LIBRARY_PATH=$ORACLE_HOME/lib
> PATH=/usr/bin:/usr/ucb:/etc:.:$ORACLE_HOME/bin:/usr/local/bin
> export PATH LOGS ORACLE_SID ORACLE_HOME LD_LIBRARY_PATH
>
> function fullOffline
> {
> rman TARGET system/manager CATALOG rmanuser/rman_at_dev <<EOF
> run { execute script full_offline; }
> run { delete noprompt obsolete; }
> run { delete noprompt backup of archivelog until time 'sysdate-5'; }
> EOF
> }
>
> function fullOnline
> {
> rman TARGET system/manager CATALOG rmanuser/rman_at_dev <<EOF
> run { execute script full_online; }
> run { delete noprompt obsolete; }
> run { delete noprompt backup of archivelog until time 'sysdate-5'; }
> EOF
> }
>
> theDay=(`/bin/date '+%a'`)
>
> case $theDay in
> *) fullOnline > $LOGS;;
> esac
>
> The stored scripts are:
>
> RMAN> print script full_offline
> 2> ;
>
> printing stored script: full_offline
> {
> shutdown immediate;
> allocate channel disk1 device type DISK;
> backup full database
> format '/backup/offline/%d_%t_%s_%p.dbf'
> channel disk1
> tag Full_Offline_Backup
> ;
> backup
> filesperset 5
> format '/backup/controlfile/%d_%t_%s_%p.cf'
> channel disk1
> current controlfile
> tag Controlfile_Backup
> ;
> sql 'alter system archive log current';
> backup filesperset 50
> archivelog all format '/backup/archivelog/%d_%t_%s_%p.arch'
> channel disk1
> skip inaccessible
> delete all input
> tag Archivelog_Backup
> ;
> release channel disk1;
> startup;
> }
>
> RMAN> print script full_online;
>
> printing stored script: full_online
> {
> allocate channel disk1 device type DISK;
> backup full database
> format '/backup/online/%d_%t_%s_%p.dbf'
> channel disk1
> tag Full_Database_Backup
> ;
> backup
> filesperset 5
> format '/backup/controlfile/%d_%t_%s_%p.cf'
> channel disk1
> current controlfile
> tag Controlfile_Backup
> ;
> sql 'alter system archive log current';
> backup filesperset 50
> archivelog all format '/backup/archivelog/%d_%t_%s_%p.arch'
> channel disk1
> skip inaccessible
> delete all input
> tag Archivelog_Backup
> ;
> release channel disk1;
> }
>
> The RMAN configuration we use are
>
>
> RMAN> SHOW ALL;
>
> RMAN configuration parameters are:
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
> CONFIGURE BACKUP OPTIMIZATION OFF; # default
> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
> CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
> # default
> CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; #
> default
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
> '/disk1/oracle/product/9201/dbs/snapcf_prod.f'; # default
> RMAN configuration has no stored or default parameters
> --------
> This is the configuration parametes of second machine where 5 backup
> sets are stored.
>
> In the first machine all RMAN configurations are same except the last
> message
> "RMAN configuration has no stored or default parameters"
>
>
> we are unable to figure out why this difference occurs , could you
> please help us
>
> Thanks in adavnce!!!

Have you checked the RMAN versions and patchset levels on both servers and compared them? Received on Fri Mar 19 2004 - 04:44:46 CST