Oracle DBA – A lifelong learning experience

    Advertisements
  • Meta

  • Categories

  • Blog Stats

    • 1,634,354 hits
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 376 other followers

Posts Tagged ‘cp datafile asm to asm’

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: , , , | 1 Comment »