#!/bin/ksh
 
. oraenv tempdb;

sqlplus -s /nolog <<EOF
connect / as sysdba; 
startup nomount;
exit;
EOF

. oraenv workip;

rman catalog=rcat/rcatpasswd@rcat target=/ <<RMAN
connect auxiliary sys/syspasswd@tempdb;
run {
 set until time = "to_date('29-MAY-2005:18:00:00','DD-MON-YYYY:HH24:MI:SS')";
 duplicate target database to tempdb pfile=/opt/oracle/product/9.2.0.6/dbs/inittempdb.ora;
};
exit;
RMAN

exit;