Restore/Duplicate takes a lot longer to restore than backup

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
  • Date: Wed, 06 Jan 2010 14:34:17 -0500

We are doing a compressed backup of a 200G database in about 2 hours.  When we 
run the duplicate command, we copy the production backup files to the local 
disks of the target server.  We then run the RMAN duplicate command and it 
takes over 6 hours.  Is it reasonable that a restore/duplicate from a 
compressed backup takes that much longer than the actual backup?  Is there 
anything that can be done to speed up the process?
 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

Other related posts: