DAILY REFRESH
sqlplus / nolog <<EOM
CONNECT / AS SYSDBA
STARTUP MOUNT EXCLUSIVE RESTRICT;
DROP DATABASE;
STARTUP FORCE NOMOUNT PFILE=/PATH/PFILE';
RMAN auxilary / log=rmandb.log <<EOF
run
{
DUPLICATE TARGET DATABASE TO <DBNAME> UNTIL TIME 'SYSDATE-24'
BACKUP LOCATION '/XYZ/ABC';
}
EOF
sqlplus / nolog <<EOM
CONNECT / AS SYSDBA
STARTUP MOUNT EXCLUSIVE RESTRICT;
DROP DATABASE;
STARTUP FORCE NOMOUNT PFILE=/PATH/PFILE';
RMAN auxilary / log=rmandb.log <<EOF
run
{
DUPLICATE TARGET DATABASE TO <DBNAME> UNTIL TIME 'SYSDATE-24'
BACKUP LOCATION '/XYZ/ABC';
}
EOF
No comments