416 Oracle Database 11g DBA Handbook
Regardless of your choice for primary backup method, the final implementation should include
a physical backup and some sort of logical backup, either via Data Pump Export or via replication.
This redundancy is necessary because these methods validate different aspects of the database:
Data Pump Export validates that the data is logically sound, and physical backups that it is
physically sound. A good database backup strategy integrates logical and physical backups. The
frequency and type of backup performed will vary based on the database??™s usage characteristics.
Other database activities may call for ad hoc backups. Ad hoc backups may include offline
backups before performing database upgrades and exports during application migration between
databases.
Integration of Database and Operating System Backups
As described in this chapter, the DBA??™s backup activities involve a number of tasks normally
assigned to a systems management group: monitoring disk usage, maintaining tapes, and so
on. Rather than duplicate these efforts, it is best to integration them; focus on a process-based
alignment of your organization. The database backup strategy should be modified so that the
systems management personnel??™s file system backups will take care of all tape handling, allowing
you to centralize the production control processes in your environment.
Centralization of production control processes is usually accomplished by dedicating disk
drives as destination locations for physical file backups.
Pages:
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649