Restore 10.2 data files on a 11.2 server engine

[ganimede_dignan]

Hi,

Can I restore database (I've got all data file, log, etc) saved from a server with Win2003/Ora 10.2.0.2 on a new server Win2008R2/Ora 11.2.0.3 directly?

Thank you.

[former_member206552]

post on oracle site

Hello,

You have to;

1. Install 11g Software binaries
2. Follow the document, Restore a database to a new host; http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmadvre.htm#i1007814
3. Recover database and open resetlogs option
4. Complete the manual Upgrade , following the document; http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#i1011600

[ganimede_dignan]

Thank you to all.

I've just restore all datafiles with a BRRESTORE... I forgot to inform you that source <SID> is differente from target <SID> so we need to run befeore manual upgrade...

CREATE CONTROLFILE REUSE SET DATABASE ‘<TARGET_SID>’ RESETLOGS ARCHIVELOG;

Does it work your method in any way?

[Former Member]

Hi,

Since the SID is not same as in source system, then you need to use SET...

Please use the below command

Create controlfiel SET database SID resetlogs archivelog ..........

Reuse option is for place where the SID remains the same for both source and target...

Thanks and Regards,

Vimal

[Former Member]

Hi Ganimede,

It is possible. You should apply manual Oracle 11g upgrade procedure. Please find the document, below;

http://docs.oracle.com/cd/E14072_01/server.112/e10819.pdf

Best regards,

Orkun Gedik

[former_member188883]

Hi Ganimede,

Technically it is possible but not the recommended method to do so . Once the database is restored you have to upgrade this database into 11g by catupgrd.sql script. Refer link http://taliphakanozturken.wordpress.com/2012/07/20/how-to-restore-10g-rman-backup-to-11g/

Best approach is to use export/import method to perform this.

Hope this helps.

Regards,

Deepak Kori

[former_member206552]

thanx deepak, going to try this

[former_member206552]

hi,

no you can not restore from a 10g isntallation to a 11g installation,

you can export the database using datapump or you can follow the upgrade guide (do a restore to 10g and then upgrade)

https://websmp107.sap-ag.de/~form/sapnet?_SCENARIO=01100035870000000202&_SHORTKEY=002007974700000890...

best regards

marius