Figure 103 Overview of backup and automated media copy sessions

Example 2: automated media copying of Oracle database backups

Your company has an Oracle database of the size of 500 GB. You want to perform a full backup of the database daily. The backup must be performed outside the company's working hours, which means that it can start after 5 PM and must finish before 8 AM on the next day; it can also run during weekends.

You use automated media copying to make copies of the backup media, which will remain on site for restore purposes. The originals will be moved to an off-site vault for safety reasons. The media should be copied after the backup finishes. To do this, you will use post-backup media copying.

You use an HP StorageWorks 10/700 Tape Library with 10 LTO drives, and LTO Ultrium 1 media. Based on previous experience, you assume that the data transfer rate is about 80 GB per hour, and the average capacity of a medium is 153 GB.

The media used for backup and media copying become non-appendable after the media copy operation, so you may want to use as much tape space as possible. On the other hand, you want the backup to finish as soon as possible. You use 4 devices for the backup. It is recommended to start with empty media and use their maximum capacity.

Automated media copying starts after the backup is completed. You have 4 media to copy, so you use 8 devices for the operation. This means that 4 devices will be used for source media, and 4 devices for target media.

It is assumed that the media copying will take approximately the same amount of time as the backup.

338

Further information