RE: How many of you do shutdown your EBS PROD to make a clone?
- From: "kathy.robb" <kathy.robb@xxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Thu, 11 Jun 2009 06:51:36 -0600
I know some people do, but never ever is our answer, too.
-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs Velikanovs
Sent: Wednesday, June 10, 2009 11:52 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: How many of you do shutdown your EBS PROD to make a clone?
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:
