RE: 11.2 CRS with 10g Database

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <oracle@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 18 Apr 2012 08:24:52 -0400

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


Other related posts: