OraFAQ Forum: Backup & Recovery » RMAN Restore of Backups as Part of a Database Upgrade

Home » RDBMS Server » Backup & Recovery » RMAN Restore of Backups as Part of a Database Upgrade (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit,, 11.2.0.1.0,windows server 2008 64bit)

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

RMAN Restore of Backups as Part of a Database Upgrade [message #629379]

Mon, 08 December 2014 05:07

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

i have two database on my two different different host,

on my first node i install oracle " Oracle Database 10g Enterprise Edition Release 10.2.0.4.0"

and on my another node i install 11.2.0.1.0 ,

i want to use this 10g rman backup file and restore it on this 11g ,

means i want to upgrade this my 10g dataabase to 11g database using this rman.

can you suggest me some steps how can i upgrade it using rman backup file.

i not create database on 11g host just only software i install.

Report message to a moderator

Re: RMAN Restore of Backups as Part of a Database Upgrade [message #629388 is a reply to message #629379]

Mon, 08 December 2014 06:27

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

Senior Member
Account Moderator

You cannot, you have to restore with the same version than you have backed up.
So either you first upgrade in 11.2 and then backup/restore in 11.2, either you backup/restore in 10.2 and then upgrade in 11.2.

Report message to a moderator

Re: RMAN Restore of Backups as Part of a Database Upgrade [message #629419 is a reply to message #629388]

Tue, 09 December 2014 01:23

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

i not i directly restore 10g backup file on this 11g ...

Report message to a moderator

Re: RMAN Restore of Backups as Part of a Database Upgrade [message #629420 is a reply to message #629419]

Tue, 09 December 2014 02:00

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

Senior Member
Account Moderator

Report message to a moderator

Re: RMAN Restore of Backups as Part of a Database Upgrade [message #629456 is a reply to message #629419]

Tue, 09 December 2014 07:04

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

x-oracle wrote on Tue, 09 December 2014 01:23

i not i directly restore 10g backup file on this 11g ...

Because that's not how it works.

The backup is a backup of the PHYSICAL files that make up the database. And the internal structure of those files is very much version specific. You cannot simply take the files from one version and open them in another version.

Report message to a moderator

Previous Topic:	Restore & Recover Oracle Database with zero lose data
Next Topic:	ORA-00376: file 3 cannot be read at this time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:44:50 CST 2025