Re: Backup VLDB's

  • From: hrishy <hrishys@xxxxxxxxxxx>
  • To: gnahmed.c@xxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Nov 2009 09:59:12 +0000 (GMT)

Hi Nizar
 
The fastest way depends solely upon how many dollars can you spend ;-).
 
You have couple of options to speed backups.
 
a)Use rman change tracking file and then use it to make incremental merges.
(cons is you need 15TB+ space to keep the backups)
http://www.oracle.com/technology/pub/articles/10gdba/week9_10gdba.html
b)Use snapshot backup feature like EMC BCV or netapps snapshot 
(they would again cost $$)
 
regards
Hrishy


--- On Tue, 10/11/09, Nizar Ahmed <gnahmed.c@xxxxxxxxxx> wrote:


From: Nizar Ahmed <gnahmed.c@xxxxxxxxxx>
Subject: Backup VLDB's
To: "Nizar Ahmed" <gnahmed.c@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" 
<oracle-l@xxxxxxxxxxxxx>
Date: Tuesday, 10 November, 2009, 9:00








All,
 
I have a 15 TB ODS – Operation Data Store. It is not a warehouse and the store 
is updated in real time from various OLTP's. All schemas are write intensive. 
Tables hold 5 million to 600 mullion rows of dat.
 
DB runs on a 4 node 10G-R2 RAC.
 
What is the best and fastest way to backup this database?
Speed / Time consumed would be a critical factor.
 
We have always used RMAN – Level 0 backup runs for 20 – 22 hours.
 
Thanks for all your ideas.
 
G. Nizar A. Baig 
 This email may contains confidential material, any unauthorized usage is 
strictly prohibited and may lead into Legal accountability. If it is received 
by mistake, it should be deleted and the sender should be notified immediately. 
هذه الرساله قد تحتوي على معلومات سريه لذا فإن أي استخدام لأي من محتوياتها بشكل 
غير نظامي يعتبر أمراً مخالفاً وقد يؤدي إلى المسائلة القانونية، وفي حال استلام 
البريد الالكتروني بشكل خاطئ فإنه يجب حذفه وإبلاغ المرسل بشكل مباشر 
The information in this email may contain confidential material and it is 
intended solely for the addresses. Access to this email by anyone else is 
unauthorized. If you are not the intended recipient, please delete the email 
and destroy any copies of it, any disclosure, copying, distribution is 
prohibited and may be considered unlawful. Contents of this email and any 
attachments may be altered, Statement and opinions expressed in this email are 
those of the sender, and do not necessarily reflect those of Saudi 
Telecommunications Company (STC). 
قد يحتوي هذا البريد الالكتروني على معلومات سرية موجهة إلى الأشخاص المرسلة لهم 
فقط ولا يصرح لأي شخص آخر الاطلاع عليها، وفي حال استلام هذا البريد الالكتروني 
بشكل خاطئ فإنه يجب حذفه وإبلاغ المرسل بشكل مباشر. وأي تسريب لتلك المعلومات أو 
نسخها أو نشرها يعد أمراً مخالفاً وقد يؤدي إلى المسائلة القانونية، كما أن الآراء 
المذكورة بهذا البريد تمثل رأي مرسلها ولا تعبر بالضرورة عن رأي شركة الاتصالات 
السعودية 


      

Other related posts: