In this module, we briefly reviewed the Export and Import utilities with a view to a backup and recovery strategy.
These utilities have many other uses that go beyond this short discussion.
Using the Export and Import utilities should not be your sole backup and recovery strategy. These utilities may have a place in a
larger backup and recovery plan.
Now that you have completed this module, you should be able to:
Describe the functions of the Export and Import utilities
Explain how to use Export
Use EXPORT to perform a complete backup
Use Export for incremental and cumulative backups
Discuss the direct path method of using Export
Use Import to restore database information
For further insight into the possible uses of Export and Import, read the Oracle documentation set. You will also need to review
the documentation for all the possible parameter options that can be used with Export and Import.
The following terms were introduced in this module:
- Full mode: An export of the entire database. There are three options: complete, cumulative and incremental.
- Logical backup: Where you copy information from your database to a file with no regard to the physical location of data.
- Physical backup: Where you copy information from your database to a file with physical block location information stored in the backup file.
In the next module, you will learn about one of the main tools for backup and recovery - the Recovery Manager, also known as RMAN.