Moving tablespaces cross-plataform [message #345419] |
Wed, 03 September 2008 09:13 |
marcossantos
Messages: 123 Registered: June 2008
|
Senior Member |
|
|
Hi,
I have a database server 10g 10.2.0.3 on Linux
(RHEL5)x86_64 and I need move some tablespaces
to 10g 10.2.0.2 on linux (RHEL5)on SystemZ.
I try with RMAN but I get endian format error.
How can I do this?
I need move a few tablespaces.
Can I use exp/imp?
How can I convert the files for other plataform?
Marcos Santos
|
|
|
|
Re: Moving tablespaces cross-plataform [message #378255 is a reply to message #378244] |
Mon, 29 December 2008 08:45 |
marcossantos
Messages: 123 Registered: June 2008
|
Senior Member |
|
|
Hi,
tanks for your answer.
I have some tablespaces that contain data
from OLTP application. Its contains numeric
data, alphanumeric, date, and so on.
I have to transport this data to a
database oracle on Linux / Mainframe.
How can I do this?
Best Regards,
Marcos Santos
|
|
|
Re: Moving tablespaces cross-plataform [message #378259 is a reply to message #378255] |
Mon, 29 December 2008 09:03 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
If the data is not that big and straight forward,
just export and import (dumps) instead of transporting across platforms.
If you cannot afford it,
still you can use RMAN to transport.
If the endians of source and target are different, you have
to "convert" using RMAN "convert tablespace".
It is not essentially a very fast method (as comparing to just transporting), but works with certain restrictions.
It is all in docs.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDFDAFH
Again, it all depends on nature and volume of data.
If you can afford just export/import, just do it. In past I have used convert options to go between different endians. Took around a whole day to transfer 2TB data, which is way better than
export/import and users were not complaining about the downtime .
[Updated on: Mon, 29 December 2008 09:05] Report message to a moderator
|
|
|
Re: Moving tablespaces cross-plataform [message #378282 is a reply to message #378259] |
Mon, 29 December 2008 14:29 |
marcossantos
Messages: 123 Registered: June 2008
|
Senior Member |
|
|
Hi,
its work out.
1. I export my tablespace
via DB Control using the Tablespace
transportable feature.
2. I convert in source.
3. Copy the files to target.
Linux on zOS.
4. I created a data pump dir.
5. Run impdp with user sys.
Thanks,
Marcos Santos
|
|
|