oracle 11gR2 ASM的asmcmd工具增加cp命令
oracle 11gR2 ASM的asmcmd工具增加cp命令
oracle 10gR2版本中asmcmd 工具不支持cp命令,而在11g版本中已经可以实现磁盘组和文件系统之间的文件对考
You can use the cp command to:
■ Copy files from a disk group to the operating system
■ Copy files from a disk group to a disk group
■ Copy files from the operating system to a disk group
以下是11gR2版本中的测试
oracle@p520:/oracle/app/oracle]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 26 18:06:29 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
从asm磁盘组往文件系统/oracle目录下copy
[grid@p520:/grid/app/grid]$asmcmd cp +dgsystem/orcl/datafile/USERS.264.711892935 /oracle
copying +dgsystem/orcl/datafile/USERS.264.711892935 -> /oracle/USERS.264.711892935
[grid@p520:/grid/app/grid]$cd /oracle
[grid@p520:/oracle]$ls -l
total 173792
-rw-r----- 1 grid oinstall 5251072 Feb 26 16:32 USERS.264.711892935
drwxrwxr-x 3 oracle oinstall 256 Feb 24 11:35 app
drwxrwxr-x 2 oracle oinstall 256 Feb 24 11:12 lost+found
-rw-r----- 1 grid oinstall 4096 Feb 26 11:37 spfileorcl.ora
-rw-r--r-- 1 oracle oinstall 83615744 Feb 25 15:24 test.dmp
-rw-r--r-- 1 oracle oinstall 107140 Feb 25 15:24 test.log
[grid@p520:/oracle]$mv USERS.264.711892935 users.bak
[grid@p520:/oracle]$ls -l
total 173792
drwxrwxr-x 3 oracle oinstall 256 Feb 24 11:35 app
drwxrwxr-x 2 oracle oinstall 256 Feb 24 11:12 lost+found
-rw-r----- 1 grid oinstall 4096 Feb 26 11:37 spfileorcl.ora
-rw-r--r-- 1 oracle oinstall 83615744 Feb 25 15:24 test.dmp
-rw-r--r-- 1 oracle oinstall 107140 Feb 25 15:24 test.log
-rw-r----- 1 grid oinstall 5251072 Feb 26 16:32 users.bak
从文件系统/oracle往asm磁盘组目录下copy
[grid@p520:/oracle]$asmcmd cp /oracle/users.bak +dgsystem/orcl/datafile
copying /oracle/users.bak -> +dgsystem/orcl/datafile/users.bak
ASMCMD> ls
SYSAUX.260.711892847
SYSTEM.259.711892811
UNDOTBS1.261.711892879
UNDOTBS2.263.711892921
USERS.264.711892935
users.bak
ASMCMD> pwd
+dgsystem/orcl/datafile