Re: ASM Datafiles and RMAN duplicate db

From: Niall Litchfield <>
Date: Mon, 21 May 2012 15:01:48 +0100
Message-ID: <>

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, <> 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: []
> On Behalf Of Imtiaz Merchant
> Sent: Sunday, May 20, 2012 1:30 AM
> To:
> 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
> --
> --

Niall Litchfield
Oracle DBA

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

Original text of this message