Home » RDBMS Server » Server Administration » Can be copy a file from ASM file system to Unix file system without using RMAN
Can be copy a file from ASM file system to Unix file system without using RMAN [message #434737] Thu, 10 December 2009 08:05 Go to next message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

Hi Experts,

Can we copy a file from ASM file system to Unix file system without using RMAN.


Thanks
Vivek
Associate Consultant-DBA
HCL
Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #434741 is a reply to message #434737] Thu, 10 December 2009 08:23 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

No

- Babu
Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #434759 is a reply to message #434737] Thu, 10 December 2009 10:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Version?
Should be possible with 11g.
Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #434765 is a reply to message #434759] Thu, 10 December 2009 11:18 Go to previous messageGo to next message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

Yeah version is 11.1.0.7..........
Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #434767 is a reply to message #434765] Thu, 10 December 2009 11:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asm_util.htm#CHDJEIEA

There are certain quirks with 11gR1. Been told that those are fixed in 11gR2. Have not tested yet.
Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #434801 is a reply to message #434737] Thu, 10 December 2009 16:44 Go to previous messageGo to next message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
Better question is what's wrong with using RMAN? ASMFS in 11gR2 allows this - but really RMAN is how you do what you want to do.
Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #434819 is a reply to message #434737] Fri, 11 December 2009 00:03 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi Vivek,

Quote:
Can we copy a file from ASM file system to Unix file system without using RMAN.


You can try with DBMS_FILE_TRANSFER utility or Access ASM Virtual folder via FTP.

Not tried yet.

Regards,
Vish


Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #435015 is a reply to message #434737] Sun, 13 December 2009 12:54 Go to previous messageGo to next message
spabolu
Messages: 7
Registered: December 2009
Junior Member
Use DBMS_FILE_TRANSFER.COPY_FILE procedure.

Quote:
DBMS_FILE_TRANSFER.COPY_FILE(
source_directory_object => 'source_dir',
source_file_name => v_filename,
destination_directory_object => 'destn_dir',
destination_file_name => v_filename
);


Before using this procedure create oracle directories 'source_directory_object' which points to ASM and 'destination_directory_object' pointing to a path in OS.
Re: Can be copy a file from ASM file system to Unix file system without using RMAN [message #435345 is a reply to message #434801] Tue, 15 December 2009 13:21 Go to previous message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

there is nothing wrong with RMAN. But Some one asked this question from me. And i had only one answer NO. So I wanted to confirm.Whether it's possible aor not
Previous Topic: Want to change sys password
Next Topic: System Tablespace is almost full.
Goto Forum:
  


Current Time: Thu Sep 29 05:35:57 CDT 2016

Total time taken to generate the page: 0.11758 seconds