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

You could copy the archive logs from one ASM to another ASM via asmcmd cp command and on the second cluster to roll forward you could use

SQL> ALTER DATABASE RECOVER AUTOMATIC FROM '+ARCH/directorylocation';

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Bach Sent: 03 June 2011 16:36
To: Freek.DHooge_at_uptime.be; 'Oracle Mailinglist' Subject: RE: Converting archivelog file name from FRA to %t_%s_%r.dbf

Hi Freek,

Thanks for sharing your thoughts, especially the dbms_file_transfer. I didn't mention in my post that the database which receives the files is mounted -the archived logs I intend to get are used to roll it forward.

So I guess I have to resort to parsing the file name. By the way, asmcmd can be used to copy files between instances (How to Copy asm files between remote ASM instances using ASMCMD command [ID 785580.1]). Export DBI_TRACE=1 to get some handy information why it doesn't work in the first place.

Regards,

Martin
http://martincarstenbach.wordpress.com
http://www.martinbach-consulting.com

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of D'Hooge Freek
> Sent: 03 June 2011 15:11
> To: development_at_the-playground.de; 'Oracle Mailinglist'
> Subject: RE: Converting archivelog file name from FRA to %t_%s_%r.dbf
>
> 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
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l