RE: 11.2 CRS with 10g Database

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Norman Dunbar Sent: Wednesday, April 18, 2012 8:03 AM
To: oracle-l_at_freelists.org
Subject: Re: 11.2 CRS with 10g Database

On 18/04/12 12:50, Joel.Patterson_at_crowley.com 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
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l