- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORACLE Recovery times - share your experience
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 01:32 AM
тАО08-07-2003 01:32 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 01:40 AM
тАО08-07-2003 01:40 AM
Re: ORACLE Recovery times - share your experience
(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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 01:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 01:52 AM
тАО08-07-2003 01:52 AM
Re: ORACLE Recovery times - share your experience
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 01:58 AM
тАО08-07-2003 01:58 AM
Re: ORACLE Recovery times - share your experience
RJ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 04:31 AM
тАО08-07-2003 04:31 AM
Re: ORACLE Recovery times - share your experience
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 05:27 AM
тАО08-07-2003 05:27 AM
Re: ORACLE Recovery times - share your experience
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 05:40 AM
тАО08-07-2003 05:40 AM
Re: ORACLE Recovery times - share your experience
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 09:33 PM
тАО08-07-2003 09:33 PM
Re: ORACLE Recovery times - share your experience
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 09:41 PM
тАО08-07-2003 09:41 PM
Re: ORACLE Recovery times - share your experience
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).