Every DBA is faced with challenges that could be easily addressed, if only there were enough money. I have rarely heard a DBA complain that a system had too much horsepower or enough disk space. There are certain technical limitations that dictate the type of backup and recovery plan that you implement. For example, one site I worked at had triple the amount of disk space that the database required. That made it easy for us to automate physical image copies of the disks to
alternate drives. We then backed up the copies to tape during the day and stored these tapes off site. Most sites don't have this luxury and have
to bring their databases down to execute a backup.
DBAs have to take all the technical aspects of the operation of their company's business into consideration. Some of the questions a DBA might ask are ?
- How much disk and data do I have? When will I run out of space?
- When will I need to upgrade my hardware platform? ?
- Do I need a standby database? ?
- What are the likely failure points within my current environment? ?
- What is my transactional mix?