Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle backups
We are researching a backup strategy for an Oracle 8 database that is roughly
20 gig and expected to grow dynamically. We are in the music distribution
business (cd's) and will probably need 24x7 availability at least 6 days a
week, with Sundays off or low volume. Our hardware configuration is HP 9000
running HP-UX, version 10.10. We have Omniback II available in-house and have
downloaded the freeware RMAN from Oracle. Oracle is running in archivelog
mode. We are very interested in the possibility of doing hot backups daily
during the week and a full cold backup on the weekend.
Assumptions we've made based on information gathered are:
1. Omniback is a dependable product. 2. Cold backups using Omniback are very dependable. 3. Daily hot backups using Omniback are dependable when database running inarchivelog mode and mirroring the archivelog filesystem. 4. Hot backups should be made disk-to-disk and then backed up from tape.
Questions:
1. Are these assumptions correct? 2. How long does a hot backup take to run? 3. Do we need to do any additional in-house development such as pre/postscripts?
All responses or suggestions will be much appreciated.
Greg Smith
Alliance Entertainment
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 08 1998 - 16:03:16 CDT