SearchFAQMemberlist Log in
Reply to topic Page 1 of 1
restore oracle database From sun to AIX
Author Message
Post restore oracle database From sun to AIX 
[Test environment]

IBM Server : AIX5.2(64bit) , Oracle9i(64bit)
Sun Server : Solaris8(64bit), Oracle9i(64bit)
Oracle Backup : used rman catalog
-------------------------------------------------
when Oracle databae move From Solaris to AIX by rman,
is it possible ?

example >

target database : database of Solaris
"du" database : database of AIX (for duplication)

run {
duplicate target database to dup;
}

Note: To sign off this list, send a "signoff networker" command via email
to listserv < at > listserv.temple.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu

Post restore oracle database From sun to AIX 
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.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu

Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Magic SEO URL for phpBB