Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trying to restore database until certain date with RMAN

DelmonteMay 18 2012 — edited May 20 2012
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2012
Added on May 18 2012
2 comments
3,526 views