Re: Cross Platform Database Migration Using TTS from Cooked Filesystem to ASM (OMF - I Hope)

  • From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
  • To: david.barbour1@xxxxxxxxx
  • Date: Tue, 13 Jan 2015 12:39:55 +0000

Hi,

Here are my blog posts from my migration from HP-UX into Linux and how you
can minimize downtime.

http://oracleprof.blogspot.ie/2014/07/crossplatform-transportable-tablespaces.html
http://oracleprof.blogspot.ie/2014/08/crossplatform-transportable-tablespaces.html

regards,
Marcin


On Sat, Jan 10, 2015 at 4:26 PM, David Barbour <david.barbour1@xxxxxxxxx>
wrote:

> Good Morning,
>
> We're running Oracle 11.2.0.3 on HPUX 64-bit Itanium using conventional
> cooked filesystems.  Need to move this to a Linux x86 64-bit, also running
> 11.2.0.3.  Due to the size of this thing, I'd like to use transportable
> tablespaces.  I've done this before using cooked filesystem to cooked file
> system, and asm to asm, but never from cooked to asm.  I don't anticipate
> any problems, but I'd like to end up with OMF names.
>
> I plan to convert the tablespaces on the source and put the resulting
> converted files into a directory I can nfs mount to the new server.
>
>
> The metadata will be extracted using DataPump.  When I've got the
> converted files attached to the new server and invoke impdp with the
> TRANSPORT_DATAFILES= parameter, will these automatically be converted to
> OMF if I have the db_create_file_dest set to the ASM data volume for this
> database?
>
> Any useful insights regarding the move gained through experience would be
> appreciated as well.
>
>
>
>
>


-- 
Marcin Przepiorowski
http://oracleprof.blogspot.com

Other related posts: