How many of you do shutdown your EBS PROD to make a clone?
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Thu, 11 Jun 2009 15:51:56 +1000
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:
