Any way to speed up Oracle restore ?

Availability for the Always-On Enterprise

Any way to speed up Oracle restore ?

Veeam Logoby cxwsrei » Wed Jul 05, 2017 9:36 am

I´m testing oracle recovery.
The system is based on Linux (SLES11) and Oracle 12.
I ran a restore of a 500 GB database .
This took about 5 hrs.
It appeared as if ONE stream (only) restores/rewrites the databse files serially.
Is there any way to speed up the restore (parallelism e.g.) ?
cxwsrei
Influencer
 
Posts: 16
Liked: 1 time
Joined: Mon May 22, 2017 1:18 pm

Re: Any way to speed up Oracle restore ?

Veeam Logoby jazzoberoi » Thu Jul 06, 2017 4:39 am

I just did my first Oracle DB restore and found that the restore were slow as well. Its almost a blank database of only 10 GB and still took around 20mins restoring.

Will there be any restore speed enhancements in v10 ?
jazzoberoi
Enthusiast
 
Posts: 64
Liked: 13 times
Joined: Wed Oct 08, 2014 9:07 am
Full Name: Jazz Oberoi

Re: Any way to speed up Oracle restore ?

Veeam Logoby Gostev » Thu Jul 06, 2017 9:36 pm

Checking with the devs...
Gostev
Veeam Software
 
Posts: 21603
Liked: 2405 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Any way to speed up Oracle restore ?

Veeam Logoby A.Stepanov » Wed Jul 12, 2017 2:38 pm

cxwsrei wrote:I ran a restore of a 500 GB database .

How many data files are in your database?
Are they in the file system or ASM?
A.Stepanov
Veeam Software
 
Posts: 1
Liked: never
Joined: Wed Jun 20, 2012 6:12 am

Re: Any way to speed up Oracle restore ?

Veeam Logoby jazzoberoi » Fri Aug 18, 2017 12:45 am

Hi,

The database files total only 12.5 GB and it took almost 15 mins to do a restore.

Image

Image

The restore target is another VM on a Filesystem.
jazzoberoi
Enthusiast
 
Posts: 64
Liked: 13 times
Joined: Wed Oct 08, 2014 9:07 am
Full Name: Jazz Oberoi

Re: Any way to speed up Oracle restore ?

Veeam Logoby foggy » Wed Aug 23, 2017 2:20 pm

We're looking into the ability to improve restore using parallel streams, but the smaller the DB is, the tinier effect parallelism will have, since auxiliary operations (such as mount, mode switching through RMAN, etc.) will take time comparable to restore itself. Anyway, logs should tell the exact operations that take long, so I'd appreciate if you open a case with our technical support and share the ID here, so I could point the right people directly to your log files.
foggy
Veeam Software
 
Posts: 15272
Liked: 1131 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: DaveWatkins, Google Feedfetcher, sg1 and 5 guests