Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cloning db using dd- unix & oracle versions same?

Re: Cloning db using dd- unix & oracle versions same?

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Sun, 14 Mar 1999 16:20:55 GMT
Message-ID: <36ebe166.49709166@news.erols.com>


On Sun, 14 Mar 1999 14:41:24 GMT, ak494_at_hotmail.com wrote:

>I'm cloning a database AIX ver 4.1 ,oracle 7.2.3. of size 10gb.The
>destination db is unfortunately not the same version AIX ver 4.2
>oracle 7.3.4.3 . My question is DO ORACLE & UNIX versions have to
>match, when I'm doing a dd copy from source to destination ? MY gut
>feeling says yes , but I'm unsure. Different colleagues seem to have
>different opinions ! On the source db neither Oracle nor UNIX versions
>can be upgraded due to various constraints. Please dont tell me to do,
>RTFM , it hasnt helped !

The Oracle version should match, particularly if you're doing a big version jump like 7.2 to 7.3. The AIX version I wouldn't think would matter too much.

What I would recommend is to DD the Oracle datafiles over to the 7.3.4 box. Then startup the database and run the cat73* scripts, catalog.sql, and catproc.sql to upgrade the data dictionary and such.

Chris



Chris Hamilton -- toneczar_at_erols.com
Oracle DBA -- Wall Street Sports
http://www.wallstreetsports.com/ Received on Sun Mar 14 1999 - 10:20:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US