Nice, The 'template' is fairly small... so the duplication is fast -- which is why I keep it around. Most of my new databases start out small, so I just add descriptive tablespace (names) and I'm ready to roll. They start out at about 3Gbs (just a wee bit smaller... than your site) :) Joel Patterson Database Administrator 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Norman Dunbar Sent: Wednesday, April 18, 2012 8:03 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: 11.2 CRS with 10g Database On 18/04/12 12:50, Joel.Patterson@xxxxxxxxxxx wrote: > I have a 'template' database -- for the repeatable process -- and just use > rman duplicate to create a new database... add a new tablespace(s) for taste. > Its repeatable and all the scripts have already been run. Seems to work > pretty easily -- a couple of additions like executing a new RMAN > configuration, scheduling cron backup... but almost entirely self contained. My favourite at the moment is 11g RMAN's "duplicate ... from active database' command. No need for a backup, and pretty quick over the network as well. I've got two copies of a 6.5 TB databases cloned already, and today, I'm doing another. :-) Cheers, Norm. PS. You have my old work email address there, it's now norman.dunbar (at) capgemini.com. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l