Friday, 14 December 2012

ASM cp Command to Remote Disk Group

ASM cp Command to Remote Disk Group

ASM cp command allows you to copy files between Oracle ASM disk groups and between a disk group and the operating system. Oracle ASM disk groups can be local or remote.
cp source_file [rem_connect_str:]target_file
cp [rem_connect_str:]source_file target_file
The rem_connect_str is in the form user@host[.port_number].SID with default port number of 1521. cp cannot copy files between two remote instances. The local Oracle ASM instance must be either the source or the target of the operation.
In an Oracle training material, Oracle New Features for Administrators, the authors stated “the format of the copied files is portable between Little-Endian and Big-Endian systems”. Oracle document (Oracle Automatic Stoarge Management Administrator’s Guide 11g Release 2(11.2), E18951-02) does not address the issue of copying between different endian systems. I tried to copy from Solaris 10 to Linux (see below example) with 11gR2 ASM, but failed with errors.
Local is a Solaris 10 system with ASM instance.
1) copying to another Solaris 10 — Success
ASMCMD>  cp thread_1_seq_4.5135.729122487 sys@sanfords.1521.+ASM1:+recovery/
Enter password: ******
copying +recovery/testdb2/archivelog/2010_09_07/thread_1_seq_4.5135.729122487 -> sanfords:+recovery/
2) Copying to Linux (same ASM version) — Failed
ASMCMD> cp thread_1_seq_4.5135.729122487
Enter password: *******
copying +recovery/testdb2/archivelog/2010_09_07/thread_1_seq_4.5135.729122487 ->
Argument “normal” isn’t numeric in numeric ge (>=) at /u01/app/oracle/product/11.2.0/grid_11202/lib/ line 1676, line 10.
ASMCMD-08016: copy source->’+recovery/testdb2/archivelog/2010_09_07/thread_1_seq_4.5135.729122487′ and target->’+recoverydest/’ failed
ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
ORA-06512: at “SYS.X$DBMS_DISKGROUP”, line 410
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

No comments: