RE: Converting archivelog file name from FRA to %t_%s_%r.dbf
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: <development@xxxxxxxxxxxxxxxxx>, <Freek.DHooge@xxxxxxxxx>, "Oracle Mailinglist" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 4 Jun 2011 06:08:59 +0100
Martin,
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Bach
Sent: 03 June 2011 16:36
To: Freek.DHooge@xxxxxxxxx; '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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of D'Hooge Freek
> Sent: 03 June 2011 15:11
> To: development@xxxxxxxxxxxxxxxxx; '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@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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
