OraFAQ Forum: Server Administration » Can be copy a file from ASM file system to Unix file system without using RMAN

Home » RDBMS Server » Server Administration » Can be copy a file from ASM file system to Unix file system without using RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can be copy a file from ASM file system to Unix file system without using RMAN [message #434737]

Thu, 10 December 2009 08:05

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

Report message to a moderator

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

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

No

- Babu

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Version?
Should be possible with 11g.

Report message to a moderator

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

Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA

Member

Yeah version is 11.1.0.7..........

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Want to change sys password
Next Topic:	System Tablespace is almost full.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 00:35:05 CDT 2024