This content has been marked as final. Show 6 replies
you have to do a point in time recovery (PITR):
ALLOCATE CHANNEL C1 ......;
SET UNTIL TIME '15-Apr-2013 05:45:12';
RELEASE CHANNECL C1;
When you use "restore database" you are doing a full restore, i mean, the restore finish with the last backup you have.
recover database until time '15-Apr-2013 05:45:12'You have specified 05:45 AM as the time (your backup was at 01:30 PM, which is after the specified time).
As shown by others it is always good to specify the Date-Time format ! e.g. "TO_DATE('15-APR-2013 17:45:12','DD-MON-YYYY HH24:MI:SS')"
Hemant K Chitale