Restoring data from 9i to 10g

[Former Member]

Hi,

I was trying to restore data from a system with Oracle9i to another one with 10g.

But there occurs a "data inconsistency" problem.

Can anyone please get me a solution for this.....??

Regards,

Dhanya

[former_member433984]

see SAP note 932722 "Upgrade to Oracle 10.2 during a database copy"

It will help you

[Former Member]

Hi Dhanya,

it's not possible to restore data from release 9 to 10, for restoring a backup source and target need to be exactly the same release.

There are several possibilites, depending on what exactly you want to do:

- upgrade the source database to 10g, then do a systemcopy.

or

- keep the source system on release 9. Take a backup and install the target system with release 9, using your backup. After finishing the installation of the target system, upgrade the target database to release 10.

or

- do a migration, exporting the contents of the source database using SAP tools (you'll need to register a migration project for this at SAP, also you'll need a migration certified consultant...)

See here for more information: http://service.sap.com/systemcopy

Best regards,

Elmar.

[andreas_herzog]

> - do a migration, exporting the contents of the

> source database using SAP tools (you'll need to

> register a migration project for this at SAP, also

> you'll need a migration certified consultant...)

if you're doing a <b>homogeneous system copy</b> (= operating system and database system will stay the same as the source system) you will <b>not need any migration service</b> or a certified consultant...and, as it is possible to use an oracle 9i export as an import into an oracle 10g (when using r3load procedure) one can easily avoid the migration

GreetZ, AH

[Former Member]

> if you're doing a homogeneous system copy (= operating system and database system will stay

> the same as the source system) you will not need any migration service or a certified

> consultant...and, as it is possible to use an oracle 9i export as an import into an oracle 10g (when > using r3load procedure) one can easily avoid the migration

oops...

Of course, you are right Andreas - I should have a cup of coffee before posting early in the morning

- Elmar

[Former Member]

hey..

But this export/import wil take too much time ryt

[andreas_herzog]

make a comparison between ex- and import and upgrading your database to 10g (incl. migration...) if any of these is considerably faster, the choice might be an easy one

GreetZ, AH

[Former Member]

hi Dhanya ,

recently i have done same activity

u need do following things

at source sytem :

1) take the backup offline/online at source system

at target system

1) install the same db version and os version

2) restore the source database backup

3) then install the oracle 10g software

4) then use the dbua (database upgrade assitant ) to upgrade the database

Regards

Deepesh Bhatia

[Former Member]

hi Deepesh..

Am nw trying the same way ...

Thank u..

Hope it will work out..

[andreas_herzog]

> hey..

>

> But this export/import wil take too much time ryt

well...that depends...backup & restore will take time as well...if you're running r3load using for example r3ta (table splitter) and have enough resources the export might run considerably faster...otherwise use the "standard procedure" and use the upgrade assistant + migrate your database as described above...

GreetZ, AH

[Former Member]

Hi,

i was trying the following way..

at source sytem :

1) take the backup offline/online at source system

at target system

1) install the same db version and os version

2) restore the source database backup

3) then install the oracle 10g software

4) then use the dbua (database upgrade assitant ) to upgrade the database

bt while installing the db instance, i got the following error

MOS-01012 PROBLEM: 'E:\.....\RUN\SAPLICENSE -R3SETUP <SID> "09XTFIUK" TRACE=2' returned with '-2' which is not a defined as a success code.

Can anyone pls help me out...........!!!

Regards

Dhanya