Home » Infrastructure » Other Operating Systems » Moving tablespaces cross-plataform (RHEL5 10g 10.2.0.2.0)
Moving tablespaces cross-plataform [message #345419] Wed, 03 September 2008 09:13 Go to next message
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 #378244 is a reply to message #345419] Mon, 29 December 2008 07:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What kind of data are we concerned about here?
How big?

Re: Moving tablespaces cross-plataform [message #378255 is a reply to message #378244] Mon, 29 December 2008 08:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Smile.






[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 Go to previous message
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
Previous Topic: Sync time between VMware guest and host
Next Topic: Database Migration from mainframe DB2 to Oracle
Goto Forum:
  


Current Time: Thu Mar 28 14:09:08 CDT 2024