Oracle DB copy from PRD system 10g to TEST system 11g

[Former Member]

Hi All,

I have recently upgraded Oracle in the test system from 10.2.0.4 to 11.2.0.2. My Production system ran still with the old oracle version 10.2.0.4.

Now I need to refresh the test system.

Is that possible to be made at all, a database copy from production system (with old oracle version 10g) into test system (with the new version 11g) ?

Thanks in advance for your reply.

Regards

Latif

[Former Member]

Hi,

Thanks Eric & Markus for your solution proposals.

I'm wondering wether it's possible to downgread my QAS system to 10.2.0.2 before the system copy.

Is that possible?

thanks

[former_member204746]

Hi,

this is probably possible, But I would not choose that option, better upgrade than downgrade.

[Former Member]

We must have taken the

When you upgraded 10.2.0.X.X to 11.2.0.2.0 on TST System

You would have defintiely taken the 10.2.0.X.X. ( Oracle Home Backup)

I Strongly feel..

Resotre home folder in Qty System

Change the Environment Variables of s<sid>adm & ora<sid> users to oracle 10.2.0.X.X home directory

Change listener file entires.

Restore backup of Production of 10.2.0.X.X

recover system as you have not done any upgrade on QTY and release.

...The rest all approaches may consume your extensive .

You are the best judge...

How you want to build TST System ....want to make easy ...want to make hard your self.

Business wants data ..The rest all yours decission i think

Rgds

[former_member204746]

Hi,

restore the PRD database onto QAS, then, check the upgrade guide and run through DBUA and other post-steps to upgrade your new QAS DB to Oracle 11g.

so, from the DBUA step, you do the rest of the upgrade guide's upgrade steps.

I did this before and it worked fine.

good luck.

[markus_doehr2]

> Is that possible to be made at all, a database copy from production system (with old oracle version 10g) into test system (with the new version 11g) ?

Technically it should be possible - like described in

Note 932722 - Upgrade to Oracle 10.2 during a database copy

for an older version.

However, you will need to adapt the scripts according to the upgrade guide.

Markus