Hello Michael,
thank you for your encouragement for just copying around.
It worked - and I used an quite elegant way.
I set up a data guard environment with a standby db on
the new hardware. Then I used the data guard feature to
switch the role. My primary db on the older hardware became
standby db and the standby db on the new hardware primary and
so I was able to migrate with a five minutes downtime.
perfect.
I also had to bring in catpatch script because I went
from 9.2.0.7.0 to 9.2.0.8.0 as well.
Thanks and regards Mathias
-----Original Message-----
From: Michael Eisenberg [mailto:Michael.Eisenberg@(protected)]
Sent: Tuesday, January 09, 2007 8:43 AM
To: SuSE MailingList
Subject: Re: [suse-oracle] How can I migrate 9i on Linux IA64 to Linux x86_64
Hi,
if both boxes have the same endian format it SHOULD be possible to just
copy the DB to the new
box. Just install the X86_64 Oracle version to the new box (same
Version/patches/path as the old one)
shutdown db/listener, copy DB-Files,controlfiles,archives,init<sid>.ora
and the listerner *.ora stuff to the new
box (same path,filenames,owner .... as on old box). I did not tried this,
cos not IA64 here .....
Michael Eisenberg
Hawker GmbH
an Enersys Company
Phone: +49 (0)2331 372 402
Fax: +49 (0)2331 372 222 402
Email: michael.eisenberg@(protected)
When in danger or in doubt, run in circles, scream and shout.
from Robert Heinlein
"Zarick, Mathias" <Mathias.Zarick@(protected):
> Hello All,
>
> we have to migrate an 9i DB from a Linux IA64 Itanium to Linux
> x86_64 AMD Opteron.
> We have to stay on 9i, so we cannot use the new 10g data pump features
or rman
> transportable tablespaces.
> The transportable tablespaces feature with export / import in 9i is
> only supported,
> when we stay on exactly the same platform.
> Anyway has anybody tried between IA64 and x86_64?
> Both should have little endian format.
> Any other tricks to minimize downtime?
> full export / full import will take so so long.
>
> Looking forward to your contributions
> Mathias
>
>
> Mathias Zarick
> Specialist
> Data Center Server & Storage
> IT
>
> OMV Solutions
> Lassallestraße 3
> A-1020 Wien
> Tel. +43 (1) 40440-22113
> Fax +43 (1) 40440-622113
> mailto: mathias.zarick@(protected)
> http://www.omv.com
>
> OMV Solutions GmbH, registriert beim Handelsgericht Wien unter FN
> 80445b;Gesellschaftssitz: Wien; DVR: 0667293; UID ATU36821105;
> Lassallestraße 3; A-1020 Wien, Österreich
>
> Diese Nachricht ist vertraulich und nur für den Adressaten bestimmt.
> Falls Sie diese Nachricht irrtümlich erhalten haben, verständigen
> Sie bitte den Absender und löschen Sie diese Nachricht und alle
> Anhänge. Danke.
> Soweit gesetzlich zulässig, schließt OMV jede Haftung für Schäden
> aus Übertragungsfehlern, Viren, fremden Einfluss, Verzögerungen und
> dergleichen aus.
>
> This message is confidential and intended solely for the addressee.
> If you receive this message in error, please immediately inform the
> sender and delete the message and any attachments. Thank you.
> To the extent permitted by law OMV shall in no way be liable for any
> damages, whatever their nature, arising out of transmission
> failures, viruses, external influence, delays and the like.
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
