Trying to restore database until certain date with RMAN
DelmonteMay 18 2012 — edited May 20 2012Hello,
Oracle 10.2g. O/S: Windows Server 2003
With RMAN, I restored successfully a database in a new server.
However, I tried to restore it until certain date.
RMAN> restore database until time "to_date('2012-05-15 10:00','YYYY-MM-DD HH24:MI:SS')";
RMAN> recover database;
When RMAN finished, I checked my restored tables and realized that there were records newer than '2012-05-15'. RMAN restored all records, it didn't apply any filter as I wanted.
My full and incremental files are in a single folder C:\backups\.
What do you think was wrong?
Thank you