oracle 11gR2 asmcmd工具增加 cp命令

paulyibinyi發表於2010-02-26

    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版本中的測試

/ 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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-628015/,如需轉載,請註明出處,否則將追究法律責任。

相關文章