Re: ASM Datafiles and RMAN duplicate db

From: Ls Cheng <exriscer_at_gmail.com>
Date: Sun, 20 May 2012 09:43:11 +0200
Message-ID: <CAJ2-Qb9vT34mi0fhaPNifK9yc+v=QVu3COiQs3=L_4owwBW1ZQ_at_mail.gmail.com>



how about use during duplicate run set newname in RMAN and set them to asm aliases?
regards

On Sun, May 20, 2012 at 7:30 AM, Imtiaz Merchant <merchanti_at_hotmail.com>wrote:

> 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
Received on Sun May 20 2012 - 02:43:11 CDT

Original text of this message