convert oracle version

[kukuluku]

Hello,

I have test machine upgrated to 9.2.0.6 from 9.2.0.3. Production is still running 9.2.0.3.

I need to copy a DB from production to test. Can I just copy all data files over for a new DB (using backup control file script) and then run startup migrate as the instruction of upgrade from 9.2.0.3 to 9.2.0.6?

Thank you very much in advance for your input.

 

[SantaMufasa]

Kuku,

No, you should never copy database data files from one version of Oracle to another. Data files are version dependent, and copying just some of the data files from an Oracle database instance to another database instance will absolutely, positively corrupt the database and render it useless.

If you want to copy data from one version of Oracle to another (and the target database is a newer Oracle version than the source database), then you use the Oracle "exp" (export) utility on from the source database, then use the "imp" (import) utility on the target database.

If you wish to see how that occurs, you can look at my response in a sibling thread to this one by clicking thread759-1119376.

Let us know if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[kukuluku]

Hmmm... the exp/imp will take a long time.

How about if I copy DB files to the same box and create a new DB with old version. After create, move it over to the test box with new version and run migrate script?

Theoratically, it should work, right? When migrate to 9.2.0.6, I installed patch first to bring up to new version and then run migrate script.

Thanks,

 

[SantaMufasa]

Kuku,

Perhaps I misunderstood your intent. If you are attempting to clone the entire database from production then use it in a higher version for your test db, then just go for it. Since you will be copying the files from production, you won't do any damage to production, and if things don't work out, then you have lost nothing but your time.

Be sure that when you copy the datafiles from production that the database has been shutdown gracefully before you start copying files, else you will have trouble.

Remember Santa's First Rule of Asking For Advice: "One test is better than 100 expert opinions."



Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[alexhu]

Be sure that when you copy the datafiles from production that the database has been shutdown gracefully before you start copying files, else you will have trouble.

Or copy it by using hot backup and then recover on the other system

Alex