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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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: Fri Nov 29 12:21:19 CST 2024