Re: Minimize recovery time

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 27 Apr 2022 18:55:51 -0400
Message-ID: <aed9d6ad-980c-8e3b-5cda-96d37afd248c_at_gmail.com>


On 4/27/22 06:34, Lok P wrote:
Yes we have dataguard setup , but this agreement is in place in case of both primary and dataguard DB fails because of disaster or corruption etc.

Is your standby on another Exadata or is it on a COTS machine like Dell or HP? It the latter is the case, you can use something like TimeKeeper, SnapVault or Hure (Hitachi Universal Replicator), which is much faster than traditional RMAN backup. Unfortunately, Oracle doesn't have anything like DB2 ACS which would enable cataloging the snapshots. You can use a commercial backup suite to facilitate snapshot backups. CommVault, Rubrik, Cohesity and Veeam can all manage snapshots.

You cannot use that if your standby is another Exadata. In that case, you need to configure several 10Gb Ethernet adapters and bond them into a single adapter. Single 10Gb adapter can achieve up to 3 TB/hour. With 4 10Gb bonded into a single interface you can achieve throughput of 12TB/hour. If your backup destination can write that fast, and you'll need a good SAN for that, you are fine.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
-- http://www.freelists.org/webpage/oracle-l Received on Thu Apr 28 2022 - 00:55:51 CEST

Original text of this message