在看《Oracle Database 11g RAC手册》这本书的时候。提到ASM有个FTP工具,可以像普通文件那样,将ASM文件从一个库转移到另一个库。测试了下,可以。
参考文档: How to configure XDB for using ftp and http protocols with ASM (文档 ID 357714.1)
前提条件,配置FTP(略)
配置相关端口:
SYS@racdb2>execute dbms_xdb.sethttpport(8080);
PL/SQL procedure successfully completed.
SYS@racdb2>execute dbms_xdb.setftpport(2100);
PL/SQL procedure successfully completed.
SYS@racdb2>commit;
Commit complete.
SYS@racdb2>select dbms_xdb.GETFTPPORT() from dual;
DBMS_XDB.GETFTPPORT()
---------------------
2100
SYS@racdb2>select dbms_xdb.GETHTTPPORT() from dual;
DBMS_XDB.GETHTTPPORT()
----------------------
8080
SYS@racdb2>
设置相关的参数,这里没有设置,因为监听器上可以看到监听有XDB的信息
ALTER SYSTEM SET racdb1.dispatchers = "(PROTOCOL=TCP) (SERVICE=racdb1XDB)" SCOPE=BOTH
ALTER SYSTEM SET racdb2.dispatchers = "(PROTOCOL=TCP) (SERVICE=racdb2XDB)" SCOPE=BOTH
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 11-APR-2018 08:15:16
Uptime 0 days 12 hr. 23 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/host02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.102)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.104)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host02)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host02)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
验证:
C:\Users\zhao-pc>ftp -n
ftp> open 192.168.2.102 2100
连接到 192.168.2.102。
220- host02
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 host02 FTP Server (Oracle XML DB/Oracle Database) ready.
530 Please login with USER and PASS.
ftp> user system oracle
331 pass required for SYSTEM
230 SYSTEM logged in
ftp> cd /sys/asm
250 CWD Command successful
ftp> ls
200 PORT Command successful
150 ASCII Data Connection
OCR
DATA
226 ASCII Transfer Complete
ftp: 收到 14 字节,用时 0.30秒 0.05千字节/秒。
ftp> cd DATA
250 CWD Command successful
ftp> ls
200 PORT Command successful
150 ASCII Data Connection
RACDB
ASM
TEST
226 ASCII Transfer Complete
ftp: 收到 21 字节,用时 0.00秒 21.00千字节/秒。
ftp> cd RACDB
250 CWD Command successful
ftp> ls
200 PORT Command successful
150 ASCII Data Connection
DATAFILE
system01.dbf
sysaux01.dbf
undotbs01.dbf
users01.dbf
CONTROLFILE
control01.ctl
control02.ctl
ONLINELOG
redo01.log
redo02.log
TEMPFILE
temp01.dbf
example01.dbf
undotbs02.dbf
redo03.log
redo04.log
PARAMETERFILE
spfileracdb.ora
ARCHIVELOG
redo031.log
redo032.log
226 ASCII Transfer Complete
ftp: 收到 293 字节,用时 0.19秒 1.56千字节/秒。
ftp>
end