1748181 Members
3997 Online
108759 Solutions
New Discussion юеВ

Re: Recovery time

 
SOLVED
Go to solution
TwoProc
Honored Contributor

Re: Recovery time

Correction, I just spoke with another co-worker(another dba) from our dept, and she says that the data that I remember is largely correct, except that back then, we used 400Meg files - not 500. So, it was an average of 400Mg/Min - not 500Mg/Min.
We are the people our parents warned us about --Jimmy Buffett
Yogeeraj_1
Honored Contributor

Re: Recovery time

hi,

on this setup:
RP5430 x 2
Oracle 8i + RMAN
100Mbps link

and
Database size 30GB
Archive log file size 25MB

we obtained the following results:
Full RMAN recovery = 2 hours
Archived Log recovery (x1) = 15mins

(NB. on the system where we were recovering, the datafiles are on internal disks whereas the source backup files are on a SAN and recovery done across the 100Mbps network connection to the source server)

hope this helps!
regards
yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Beno├оt
Regular Advisor

Re: Recovery time

Thanks guys!
This should be useful we more details to compare on my config.

The thing is that we were supposed to make that test on test rp8400 that just crashed.
So I try to get information on average speeds for that king of recovery besause I can't make that test right now.

To give you more information, my server as 6 CPU 750MHz and 6 GB of memory.
I think we have just one db-writer.

Maybe it would be just more simple to measure I/Os my production can produce...
How can I do that ?
Yogeeraj_1
Honored Contributor

Re: Recovery time

hi,

maybe glance and measureware can help you here!

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Volker Borowski
Honored Contributor

Re: Recovery time

Hi,

I asked nearly the same question here:
http://forums2.itrc.hp.com/service/forums/questionanswer.do?threadId=220331

Meanwhile I think it would be good to have a seperate configuration for recovery:

db_writers = num_cpus - 4
DB-buffers = 80% RAM

do parallel recovery (4)

May be do some tests to balance the CPUs between the parallel recovery processes and the db_writers.

Good luck
Volker