Re: what is the main purpose of cloning a database.

Hehe,  I was just about to mention that.

We prove our RMAN backups to tape work just about every day when we refresh
test/staging/development/UAT databases
Including every now and than a year old backup where tapes have to be
brought back in and inserted into the tape unit.

Quite comforting knowing you can restore your data

Jack

2008/12/18 Niall Litchfield <niall.litchfield@xxxxxxxxx>

> I'm a little suprised that all the discussion has focussed on creating
> test databases.  The dba can often get away with murder, they cant get
> away with failure to recover data. Database cloning both tests and
> demonstrates that your backups can be recovered and in a reasonable
> time frame. Or of course sometimes not.
>
> On 12/17/08, nilesh kumar <nileshkum@xxxxxxxxx> wrote:
> > Thank you very much for your suggestions,help and support. Its a great
> group
> > with lot of expertise.
> >
> > Nilesh
> >
> > On Wed, Dec 17, 2008 at 11:46 PM, Howard Latham
> > <howard.latham@xxxxxxxxx>wrote:
> >
> >> unless its a small database Say <80g then shut it down copy it !
> >> Simple if you can get away with it
> >> > On 12/17/08, Dennis Williams <oracledba.williams@xxxxxxxxx> wrote:
> >> > > Nilesh
> >> > >
> >> > > 1. Some databases are so large that cloning is the only method of
> >> creating a
> >> > > test database.
> >> > > 2. Before a production change is made, it is recommended that change
> >> > > be
> >> made
> >> > > in a test database and then tested. This can avoid the awkward
> >> situation of
> >> > > production changes that need to be backed out. Cloning produces an
> >> exact
> >> > > copy of the production database.
> >> > >
> >> > > Dennis Williams
> >> > >
> >> > --
> >> > http://www.freelists.org/webpage/oracle-l
> >> >
> >> >
> >> >
> >>
> >>
> >> --
> >> Howard A. Latham
> >> --
> >> http://www.freelists.org/webpage/oracle-l
> >>
> >>
> >>
> >
> >
> > --
> > Soni
> > Temples & Softwares are more or less the same, first we build them and
> then
> > we pray ;)
> >
>
> --
> Sent from Google Mail for mobile | mobile.google.com
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>  --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
J.A. van Zanen

Other related posts: