Home » RDBMS Server » Backup & Recovery » RMAN: Recover from new backup set to point-in-time in the past (Oracle 9.2.0.1, Window 2003 server)
RMAN: Recover from new backup set to point-in-time in the past [message #302712] Tue, 26 February 2008 13:57 Go to next message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
Hi,
A database import occurred on Sun and an on-line backup was taken the following Mon. I would like to roll back so I do not get the imported data; however, I do not have a backup before the import happened. I have all the archive log files before and after the imported. I attempted to perform a point in time recovery, but it requested an older backup which I expected. So, could I recover a database to the time before the import using the backup after the import which is Monday? If so, how?

Thanks in advance,
Peter Confused
Re: RMAN: Recover from new backup set to point-in-time in the past [message #302713 is a reply to message #302712] Tue, 26 February 2008 14:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you can't.

Regards
Michel
Re: RMAN: Recover from new backup set to point-in-time in the past [message #302716 is a reply to message #302713] Tue, 26 February 2008 14:37 Go to previous message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
Thanks, I was afraid of that.
Previous Topic: Kind of Confused
Next Topic: database failing to start up / database recovery without a backup (merged)
Goto Forum:
  


Current Time: Tue Dec 06 16:16:06 CST 2016

Total time taken to generate the page: 0.14493 seconds