Re: Convert database from AIX to Windows
Date: Fri, 20 Jan 2012 14:52:07 +0000
Message-ID: <OFE2C7F79F.673FA794-ON8025798B.00511909-8025798B.0051ADB5_at_ons.gsi.gov.uk>
The rman convert command has from platform and to platform as parameters which handle the endianess conversion.
The availble platforms I first used this on are listed bleow although the contents of v$transportable_platform may differ from version to version
select platform_name,endian_format from v$transportable_platform;
PLATFORM_NAME ENDIAN_FORMAT ----------------------------------- -------------- AIX-Based Systems (64-bit) Big Apple Mac OS Big HP Open VMS Little HP Tru64 UNIX Little HP-UX (64-bit) Big HP-UX IA (64-bit) Big IBM Power Based Linux Big IBM zSeries Based Linux Big Linux 64-bit for AMD Little Linux IA (32-bit) Little Linux IA (64-bit) Little Microsoft Windows 64-bit for AMD Little Microsoft Windows IA (32-bit) Little Microsoft Windows IA (64-bit) Little Solaris Operating System (x86) Little Solaris[tm] OE (32-bit) Big Solaris[tm] OE (64-bit) Big
So if you are converting files on an AIX box prior to moving them to Linux say you would need to use
convert datafile '<file1>’,'<file2>',…,’<filen>’
to platform 'Linux IA (64-bit)'
Alternatively if you had already copied the files to the Linux box you would use
convert datafile '<file1>’,'<file2>',…,’<filen>’
from platform 'AIX-Based Systems (64-bit)'
Cheers,
Ian
|---------+----------------------------->
| | oracle_at_dunbar-it.c|
| | o.uk |
| | Sent by: |
| | oracle-l-bounce_at_fr|
| | eelists.org |
| | |
| | |
| | 20/01/2012 11:09 |
| | Please respond to |
| | oracle |
| | |
|---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| | | | To: oracle-l_at_freelists.org | | cc: | | Subject: Re: Convert database from AIX to Windows | | | | | >--------------------------------------------------------------------------------------------------------------------------------------------------|
Hi Dennis,
On 19/01/12 22:12, Dennis Williams wrote: > One point I didn't see mentioned in this discussion is "endianness" I > believe AIX is a big-endian machine while Windows/Intel is little-endian.
Using transportable tablespaces cross platform requires RMAN to convert the data files to the correct format. If it cannot do it, it will tell you.
I can't remember if the endianness had to be the same on both platforms though - when I used TTs to migrate a system both were the same.
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-l For the latest data on the economy and society consult National Statistics at http://www.ons.gov.uk ********************************************************************************* Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications ********************************************************************************* Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics ********************************************************************************* The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless Worldwide in partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 20 2012 - 08:52:07 CST