Re: ASM Datafiles and RMAN duplicate db

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 21 May 2012 15:01:48 +0100
Message-ID: <CABe10sY-S0bOSpu3DULhQn4yp6jvtcbWvwuRUxGeX5_SJ91LLQ_at_mail.gmail.com>

It isn't an ASM issue per se, but rather an Oracle Managed Files issue - you'll see the same behaviour (I believe) with a file system but where the various OMF parameters are set and datafiles etc are never explicitly named.
On Mon, May 21, 2012 at 2:50 PM, <Joel.Patterson_at_crowley.com> wrote:

> ASM is generating new and different file names each time, right? If I do
> not have an ASM instance, I can remove the 'temp' files for the temporary
> tablespace only, and RMAN just writes over all the existing data files and
> opens the database -- because they have the same name. Of course, I could
> just as easily remove all the files.
>
> Sidney Chen probably hit it on the head...,
>
>
> Joel Patterson
> Database Administrator
> 904 727-2546
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Imtiaz Merchant
> Sent: Sunday, May 20, 2012 1:30 AM
> To: oracle-l_at_freelists.org
> Subject: ASM Datafiles and RMAN duplicate db
>
> Folks,
> I am duplicating my prod db every night and recently started using ASM
> diskgroups for the auxiliary database instance. I've noticed that each
> time duplicate db runs, a new set of datafiles are created, leaving the
> datafiles from the previous run behind. I've set the db_create_file_dest
> to the ASM diskgroup. I was wondering if there would be a way to easily
> reuse / remove the old files, since its filling up my diskgroup.
> I'm investigating changing the datafile name format, so that it overwrites
> the files each time, instead of appending the incarnation number at the end
> that makes every file unique.
> I'd appreciate any tips / pointers to resolve this issue.
> Regards,
> IM
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


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

Received on Mon May 21 2012 - 09:01:48 CDT