| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery Times
John P. Higgins wrote:
> I am interested in time-to-recover an Oracle database is various
> configurations. I hope some other people will volunteer their
> experiences. Here is mine:
>
> I had to recover a full database to a point-in-time. We had archived
> 111 redo log files between the last backup and the point-in-time.
> These redo files were 20 MB each, or a total of 2,220MB. The recovery
> took 23 minutes or 96.5 MB / minute.
>
> I later (through some dumbness on my part) had to recover an
> additional database file from the same 111 redo log files. This took
> only 8 minutes or 277.5 MB / minute.
>
> More recently, we had to do a pair of similar recoveries. We had since
> upped the redo log files to 200 MB each. However the MB / minute
> roughly matched the earlier experience.
>
> These timings were on an HP K450 box, HP-UX 10.20, EMC disk array.
>
> Considering the three hours it took to restore the database data
> files, I was fairly plesed with this rate of recovery.
>
> TIA for any thoughts.
you didn't mention version of Oracle, but starting late 7 releases you can use recovery_parallelism which would speed up the recovery even more, by having parallel slaves apply the redo read from log files.
--
__ _ _ __ _ _ _ _ ___ ______________________________ (( /\\ /\\ ||) |\V/| /\\ /\\ >/ Principal Performance Engineer_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Digital SBU
////////////////// Drop x's in email (spam) //////////////////////Received on Wed Nov 18 1998 - 15:12:10 CST
 |
 |