Antwort: Backup VLDB's

  • From: "Martin Klier" <Martin.Klier@xxxxxxxxxx>
  • To: gnahmed.c@xxxxxxxxxx
  • Date: Tue, 10 Nov 2009 10:55:55 +0100

First impulse was to say: Split Mirror by storage.

--
Mit freundlichem Gruß


Martin Klier
Senior Oracle Database Administrator
------------------------------------------------------------------------------

Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.:  +49 9671/9216-245
Fax.: +49 9671/9216-112
mailto: martin.klier@xxxxxxxxxx
www.klug-is.de
------------------------------------------------------------------------------

Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg


|------------>
| Von:       |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |Nizar Ahmed <gnahmed.c@xxxxxxxxxx>                                           
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| An:        |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |Nizar Ahmed <gnahmed.c@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" 
<oracle-l@xxxxxxxxxxxxx>                                                        
     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Datum:     |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |10.11.2009 10:32                                                             
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Betreff:   |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |Backup VLDB's                                                                
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Gesendet   |
| von:       |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |oracle-l-bounce@xxxxxxxxxxxxx                                                
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|





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:

  • » Antwort: Backup VLDB's - Martin Klier