RMAN Duplicate - Until Time recovery using sysdate
I am using RMAN Duplicate to perform DB Clone using until time.
The command is :
DUPLICATE TARGET DATABASE TO newdev UNTIL TIME "TO_DATE('2014-01-06:19:45:30', 'YYYY-MM-DD:HH24:MI:SS')" BACKUP LOCATION '/data/newdev/rman_backup' DB_FILE_NAME_CONVERT '/data/newtest/oradata/newtest','/data/newdev/oradata/newdev';
I will be scheduling this in a script to run every day
so ,Instead of mentioning the Date i would like to mention the current sysdate and the Time remains same
How to i do it?
If i use the sysdate value it throws error.
The command is :
DUPLICATE TARGET DATABASE TO newdev UNTIL TIME "TO_DATE('2014-01-06:19:45:30', 'YYYY-MM-DD:HH24:MI:SS')" BACKUP LOCATION '/data/newdev/rman_backup' DB_FILE_NAME_CONVERT '/data/newtest/oradata/newtest','/data/newdev/oradata/newdev';
I will be scheduling this in a script to run every day
so ,Instead of mentioning the Date i would like to mention the current sysdate and the Time remains same
How to i do it?
If i use the sysdate value it throws error.
Regards,
DB
0