Each Data Pump export and import creates a log file that can be used for troubleshooting. In this video, learn how to use the LOGFILE parameter as part of your expdp command to specify the location of the Data Pump log file. Also learn how to review the log file in case of errors.
- [Instructor] When performing data pump exports or imports,…it's often useful to look at the log file…that would be created and diagnose any errors…if they occur.…The data pump log file will be created…in the same directory where the export dump file itself…will be created.…You can choose the name of the data pump export…or import log file by using the log file parameter.…Let's see an example.…
Let's run the expdp utility.…So we're going to perform a data pump export.…Specify a username and password,…system slash oracle, in our case.…Specify that you want to export the Scott schema.…So we'll type schemas equals Scott.…Specify a name for the dump file.…So dumpfile equals scott01 dot dmp,…and specify the name for the export log file.…
So log file equals scott01 underscore exp dot log.…We can of course choose any name we want for the log file.…Let's run our export.…While the export is running, various useful information…will be displayed on the screen.…Because we have specified an explicit log file name,…this information would also be mirrored…
- Complete vs. incomplete recovery
- Point-in-time recovery
- Failure categories
- Preparing the virtual machine
- Performing user-managed backups
- Restoring from manual backups
- Performing full and incremental backups with RMAN
- Recovering a PDB and CDB
- Exporting and importing data with Oracle Data Pump
- Performing logical backups with Data Pump
- Using Flashback Query, Table, and Database
- Creating restore points
Skill Level Intermediate
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
1. Backup and Recovery Core Concepts
2. Failure Categories and Backup Types
3. Preparing the Course VM
4. User-Managed Backups
5. Recovery Manager (RMAN)
6. Oracle Data Pump
7. Oracle Flashback
What's next?2m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.