Unable to distinguish the difference in RMAN configuration

From: Aravind <aravindjp_at_yahoo.com>
Date: 19 Mar 2004 02:04:25 -0800
Message-ID: <2b60e8d2.0403190204.2b24585d@posting.google.com>

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!!! Received on Fri Mar 19 2004 - 04:04:25 CST