Re: How many of you do shutdown your EBS PROD to make a clone?

  • From: Charlene Huang <charleneh68@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Wed, 10 Jun 2009 23:08:50 -0700

Not for us. We never shutdown prod for cloning. I have worked for EMC
and Symantec in the past. So far we always use snap backup (hot) for
cloning.

Charlene

On Wed, Jun 10, 2009 at 10:51 PM, Jurijs
Velikanovs<j.velikanovs@xxxxxxxxx> wrote:
> Hi List,
>
> Just a quick question. Would you mind to at least answer YES or NO
> (any comments are welcome).
> Do you shutdown your EBS production database for cloning purposes?
>
> My answer is: Never! In fact I think it is an awful idea to shutdown
> you production for cloning proposes for the following reasons:
> 1. You introduce unnecessary downtime to a system users. You can use
> hot backups instead.
> 2. You miss a brilliant opportunity to test your recovery (including
> recovery time regular assessment, and DBA training).
> 3. You flush all you cache (shared and "buffer" pool). It will
> slowdown your processes after you start you instance up.
> On the other hand I don't see any benefits!
>
> PS I was told that even big EBS shops shutdown their systems to make
> cold backups. Definitely not the systems that my team is responsible
> for :)
>
> Yury
>
>

Other related posts: