Taking regular backups of your control files and archived redo logs is as important as backups of your datafiles when performing user-managed backups. In this video, learn how to use the ALTER DATABASE BACKUP CONTROLFILE command and how to identify the archived redo logs that should be part of your backup.
- [Instructor] In addition to performing online backups…of your database data files as we did in our previous video,…you will also need to take a backup…of the database control file.…To do that, we need to connect to the root container,…so we'll type quit, open SQL Plus again,…as assisted BA user, connect into the root container.…You can verify that by typing show con_name,…and run the older database backup control file…and a destination where we want oracle…to create a control file backup.…
You can can find this command included…in your exercise file, so let's copy this command…and paste it to our SQL Plus window.…Pressing enter, we'll initiate a backup…of the control file and store it in the following path.…You can of course change this path to…whatever is appropriate in your own environment.…Remember to keep these control file backup safe…as you'll need it to recover a database.…Remember that in a production or an environment…the location to where you backup move your control file…as well as your data files, as we did in our previous video,…
- 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.