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

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 3 Jun 2011 11:43:20 -0300
Message-ID: <BANLkTi=o0v_34PrScXkh79q_6t1CO3NhDg_at_mail.gmail.com>



I think your problem is you need to take the archivelogs out of ASM, the naming issue can be resolved simply enough by mv afterwards (or not). Now, I know you can move datafiles and controlfiles easily enough out of ASM without using RMAN. I'm not so sure about archivelogs.

Check out the discussion in this same list about this: http://www.freelists.org/post/oracle-l/ASM-is-single-point-of-failure

Cheers
Alan.-

On Fri, Jun 3, 2011 at 10:36 AM, Martin Bach <development_at_the-playground.de>wrote:

> Hi all,
>
>
>
> A bit of a funny question which has been raised today. Oracle 11.2.0.2.2
> RAC with ASM on Linux.
>
>
>
> Letís assume for a moment that you have a production cluster with a disk
> group +ARCH used as the FRA. The archived redo logs follow the naming
> convention shown here:
>
>
>
> thread_*threadNumber*_seq_*sequenceNumber*.*fileID.incarnation*
>
>
>
> An example is thread_1_seq_94.348.752827039
>
>
>
> Thread and sequence number are self explanatory. The rest of the file name
> is composed of the file_number and file_incarnation as shown in v$asm_file,
> i.e. you could find this file in asm by querying
>
>
>
> SQL> select * from v$asm_file where file_number = 348 and incarnation =
> 752827039;
>
>
>
> So far so good. Now what I need to do is copy these files from the
> production cluster to another cluster and apply them to a clone of the
> production database to roll it forward.
>
>
>
> The question really is: do you know of a simple enough way to transform the
> files from their FRA naming convention into the %t_%s_%r.dbf format? RMAN
> cannot be used unfortunately, and itís too long a story to tell here.
>
>
>
> Ideally Iíll run a shellscript which transforms
> thread_1_seq_94.348.752827039 into 1_94_12345623432.dbf
>
>
>
> Thanks in advance for any pointers!
>
>
>
> Martin
>

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

Original text of this message