Operating System - HP-UX
1747988 Members
4880 Online
108756 Solutions
New Discussion юеВ

Re: ORACLE Recovery times - share your experience

 
SOLVED
Go to solution
Volker Borowski
Honored Contributor

ORACLE Recovery times - share your experience

Hi,

I need to estimate a time range for an Oracle database recovery.
I alread did some recovery on a 4 way L-Server where I achieved roughly 10GB/h (no media transfer involved, just the time to apply already restored redologs). Now is this good or bad ?
Please share your experience.

Machine, num-CPU, configured SGA Mem, Redo-GB per hour/minute.

Thanks for feedback
Volker
17 REPLIES 17
Joaquin Gil de Vergara
Respected Contributor

Re: ORACLE Recovery times - share your experience

it depends!

(size of DB, type of crash...)

sometimes recovery is very fast.... in others you need reencarnate database and process is more delicated....

but... usually when you issue the "recover database" from sqlplus or svrmgrl, recovery is successfull and quite fast! (I talk from my experience of course!)

good luck!
Teach is the best way to learn
Robert-Jan Goossens
Honored Contributor
Solution

Re: ORACLE Recovery times - share your experience

Hi Volker,

10 GB/H is good, just did a recovery got 7200 MB/H (2MB/s) with media involved (DLT8000)

Robert-Jan.
Volker Borowski
Honored Contributor

Re: ORACLE Recovery times - share your experience

OK,

I see the database size is a point I missed.
I talk about a database which will be initially 750GB in size and which will grow about 50GB a month. SO anything around one TB will be a good reference for me, but you are invited to share your experience for smaller databases as well.

My above mentione sample was taken from a 250GB database and ~40GB redolog applied within 4 Hours ( -> 10GB/h). So perhaps you could mention the size of your database as well.

I guess esp. those people working with shadow-databases might be interested in these values as well, because you might find out, that somebody is faster than you for some reason :-)

So once again, please share.
Thanks
Volker
Robert-Jan Goossens
Honored Contributor

Re: ORACLE Recovery times - share your experience

Ok did not know you are talking about the big ones (:-) my example was a small one without shadow databases (22 GB). For the large ones we use shadow databases.

RJ
Alexander M. Ermes
Honored Contributor

Re: ORACLE Recovery times - share your experience

Hi there.
Guys, this depends on some factors :
backup machine
- one tape drive against several
- backup software allowing parallel restore
with several drives
- organization of backup ( filesystems order on tape )

- type of recover ( complete, partial, tablespace etc )

I had to restore a 20 GB database this morning.
restore took approx. 1h 45 minutes.
Recovery withing the database ( recover until time ) and rest of tasks took 15 minutes, so after two hours we were back to business.

Volker, your time is ok. If it should take longer, think about the points i just mentioned.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
doug mielke
Respected Contributor

Re: ORACLE Recovery times - share your experience

We clone our 100 gig or so database weekly to offer as a user test instance.

Recovering from hot backup, followed by the application of about 6 hours of archive logs, ( a dozen or so, 32MG each) xfer over 100 mb ethernet to a NAS filer takes about 4 hours.
Steven E. Protter
Exalted Contributor

Re: ORACLE Recovery times - share your experience

D320, 750 MB RAM. 8.1.7 32 Bit HP-UX 11.00

Disk failure while Oracle was running cold backup. Restored from a fuzzy backup taken by omniback a few hours earlier. It took two days to bring the one congtainer online. Oracle said it would never come online, they were wrong.

Practice:

rp5450 2GB RAM. 11.11 64 Bit OS. 8.1.7.4.0

2 Hours for recovery and roll forward after a proper cold backup and transactions.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Indira Aramandla
Honored Contributor

Re: ORACLE Recovery times - share your experience

Hi,

Datbase recovery 10 GB/H is good.

We do a resore and apply redo logs of 13 GB database every month and it takes 1 hour and 35 minutes. This time involves restoring from
media (DLT7000) as well.


Never give up, Keep Trying
Indira Aramandla
Honored Contributor

Re: ORACLE Recovery times - share your experience

Hi,

10GB/H is good.

We do the a restore and recover to a point in time to our DR site every month and here are the stats.

Server Model : 9000/800/K360
RAM : 2 GB
Media : DLT7000
RDBMS : Oracle 7.3.4

To restore and recover the database of 13 GB it tables 1 hour 35 minutes (media time included).

Server model :9000/800/L1500-7x ith
RAM : 2 GB
Media :LTO-Ultrium
RDBMS : oracle 8.1.7.4


To restore and recover the database of 13 GB it tables 1 hour 25 minutes (media time included).

Never give up, Keep Trying