oracle@mutation#somescript
current date : Mon Jan 29 15:53:23 EST 2007
last saturday : JAN 27 2007 19:30:00
Within RMAN scripts, you can use it like this :
set until time "to_date( JAN 27 2007 19:30:00,MON DD YYYY HH24:MI:SS)";
oracle@mutation#
oracle@mutation#
oracle@mutation#cat somescript
tdate=`date`
ldate=`sqlplus -s scott/tiger <<EOF
set feed off;
set term off;
set head off;
set trimspool on;
alter session set nls_date_format='MON DD YYYY HH24:MI:SS';
select next_day(trunc(sysdate,'WW')-7, 'Saturday')+ 19.5/24  from dual;
exit;
EOF`
echo current date   : $tdate
echo last saturday : $ldate
echo Within RMAN scripts, you can use it like this :
echo 'set until time "to_date('$ldate','MON DD YYYY HH24:MI:SS')";'
oracle@mutation#