Re: move 9i r2 database on host 1 to 10g r1 on another host
Date: Mon, 10 Aug 2009 11:47:18 -0400
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.
Host 1 Host 2 ----------- ----------- processor 0 0 vendor id GenuineIntel GenuineIntel cpu family 6 6 model 8 14 model name Pentium III (coppermine) GenuineIntel (R) CPU T2400 _at_ 1.83 GHz stepping 3 8 cpu Mhz 930.325 1836.163 cache size 256 KB 2048 KB fdiv_bug no no hlt_bug no no f00f_bug no no coma_bug no no fpu yes yes fpu_exeption yes yes cpuid_level 2 2 wp yes yes flags fpu vme de pse tsc msr pae mce cx8 apic mtrr pgemca 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)
On Sat, Aug 8, 2009 at 4:33 PM, Martin Berger <martin.a.berger_at_gmail.com>wrote:
> does host1 and host2 have the same OS and CPU-family?
> In this case you just can copy the database and upgrade it.
> 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.