Re: ASM Datafiles and RMAN duplicate db
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Mon, 21 May 2012 15:01:48 +0100
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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Imtiaz Merchant
> Sent: Sunday, May 20, 2012 1:30 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
