Problem with Oracle Restore (47 Views)
Reply
Highlighted
Advisor
Posts: 25
Registered: ‎01-24-2007
Message 1 of 1 (47 Views)

Problem with Oracle Restore

Hi

I have recently started using DP 05.50 running on Windows 2k3, and yesterday was my first time to restore an Oracle 9.2.0.6.0 Database running on Windows 2k3.

First I want to state that I am no expert on RMAN!

I have tried restoring to a point in time, before a user duplicated all tables.

I altered the database to status mounted, so noone used the database while I restored. After Dataprotector stated the restore was successfully ended, I tried opening the database. But I got an error stating my database needed recovery. After running recovery of the database it still is duplicated. During the recovery process my database is using archive-logs from after the point in time where the duplication happened.

What could I have done differently so my database got back to an earlier state?

Best regards


Rune Millerjord
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.