Re: [suse-oracle] ASM and migration

Hi Ciro,

from my non-public SR:
- From "Database New Features Guide 10g Release 2 (10.2)" :-

1.2.2.1 Database Transport Across Same Endian Platforms

This transport feature provides a fast method to move a database from 
one platform to another.

The ability to migrate databases from one platform to another has become 
more important for Oracle customers. Oracle Data Pump can export the 
entire database, but it may be time consuming because it uses the SQL 
layer to process data.
Database transport across the same Endian platforms provides a faster 
and easier way to move Oracle databases from one platform to another.

- To check the 'endianess' of various platforms use this query :

SQL> col platform_name for a80
SQL> set lines 120
SQL> select * from v$transportable_platform

11 Linux IA (64-bit) Little
..
13 Linux x86 64-bit Little

But you're right, the partitioning may be a crucial obstacle, as the 
target platform needs to be able to interpret it. As far as I remember, 
slices are "partitions inside partitions", and may not be correctly 
interpreted by your target system.
I'd recommend to simply dd-clone one ASM disk as a whole and try whether 
the target system can see the cloned one's oracle ASM label, though.

Good luck!

Ciro Iriarte wrote:
> 2011/4/8 Christian Griebel<[email protected]>:
>    
>> For the same question, I've opened up an SR not so long ago and Oracle
>> told me, as long as the Endianness of the machines is the same
>> (http://en.wikipedia.org/wiki/Endianness), you may swap ASM disks
>> between machines at will.
>> We'll do it in the near future, though maybe in a few weeks, I'm back on
>> this list to complain it didn't work ;-)
>> So before that transition you make backups, do you...?
>> Cheers
>>      
> ________________
>    
>> Christian Griebel
>>      
> Great!, would be nice to have some feedback about your experience. Is
> that SR accessible by other customers?, any Metalink Article
> mentioned?.
>
> The only thing that might screw us is disk/LUN partitioning... (I
> remember having created slices on LUNs for Oracle on Solaris), I'm not
> sure about our HPUX and Linux servers...
>
> Regards,
>
>    
-- 
_____________________
Christian Griebel


This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not guarantee that this message is free of viruses and does
  not accept liability for any damages caused by any virus transmitted therewith.

Click http://disclaimer.merck.de to access the German, French, Spanish and Portuguese versions of this disclaimer.
_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle