Re: Duplicate function is a lot longer than a backup

  • From: Michael Fontana <michael.fontana@xxxxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Mon, 30 Nov 2009 13:06:07 -0600 (CST)

Execute the rman command "show all;" on the source database and present the 
output here.

It would also be useful to know how much memory, how much CPU is available on 
the target;  We could
therefore give you ways to exploit multiple CPU and larger memory structure to 
get the restore done quicker.

Just because the machines are identical hardware-wise doesn't mean they are 
configured the same.   Look at Windows
system configuration for number of CPU and memory, and swap space, etc.  All of 
these could impact run time.

----- Original Message -----
From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "Brandon Allen" 
Sent: Monday, November 30, 2009 12:51:59 PM GMT -06:00 US/Canada Central
Subject: RE: Duplicate function is a lot longer than a backup

We have one channel configured. 

Backups are on disk. 

Servers are identical. 

Compression is being used for the backups. 

Jeffrey Beckstrom 
Database Administrator 
Greater Cleveland Regional Transit Authority 
1240 W. 6th Street 
Cleveland, Ohio 44113 

>>> "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx> 11/30/09 1:37 PM >>> 

A few questions come to mind: 

Are you backing up to disk or tape? 

What degree of parallelism (i.e. how many concurrent channels) for both the 
backup and the restore/duplicate? 

Is the disk or CPU significantly slower on the target server? 

Are you using compression? 



Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it. 


Michael Fontana 

Sr. Technical Consultant 

Enkitec M: 214.912.3709 




Other related posts: