Home » RDBMS Server » Backup & Recovery » RECOVERY FROM RMAN BACKUP (oracle 9i rel2, windows 2k server)
RECOVERY FROM RMAN BACKUP [message #567870] Sun, 07 October 2012 21:13 Go to next message
Rayam69
Messages: 28
Registered: May 2012
Junior 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.
Re: RECOVERY FROM RMAN BACKUP [message #567871 is a reply to message #567870] Sun, 07 October 2012 21:22 Go to previous messageGo to next message
BlackSwan
Messages: 22802
Registered: January 2009
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/

Re: RECOVERY FROM RMAN BACKUP [message #567872 is a reply to message #567870] Mon, 08 October 2012 01:39 Go to previous messageGo to next message
John Watson
Messages: 4588
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.

Re: RECOVERY FROM RMAN BACKUP [message #567879 is a reply to message #567871] Mon, 08 October 2012 02:29 Go to previous messageGo to next message
Rayam69
Messages: 28
Registered: May 2012
Junior 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.
Re: RECOVERY FROM RMAN BACKUP [message #567884 is a reply to message #567872] Mon, 08 October 2012 02:51 Go to previous messageGo to next message
Rayam69
Messages: 28
Registered: May 2012
Junior Member
Hi Jason,

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

Any ideas.

thanks.
Re: RECOVERY FROM RMAN BACKUP [message #567894 is a reply to message #567884] Mon, 08 October 2012 03:20 Go to previous messageGo to next message
John Watson
Messages: 4588
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.
Re: RECOVERY FROM RMAN BACKUP [message #567928 is a reply to message #567894] Mon, 08 October 2012 06:31 Go to previous messageGo to next message
Rayam69
Messages: 28
Registered: May 2012
Junior 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.
Re: RECOVERY FROM RMAN BACKUP [message #567929 is a reply to message #567928] Mon, 08 October 2012 06:34 Go to previous messageGo to next message
John Watson
Messages: 4588
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 Go to previous messageGo to next message
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.
Re: RECOVERY FROM RMAN BACKUP [message #568838 is a reply to message #568829] Wed, 17 October 2012 01:51 Go to previous message
Michel Cadot
Messages: 59182
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: windows rman - bat file using variable
Next Topic: Rman Backup
Goto Forum:
  


Current Time: Tue Sep 23 05:42:34 CDT 2014

Total time taken to generate the page: 0.19722 seconds