Performing manual user-managed backups in Oracle is often a best practice when the database is connected to a high-end storage device that supports volume snapshots or disk cloning. In this video, review the purpose and steps required to perform user-managed database backups.
- [Instructor] User-managed backup and recovery in Oracle…refers to any backup strategy…in which recovery manager, RMAN,…is not used to backup and recover the database.…User-managed backups is pretty much manual backups…that are often executed using operating system…or storage-based tools.…To perform user-managed online backups of our database,…that is, without downtime,…we start by enabling a special online backup mode…in our Oracle database.…
We do that by running…the alter database begin backup command,…followed by copying our database data files, control files,…and archived redo log files to our backup destination.…You can do this…by using operation system-based copy commands,…such as cp in Linux.…That's because combining…the Oracle database hot backup mode with storage snapshots…makes the most sense.…You can enable the database hot backup mode…and instead of copying the database files manually…to your backup destination,…which can take time,…you simply request your high-end storage device…to which your Oracle database is connected to…
- 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.