Backup restore to Dev environment
How can I restore to Development database ? I use following script to restore from tape. Can I mention in the script with less memory parameters and no archive log mode?
CONNECT TARGET SYS/PWD@PROD
CONNECT AUXILIARY sys/PWD@DEVP
run
{
SQL 'STARTUP NOMOUNT';
set until time "to_date('11/23/11 10:00:00','mm/dd/yy hh24:mi:ss')";
SET ARCHIVELOG DESTINATION TO 'E:\ORADATA\...........' ------------------------optional if the archlog destination is structurally different