Home » RDBMS Server » Backup & Recovery » Help with a restore...
Help with a restore... [message #185072] Sun, 30 July 2006 21:25 Go to next message
Chewie71
Messages: 19
Registered: October 2005
Location: WIU
Junior Member
I was to apply a maintenance update to an application last night. The update failed and I had to roll back the database.

I had taken a full backup just prior to the update, but didn't notice until after I used RMAN to recover the database that the backup ran but didn't finish successfully because the backup volume was full.

So my Oracle DB is hosed. I think my regular backup from Friday failed as well because the volume was full.

I'm in a bad situation. Is there any way to do a point-in-time recover from the last good backup (maybe Thursday), and then replay ALL transactions until 11PM Saturday night?

HELP PLEASE!!

I should have all the archivelogs/redologs I need. I just need help getting this accomplished.

Thanks,
Matt
Re: Help with a restore... [message #185104 is a reply to message #185072] Mon, 31 July 2006 00:55 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes, go for it. It will take some time to apply all the archived log files again, but at least you should be able to get the DB back on-line.

PS: I trust you've backed-up the database before you're first restore attempt.
Re: Help with a restore... [message #185268 is a reply to message #185104] Mon, 31 July 2006 18:15 Go to previous messageGo to next message
Chewie71
Messages: 19
Registered: October 2005
Location: WIU
Junior Member
I'm looking for some docs that will explain how to roll forward the archivelogs. Anyone?

Thanks,
Matt
Re: Help with a restore... [message #185272 is a reply to message #185268] Mon, 31 July 2006 21:23 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Without having any specific details or insight into your current situation, you may want to following this roadmap for your recovery (Restore and Recovery Scenarios).
Re: Help with a restore... [message #185274 is a reply to message #185072] Mon, 31 July 2006 21:27 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I'm looking for some docs that will explain how to roll forward the archivelogs. Anyone?
If you open the database normally (STARTUP), then you'll be precluded from rolling forward.
Previous Topic: Recover db from RMAN cold backup
Next Topic: using backup control file
Goto Forum:
  


Current Time: Sat Dec 10 18:26:14 CST 2016

Total time taken to generate the page: 0.11286 seconds