Skip to main content
Question

Best possible solution to reduce the restoration window for Oracle DB

  • November 26, 2024
  • 1 reply
  • 30 views

Forum|alt.badge.img+4
  • Vaulter
  • 9 replies

Hi Team,

My customer has large oracle DB 100 TB running on AIX power server and attached with Hitachi Storage. The DBs replicating to similar setup with block level replication. They configured the FS backup on replicated server and backing up DB (100 TB) as flat file using AIX FS agent. They restore the entire data to another AIX machine, storage space came from Dell storage on weekly basis.

The backup and restore handles by same seventeen-node HSX, the backup is completing by 5+ hours and restore take 25+ hours.

Currently we are trying to identify other possibilities to reduce the restoration window.

 

We had an idea to explore IntelliSnap, but I am curious to know is it possible to perform restore snapshot into Dell which was taken from Hitachi?

In this scenario, still data needs to travel over the network from source to target storage.

 

Can you suggest if you have any suggestion/input.  

 

1 reply

Damian Andre
Vaulter
Forum|alt.badge.img+23
  • Vaulter
  • 1287 replies
  • December 13, 2024

Yes you can restore an oracle database taken with a hardware snapshot and restore to dell but not with the performance benefits you are looking for. The process would be:

  1. Snap application
  2. Backup copy the data out of the snapshot to traditional media (e.g HSX disk)
  3. (optional) copy the data to a storage target closer to the dell
  4. Traditional restore back to the dell (this is a traditional disk library → server restore)

This helps accelerate protection but not recovery since you are performing the same type of restore in the end. Accelerating recovery with snapshots means reverting the snapshot (i.e overwriting production with another snapshot on the array) which is not possible out-of-place in your scenario.

Restoring 100GB in 25 hours is horrible performance at 4GB/hr. It sounds like something more fundamental is wrong with the infrastructure - either there is a network limitation/bottleneck or source disk read limitation on the HSX cluster, which seems unlikely, OR that dell disk is really slow.

I think in your case you should do large file copy tests to figure out if the bottleneck is the source, network or destination target (or a combo of both).

Since it sounds like you are already replicating the file system, have you considered replicating the database as well?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings