Oracle DBA – A lifelong learning experience

Posts Tagged ‘migrate tablespace’

Migrating tablespaces across Endian platforms

Posted by John Hallas on August 13, 2015

This is a set of posts about migrating a database from one endian platform to another.

The long-term intention is to move a large (10Tb) 11.1.0.7 database on HP-UX to an OEL Linux server with minimum outage so that will include a database upgrade as well.

This first post is about migrating a self-contained set of schemas using transportable tablespace.

The HP-UX 11.1.0.7 database is called HPUXDB and it was created through dbca with the sample schemas created.. The target database is 11.2.0.4 on OEL 5.8

I already have an 11.2.0.4 installation on the OEL 5.8 server and the target database is called L18

Let’s check the endian versions

 

SELECT PLATFORM_ID, PLATFORM_NAME, ENDIAN_FORMAT
FROM V$TRANSPORTABLE_PLATFORM; 

PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT  
4 HP-UX IA (64-bit) 
13 Linux x86 64-bit   Little

Read the rest of this entry »

Advertisements

Posted in 11g new features, ASM, Oracle | Tagged: , , , | Leave a Comment »