In order to perform point-in-time recovery, there are several required prerequisites. In this video, learn about enabling Archived Redo Log mode, the purpose of the Fast Recovery Area, and which Archived Redo Logs are required for point-in-time recovery.
- [Instructor] In order for us to be able…and perform point-in-time-recovery,…using a combination of database backups…and database archived read logs,…there's several prerequisites and configuration options…we need to configure.…Firs of all in order for archived read logs…to be generated in the first place,…we need to make sure our Oracle database…is set to ARCHIVELOG mode.…You can do that by shutting down your database,…starting it up in mount mode,…and running the alter database archivelog command.…
Following that you can open your database…using the alter database open command…and your database will now generated archived read logs.…This can also be configured during database creation.…Most if not all production Oracle databases…are presumably running with the archived log…mode option enabled.…By default archived read logs will be stored…in the directory,…specified via the db_recovery_file_dest parameter.…
You can also specify a maximum allowed size…of your archived read logs using…the db_recovery_file_dest_size parameter.…
- 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?
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.