OraFAQ Forum: Backup & Recovery » Help with a restore...

Home » RDBMS Server » Backup & Recovery » Help with a restore...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help with a restore... [message #185072]

Sun, 30 July 2006 21:25

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

Report message to a moderator

Re: Help with a restore... [message #185104 is a reply to message #185072]

Mon, 31 July 2006 00:55

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: Help with a restore... [message #185268 is a reply to message #185104]

Mon, 31 July 2006 18:15

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

Report message to a moderator

Re: Help with a restore... [message #185272 is a reply to message #185268]

Mon, 31 July 2006 21:23

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).

Report message to a moderator

Re: Help with a restore... [message #185274 is a reply to message #185072]

Mon, 31 July 2006 21:27

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	Recover db from RMAN cold backup
Next Topic:	using backup control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 11:46:09 CST 2024