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

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_at_gmail.com> 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_at_gmail.com>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_at_gmail.com> 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