RE: Converting archivelog file name from FRA to %t_%s_%r.dbf

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Fri, 3 Jun 2011 16:11:26 +0200
Message-ID: <4814386347E41145AAE79139EAA398981502899446_at_ws03-exch07.iconos.be>

Ok, it seems dbms_file_transfer can be used: How to copy a datafile from ASM to a file system not using RMAN [ID 428893.1]  

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

-----Original Message-----

From: D'Hooge Freek
Sent: vrijdag 3 juni 2011 16:06
To: 'development_at_the-playground.de'; 'Oracle Mailinglist' Subject: RE: Converting archivelog file name from FRA to %t_%s_%r.dbf

Hmm

Not sure if you can copy a file from asm to os using utl_file.fcopy, but that would be my first try. The destination name can then easily be generated using the v$archived_log view.

My second attempt would be to use the asmcmd cp command.

Regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 03 2011 - 09:11:26 CDT