Networker

Re: [Networker] restore oracle database From sun to AIX

2005-04-15 06:04:43
Subject: Re: [Networker] restore oracle database From sun to AIX
From: death AT INTELECTUALS DOT NET
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Fri, 15 Apr 2005 05:50:34 -0400
Nope, you can't do it.
Before 10g depending on the platform oracle uses different byte orders
within the datafiles, so transfering the datafiles to different platforms
are not possible, the only supported way to deal with it is export/import.
With 10g oracle introduced new feature for cross platform portability for
transportable tablespaces. The key is endian symbols within datafiles and
all supported platforms are splitted into two groups - endian big, endian
little:
SQL> select * from v$transportable_platform;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- ------------------------------ --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows NT Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
13 Linux 64-bit for AMD Little
16 Apple Mac OS Big
12 Microsoft Windows 64-bit for AMD Little
So i never tried but i am aware that you can recover 10g datbase to
different platform without converting tablespaces if the platforms are in
the same endian group. Need to check out, but this is not your case, so your
 option would be to recover to the same platform.

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listserv.temple DOT edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
also view and post messages to the list. Questions regarding this list
should be sent to stan AT temple DOT edu
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>