RE: Converting archivelog file name from FRA to %t_%s_%r.dbf
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "development@xxxxxxxxxxxxxxxxx" <development@xxxxxxxxxxxxxxxxx>, 'Oracle Mailinglist' <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Jun 2011 16:11:26 +0200
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@xxxxxxxxx
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@xxxxxxxxxxxxxxxxx'; '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@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--
http://www.freelists.org/webpage/oracle-l
Other related posts: