OraFAQ Forum: Backup & Recovery » RECOVERY FROM RMAN BACKUP

Home » RDBMS Server » Backup & Recovery » RECOVERY FROM RMAN BACKUP (oracle 9i rel2, windows 2k server)

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

RECOVERY FROM RMAN BACKUP [message #567870]

Sun, 07 October 2012 21:13

Rayam69
Messages: 43
Registered: May 2012

Member

Hi
We have a nightly rman backup that was complete and clean.

The backup contains a Data File, Control File and a backup Archive Log file.

The database server crashed with all the subsequent archive logs lost.

We are trying to recover from the three backup files.

We are bumping into the backup piece missing as all the archive logs are done.

Any ideas how to restore with the exising backup files. the lost archive logs are probably salvagable.

thanks in advance.

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #567871 is a reply to message #567870]

Sun, 07 October 2012 21:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Most Professional Organization have documented & tested Recovery Manual.
When was the last time the DB was successfully restored from backup files.

Ideally the DB can be restored as of the most recent available REDO files.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #567872 is a reply to message #567870]

Mon, 08 October 2012 01:39

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

It is hard to work out what you are doing, but it sounds to me as though you need to use incomplete recovery. I can't remember the 9i syntax, but for a currently supported release you would use
RECOVER DATABASE UNTIL SEQUENCE n;
where n is the first missing archive logfile.

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #567879 is a reply to message #567871]

Mon, 08 October 2012 02:29

Rayam69
Messages: 43
Registered: May 2012

Member

Hi Swan,

This is the first time we had a major crash like this and the first time we are trying to recover.
The partitions that had both the data files and archive logs are gone due to a multiple drive failure.
All we have are the backup files from the last nights backup.

Please help. Thanks.

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #567884 is a reply to message #567872]

Mon, 08 October 2012 02:51

Rayam69
Messages: 43
Registered: May 2012

Member

Hi Jason,

This is not working.
The recovery starts and says recovery completed but when try to open it crashes.

Any ideas.

thanks.

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #567894 is a reply to message #567884]

Mon, 08 October 2012 03:20

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

"This is not working" is not an Oracle error message. Neither is "it crashes".
If you want assistance, please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read
then show us what you are doing, with copy/paste. And use the [code] tags.

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #567928 is a reply to message #567894]

Mon, 08 October 2012 06:31

Rayam69
Messages: 43
Registered: May 2012

Member

Hi Jason,
Sorry, i get the following error when using the recover database until sequence n thread 1;
rman-03002 failure of alter db command at 10/8/12 6.28.21
ora-01092: oracle instance terminated. disconnection forced.

The backup was taken in oracle 9i release1 and the recovery is done in 9i release 2.

thanks.

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #567929 is a reply to message #567928]

Mon, 08 October 2012 06:34

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

Are you incapable of reading?
I said, "copy/paste" and "use [code] tags".

You might also want to think about the difference betwaeen "restore" and "upgrade".
--
Edit: typo

[Updated on: Mon, 08 October 2012 06:35]

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #568829 is a reply to message #567929]

Wed, 17 October 2012 01:15

manoj_bardhan
Messages: 1
Registered: October 2012

Junior Member

I have also same problem with 10g Oracle Express Edition. I am taking back up using RMAN backup utility . But I do not know how i could restore that back up in other system/pc. I want to migrate the data from one pc to another pc.

Kindly Help me.Thanks in advance.

Report message to a moderator

Re: RECOVERY FROM RMAN BACKUP [message #568838 is a reply to message #568829]

Wed, 17 October 2012 01:51

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is a whole chapter that describes it in details and step by step in:
Database Backup and Recovery Advanced User's Guide

2 other books you should read:
Database Backup and Recovery Basics
Database Backup and Recovery Reference

Regards
Michel

Report message to a moderator

Previous Topic:	windows rman - bat file using variable
Next Topic:	Rman Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 27 13:32:53 CST 2026