This discussion is archived
5 Replies Latest reply: Jan 24, 2013 4:05 PM by Simon_DBA RSS

how to asmcmd cp non ASM files to ASM on a remote node

870389 Newbie
Currently Being Moderated
We have a 8TB database, RDBMS 11,1. on Solaris 10, non ASM. Need to copy the 1290 files to remote node of AIX ASM to prepare for a upgrading to 11.2.0.2.

We tried to use asmcmd cp to copy the files directly from non ASM too ASM remotely, but did not work.

$ asmcmd cp -ifr fttr@prp3.dev:/oradata/prdsdev/datafiles/dev_4.dbf +PRDSU_DATA/PRDSU/TEMPFILE/dev_4.dbf
Enter password: ********
Argument "normal" isn't numeric in numeric ge (>=) at /optware/oracle/11.2.0.2/grid/lib/asmcmdshare.pm line 1676.
errors
ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin)

We were using the user fttr. Do we need to login as SYSASM, do we need to go through OS auth, any other privilege required. What instance do we need to login, regular database that is using the data files, or ASM instance is goin g to manage the files.

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points