ASM Datafiles and RMAN duplicate db
- From: Imtiaz Merchant <merchanti@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 20 May 2012 01:30:26 -0400
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
Other related posts:
