Re: move 9i r2 database on host 1 to 10g r1 on another host

From: sundar mahadevan <>
Date: Mon, 10 Aug 2009 11:47:18 -0400
Message-ID: <>

Hi Martin,
Both of them have the same OS. These are test machines. Host 1 is 933 Mhz intel processor and Host 2 is 1.83 Ghz Intel T2400. Please find below cat /proc/cpuinfo from both hosts. Both of them belong to the same CPU family : 6

You said" In this case you just can copy the database and upgrade it." To my understanding, I just shutdown the database and copy all the database files including spfile and move it to Host 2. To upgrade it, do I run any upgrade script or is there a tool (like dbca) which would do this for me. I would appreciate if you could provide me with metalink doc id or a link explaining the same. I have not done this before and hence require explanation for the same. Many Thanks for your help.

1                                         Host 2

-----------                                        -----------
processor                 0                                                0
vendor id                  GenuineIntel
cpu family                6
model                      8
model name             Pentium III (coppermine)               GenuineIntel
(R) CPU T2400 _at_ 1.83 GHz
stepping                  3
cpu Mhz                  930.325
cache size               256 KB                                       2048
fdiv_bug                  no
hlt_bug                   no
f00f_bug                  no
coma_bug               no                                               no
fpu                          yes
fpu_exeption            yes                                             yes
cpuid_level              2                                                 2
wp                          yes
flags                       fpu vme de pse tsc msr pae mce cx8 apic mtrr pge
mca cmov pat pse36 mmx fxsr sse up (Host 2 has the same settings as host 1 but does not have pse36 and additionally has the following: clflush sse2 constant_tsc pni monitor)
bogomips                1861.43


On Sat, Aug 8, 2009 at 4:33 PM, Martin Berger <>wrote:

> Sundar,
> does host1 and host2 have the same OS and CPU-family?
> In this case you just can copy the database and upgrade it.
> br
> Martin
> --
> Hi All,
> Many Thanks to Robert Freeman, Mark Bobak, Dick Goulet for helping me out
> on my previous question on incomplete recovery. Unfortunately I did not get
> a chance to resolve the issue as another DBA is currently working on it. So
> I cannot give any updates on it currently.
> I'm running a test environment. The test database is small. I would like to
> move/migrate 9i r2 database on host 1 to 10g r1 on host 2. 9i r2 and 10g r1
> are the software versions on host 1 and 2 respectively. I would like to
> receive suggestions on how to do this. My ideas are as follows: Create a new
> database on 10g r1 with the same name as test database on 9i r2 and export
> the tablespaces from host 1(9i r2) and import it in newly created database
> using transport_tablespace on host 2(10g r1). To my knowledge an export from
> 9i r2 will be compatible in 10g r1. Any help is greatly appreciated. Can the
> same step be followed for large databases? If not what would be procedure
> for large databases? Thanks in advance.

Received on Mon Aug 10 2009 - 10:47:18 CDT

Original text of this message