Podcast
Questions and Answers
What is the primary purpose of backing up data in a data warehouse?
What is the primary purpose of backing up data in a data warehouse?
What type of backup involves shutting down the database?
What type of backup involves shutting down the database?
What is the main advantage of partial backup?
What is the main advantage of partial backup?
What factors affect the speed of processing backup and restore?
What factors affect the speed of processing backup and restore?
Signup and view all the answers
What type of backup is similar to hot backup?
What type of backup is similar to hot backup?
Signup and view all the answers
What is the purpose of choosing the right hardware for backup?
What is the purpose of choosing the right hardware for backup?
Signup and view all the answers
What is the primary difference between hot and cold backups?
What is the primary difference between hot and cold backups?
Signup and view all the answers
What is the main benefit of using complete backup?
What is the main benefit of using complete backup?
Signup and view all the answers
What is the capacity of DLT tape media?
What is the capacity of DLT tape media?
Signup and view all the answers
What is the primary function of a tape stacker?
What is the primary function of a tape stacker?
Signup and view all the answers
What is a factor to consider when selecting a tape medium?
What is a factor to consider when selecting a tape medium?
Signup and view all the answers
How can standalone tape drives be connected to a server?
How can standalone tape drives be connected to a server?
Signup and view all the answers
What is a challenge in connecting tape drives to a data warehouse?
What is a challenge in connecting tape drives to a data warehouse?
Signup and view all the answers
What is the I/O rate of 8 mm tape media?
What is the I/O rate of 8 mm tape media?
Signup and view all the answers
What is a consideration when upgrading a tape system?
What is a consideration when upgrading a tape system?
Signup and view all the answers
What is the capacity of 3490e tape media?
What is the capacity of 3490e tape media?
Signup and view all the answers
What is a common feature among tape silos, disk backups, and optical jukeboxes?
What is a common feature among tape silos, disk backups, and optical jukeboxes?
Signup and view all the answers
What is the primary advantage of disk-to-disk backups?
What is the primary advantage of disk-to-disk backups?
Signup and view all the answers
What is the purpose of mirror breaking?
What is the purpose of mirror breaking?
Signup and view all the answers
What is a drawback of optical jukeboxes?
What is a drawback of optical jukeboxes?
Signup and view all the answers
What is the primary purpose of software backups?
What is the primary purpose of software backups?
Signup and view all the answers
What is a characteristic of tape silos?
What is a characteristic of tape silos?
Signup and view all the answers
What is a benefit of disk-to-disk backups?
What is a benefit of disk-to-disk backups?
Signup and view all the answers
What is a characteristic of optical media?
What is a characteristic of optical media?
Signup and view all the answers
Study Notes
Data Warehousing Backup
- A data warehouse is a complex system that requires a backup strategy to ensure data availability for recovery in the future.
- Backup terminologies:
- Complete backup: backs up the entire database at once, including all files, control files, and journal files.
- Partial backup: does not create a complete backup of the database, useful for large databases.
- Cold backup: taken when the database is completely shut down.
- Hot backup: taken when the database engine is up and running, with varying requirements depending on the RDBMS.
- Online backup: similar to hot backup.
Hardware Backup
- The choice of hardware affects the speed of processing backups and restores.
- Hardware options:
- Tape technology
- Disk backups
Tape Technology
- Tape media options:
- Capacity and I/O rates:
- DLT: 40 GB, 3 MB/s
- 3490e: 1.6 GB, 3 MB/s
- 8 mm: 14 GB, 1 MB/s
- Other factors to consider:
- Reliability of tape medium
- Cost of tape medium per unit
- Scalability
- Cost of upgrades to tape system
- Cost of tape medium per unit
- Shelf life of tape medium
- Capacity and I/O rates:
- Standalone tape drives:
- Can be connected directly to the server, as network available devices, or remotely to other machines.
- Issues with connecting tape drives to a data warehouse, including node selection and optimal performance.
- Tape stackers:
- Load multiple tapes into a single tape drive, allowing for unattended backups.
- Prices and capabilities vary.
- Tape silos:
- Provide large storage capacities, storing and managing thousands of tapes.
- Can integrate multiple tape drives, with software and hardware for labeling and storing tapes.
- Often connected remotely over a network or dedicated link.
Disk Backups
- Methods:
- Disk-to-disk backups
- Mirror breaking
- Used in OLTP systems to minimize database downtime and maximize availability.
- Disk-to-disk backups:
- Faster than tape backups
- Advantage of having an online copy of the latest backup
- Mirror breaking:
- Have disks mirrored for resilience during the working day.
- Break out one of the mirror sets for backup.
- May require database shutdown to ensure consistency.
Optical Jukeboxes
- Allow data to be stored near line.
- Manage a large number of optical disks like a tape stacker or tape silo.
- Drawback: slow write speed compared to disks.
- Advantages: long-life and reliability, making them suitable for archiving.
Software Backups
- Software tools are available to aid in the backup process.
- These tools come as a package.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn about the importance of backing up data in a data warehouse and designing a backup strategy. Understand complete backup, incremental backup, and other backup terminologies.
