![]() ![]() Physical backups are the foundation of any sound backup and recovery strategy. The Data Pump command-line clients expdp and impdp use the DBMS_DATAPUMP and DBMS_METADATA PL/SQL packages. You can use Oracle Data Pump to export logical data to binary files, which you can later import into the database. Logical backups contain logical data such as tables and stored procedures. ![]() Ultimately, every physical backup is a copy of files that store database information to another location, whether on disk or on offline storage media such as tape. These files include datafiles, control files, and archived redo logs. Physical backups are copies of the physical files used in storing and recovering a database. ![]() A backup can be either a physical backup or a logical backup. A backup is a copy of data of a database that you can use to reconstruct data. The purpose of this manual is to explain how to perform the preceding tasks.Īs a backup administrator, your primary job is making and monitoring backups for data protection. Recovering from data loss if the need arisesĪs a backup administrator, you may also be asked to perform other duties that are related to backup and recovery:ĭata preservation, which involves creating a database copy for long-term storageĭata transfer, which involves moving data from one database or one host to another Monitoring the backup and recovery environment Planning and testing responses to different kinds of failuresĬonfiguring the database environment for backup and recovery Typically, backup administration tasks include the following: In general, the purpose of a backup and recovery strategy is to protect the database against data loss and reconstruct the database after data loss. As a backup administrator, your principal duty is to devise, implement, and manage a backup and recovery strategy. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |