《【2017年整理】FTP的方式访问ASM磁盘组》由会员分享，可在线阅读，更多相关《【2017年整理】FTP的方式访问ASM磁盘组（5页珍藏版）》请在金锄头文库上搜索。
1、FTP 的方式访问 ASM 磁盘组除了使用 asmcmd 命令之外，还可以通过 FTP 的方式访问 ASM 磁盘组中的文件。默认情况，这个 ftp 的端口是关闭的，可以通过下面的命令打开：SQL conn / as sysdba 已连接。SQL ?/rdbms/admin/catxdbdbca.sql 7788 8800SQL SET FEEDBACK 1SQL SET NUMWIDTH 10SQL SET LINESIZE 80SQL SET TRIMSPOOL ONSQL SET TAB OFFSQL SET PAGESIZE 100SQLSQL define ftpport = &1SQ
2、L define httpport = &2SQL Rem Create a function to traverse the dom elements.SQL CREATE OR REPLACE FUNCTION traverseDom2 (parnode dbms_xmldom.DOMNode, pathSeg VARCHAR2)3 RETURN dbms_xmldom.DOMNode IS4 nodeList dbms_xmldom.DOMNodeList;5 anElement dbms_xmldom.DOMElement;6 aNode dbms_xmldom.DOMNode;7 B
3、EGIN8 - Convert the passed in dom node to an element9 anElement := dbms_xmldom.makeElement(parnode);1011 - Select the path segment requested by the user12 nodeList := dbms_xmldom.getChildrenByTagName(anElement, pathSeg);1314 - get the first node out of the list15 aNode := dbms_xmldom.item(nodeList,
4、0);1617 - return that node (ignore errors here).18 return aNode;19 END;20 /函数已创建。SQLSQL declare2 configxml sys.xmltype;3 configdomdoc dbms_xmldom.DOMDocument;4 textNode dbms_xmldom.DOMNode;5 aNode dbms_xmldom.DOMNode;6 protNode dbms_xmldom.DOMNode;7 anElement dbms_xmldom.DOMElement;8 listOfNodes dbm
5、s_xmldom.DOMNodeList;9 aString VARCHAR2(100);10 begin1112 - Select the resource and set it into the config13 select sys_nc_rowinfo$ into configxml from xdb.xdb$config ;1415 - Create a dom document out of the xmltype16 configdomdoc := dbms_xmldom.newDOMDocument(configxml);1718 - Get the root Element
6、of the dom19 anElement := dbms_xmldom.getDocumentElement(configdomdoc);2021 - Convert this to a node22 aNode := dbms_xmldom.makeNode(anElement);2324 - Traverse One Element Down At A Time.25 aNode := traverseDom(aNode, sysconfig);26 protNode := traverseDom(aNode, protocolconfig);2728 - Set the FTP po
7、rt by traversing /ftpconfig/ftp-port29 aNode := traverseDom(protNode, ftpconfig);30 aNode := traverseDom(aNode, ftp-port);31 textNode := dbms_xmldom.getFirstChild(aNode);32 dbms_xmldom.setNodeValue(textNode, &ftpport);3334 - Set the FTP port by traversing /ftpconfig/ftp-port35 aNode := traverseDom(p
8、rotNode, httpconfig);36 aNode := traverseDom(aNode, http-port);37 textNode := dbms_xmldom.getFirstChild(aNode);38 dbms_xmldom.setNodeValue(textNode, &httpport);3940 dbms_xdb.cfg_update(configxml);41 commit;4243 end;44 /原值 32: dbms_xmldom.setNodeValue(textNode, &ftpport);新值 32: dbms_xmldom.setNodeVal
9、ue(textNode, 7788);原值 38: dbms_xmldom.setNodeValue(textNode, &httpport);新值 38: dbms_xmldom.setNodeValue(textNode, 8800);PL/SQL 过程已成功完成。SQLSQLSQL drop function traverseDom;函数已删除。这个脚本需要 SYS 或者 XDB 用户来调用，后面跟的两个参数分别是 FTP 的端口和 HTTP/WEBDAV 的端口。下面就可以通过端口 7788 来访问 ASM 磁盘组了：SQL host$ ftpftp open ser1 7788Con
10、nected to ser1.220- ser1Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.220 ser1 FTP Server (Oracle XML DB/Oracle Database) ready.Name (ser1:root): system331 pass required for SYSTEMPassword:230 SYSTEM logged inRemote system type is Unix.ftp cd
11、/sys/asm250 CWD Command successfulftp ls200 PORT Command successful150 ASCII Data ConnectionDATA226 ASCII Transfer Complete6 bytes received in 0.17 seconds (0.04 Kbytes/s)ftp cd DATA250 CWD Command successfulftp ls200 PORT Command successful150 ASCII Data ConnectionRACTESTASMTESTING226 ASCII Transfe
12、r Complete21 bytes received in 0.0021 seconds (9.58 Kbytes/s)ftp cd RACTEST250 CWD Command successfulftp ls200 PORT Command successful150 ASCII Data ConnectionCONTROLFILEONLINELOGDATAFILETEMPFILEPARAMETERFILEspfileractest.orabackup226 ASCII Transfer Complete86 bytes received in 0.003 seconds (28.41
13、Kbytes/s)ftp lcd /dataLocal directory now /dataftp cd DATAFILE250 CWD Command successfulftp ls200 PORT Command successful150 ASCII Data ConnectionSYSTEM.259.664395355SYSAUX.260.664395357UNDOTBS1.261.664395359UNDOTBS2.263.664395371USERS.264.664395373226 ASCII Transfer Complete113 bytes received in 0.
14、0028 seconds (38.79 Kbytes/s)ftp bin200 Type set to I.ftp promptInteractive mode off.ftp mget SYSTEM.259.664395355200 PORT Command successful150 BIN Data Connection226 BIN Transfer Completelocal: SYSTEM.259.664395355 remote: SYSTEM.259.664395355734011392 bytes received in 17 seconds (41380.50 Kbytes
15、/s)ftp ls200 PORT Command successful150 ASCII Data ConnectionSYSTEM.259.664395355SYSAUX.260.664395357UNDOTBS1.261.664395359UNDOTBS2.263.664395371USERS.264.664395373226 ASCII Transfer Complete113 bytes received in 0.0037 seconds (29.51 Kbytes/s)ftp cd .250 CWD Command successfulftp ls200 PORT Command
16、 successful150 ASCII Data ConnectionCONTROLFILEONLINELOGDATAFILETEMPFILEPARAMETERFILEspfileractest.orabackup226 ASCII Transfer Complete86 bytes received in 0.003 seconds (27.67 Kbytes/s)ftp cd backup250 CWD Command successfulftp send SYSTEM.259.664395355 system.dbf200 PORT Command successful150 BIN Data Connection226 BIN Transfer Completelocal: SYSTEM.259.664395355 remote: system.dbf734011392 bytes sent in 9.5 seco
