RE: ASM Datafiles and RMAN duplicate db

From: <Joel.Patterson_at_crowley.com>
Date: Mon, 21 May 2012 09:50:23 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1B95AAE128_at_JAXMSG01.crowley.com>



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 Received on Mon May 21 2012 - 08:50:23 CDT

Original text of this message