Data Pump provides capabilities to monitor and control import and export jobs in real time, such as the ability to view running jobs and stop specific expdp or impdp processes from executing.
- [Instructor] Data Pump also provides us…with the capabilities to monitor and even control…export and import jobs while they are executing.…For example, we can track the progress…of any individual Data Pump job…and even decide to terminate it…while it is still running if needed.…Let's see an example of this in action.…For our example, I'll need two terminal windows open.…In one window, I'll execute an export command…and in the other window,…I'll run a query against a database view…that allows me to monitor…the progress of running Data Pump jobs.…
You can find the export command that we'll need to execute…included in your exercise file…so let's copy this command…and paste it into our top terminal window.…In order for this export…to run in a sufficiently long enough time…for us to monitor its progress while it's running,…I'm choosing to perform a full export…of the demo_pdb pluggable database…including all of its schemas.…
This is done by the full=y flag.…Let's execute the command.…As the export is running,…let's open a SQL*Plus session in our bottom terminal window…
- 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
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.