Database recovery time

From: Wolfson Larry - lwolfs <>
Date: Fri, 2 Nov 2012 06:47:14 +0000
Message-ID: <>

Hope everyone had a great Halloween, but I had to recover a large multi-terabyte database. While experienced with recoveries, we rarely do many anymore. Fortunately this DB was running and I am also familiar with the rman   LIST FAILURE;
Etc. commands
Unfortunately I had no experience with this database. I found I had to recover about 20 of 600 equal sized datafiles. There was no standby or flash recovery area. However, the level zero, one backups and archives were all on disk.

Just wondering if there was some quick ROT of when it would be faster to restore the whole database versus some number of datafiles.

I restored the 20, recovered them and was trying to verify the times with the query   SELECT REPAIR_ID

But the times here never showed anything but zeros. Anywhere I missed?

And researching I came across this parameter to speed up the backup read rate and was wondering if many people found success with it?



The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

Received on Fri Nov 02 2012 - 07:47:14 CET

Original text of this message