Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow Restore of a Compressed Backup

680616Jan 19 2009 — edited Feb 23 2009
All,

I am seeing a strange behavior when restoring a compressed backup for standby duplication.

The target and auzillary database version is 11.1.0.6 Enterprise Edition
The size of the database uncompressed is 131.41G
The Size of the compressed Full Backup is 58.21G


The Duplication script is as follows:

run {
SET NEWNAME FOR DATAFILE 1 TO '+DGROUPDATA1';
SET NEWNAME FOR DATAFILE 10 TO '+DGROUPDATA1';
SET NEWNAME FOR DATAFILE 100 TO '+DGROUPS1V1';
SET NEWNAME FOR DATAFILE 101 TO '+DGROUPS1V1';
SET NEWNAME FOR DATAFILE 102 TO '+DGROUPS1V1';
.
.
.
DUPLICATE TARGET DATABASE FOR STANDBY
NOFILENAMECHECK;
}


From the alert log on the standby during the recovery process I see that a 4GB file recovery takes a little more than an hour:

Full restore complete of datafile 66 to datafile copy +DGROUPRPRTRDATA1/mpstndby/datafile/reporter_data1.269.676544573. Elapsed time: 1:03:45


Is there anyway to speed up the recovery process from a compressed backup?

Thanks,

Robert
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2009
Added on Jan 19 2009
6 comments
1,255 views