Post date: 22-May-2009 10:12:59
ASM ACCESS VIA PL/SQL
execute dbms_file_transfer.copy_file('','','','');
example :
execute dbms_file_transfer.copy_file('ASMSOURCEDIR','spfilerdb.ora','ASMTARGETDIR','spfilerdbdup.ora');
ASM ACCESS VIA FTP and HTTP
Run this sql file while connected to your database instance.
SQL> @$ORACLE_HOME/rdbms/admin/catxdbdbca.sql
The script will prompt for FTP and HTTP port respectively
After that connect to your browser using : http://rc2.myrac.com:8080/sys/asm
It will prompt for username and password. Use system user for oracle database and it's password. There you go !! You can copy the files from ASM to normal file system easily
ASM ACCESS VIA FTP and FTP
[oracle@rc2 ~]$ ftp rc2 7777
Connected to rc2.myrac.com.
220- rc2.myrac.com
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 rc2.myrac.com FTP Server (Oracle XML DB/Oracle Database) ready.
530 Please login with USER and PASS.
530 Please login with USER and PASS.
KERBEROS_V4 rejected as an authentication type
Name (rc2:oracle): system
331 pass required for SYSTEM
Password:
230 SYSTEM logged in
Remote system type is Unix.
ftp>
ftp> pwd
257 "/" is current directory.
ftp> cd sys/asm
250 CWD Command successful
ftp> pwd
257 "/sys/asm" is current directory.
ftp> ls
227 Entering Passive Mode (192,168,112,20,8,22)
150 ASCII Data Connection
drw-r--r-- 2 SYS oracle 0 JUL 25 19:21 FLASH
drw-r--r-- 2 SYS oracle 0 JUL 25 19:21 DATA
226 ASCII Transfer Complete
ftp> cd FLASH
250 CWD Command successful
ftp> ls
227 Entering Passive Mode (192,168,112,20,239,38)
150 ASCII Data Connection
drw-r--r-- 2 SYS oracle 0 JUL 25 19:21 RDB
226 ASCII Transfer Complete
ftp> cd RDB/DATAFILE
250 CWD Command successful
ftp> ls -ltr
227 Entering Passive Mode (192,168,112,20,86,121)
150 ASCII Data Connection
-rw-r--r-- 1 SYS oracle 503324672 JUL 25 19:21 SYSTEM.256.693074013
-rw-r--r-- 1 SYS oracle 262152192 JUL 25 19:21 SYSAUX.257.693074017
-rw-r--r-- 1 SYS oracle 36708352 JUL 25 19:21 UNDOTBS1.258.693074019
-rw-r--r-- 1 SYS oracle 5251072 JUL 25 19:21 USERS.259.693074021
-rw-r--r-- 1 SYS oracle 104865792 JUL 25 19:21 EXAMPLE.267.693074209
-rw-r--r-- 1 SYS oracle 26222592 JUL 25 19:21 UNDOTBS2.268.693074507
226 ASCII Transfer Complete