Book Image

Oracle Database Backup and Recovery Using RMAN [Video]

By : Ahmed Baraka
Book Image

Oracle Database Backup and Recovery Using RMAN [Video]

By: Ahmed Baraka

Overview of this book

Information presented in this course provides Oracle Database Administrators with the knowledge and experience to perform backup and recovery activities on Oracle databases. Starting with the Oracle RMAN architecture, you will seamlessly progress from fundamental database backups to the implementation of advanced options. Then, you will discover and practically execute diverse RMAN backup strategies, covering whole/partial, full/incremental, complete/incomplete, and online/offline backups. Dive into advanced options such as compression, encryption, multisection, duplexing backups, and archival backups for a holistic understanding. You will also simulate common recovery scenarios, from critical file losses to application data and non-critical file losses. Uncover additional RMAN capabilities such as the RMAN Recovery Catalog, cross-platform data transportation, and database cloning, ensuring a comprehensive skill set. Beyond technical proficiency, you will gain insights into developing effective backup and recovery plans with a focus on best practices. Stay abreast of cutting-edge technology with coverage of Oracle’s latest advancements, including the Oracle Database Backup Cloud Service. By the end of the course, you will be able to perform and manage backup and recovery activities on Oracle 12c databases using RMAN.
Table of Contents (17 chapters)
Free Chapter
Chapter 5
Retrieve Information about RMAN Backups and Jobs
Content Locked
Section 3
Practice 7 - Reporting and Monitoring RMAN Backups and Jobs (Part 1 of 3)
In this practice, you will use the LIST command to retrieve the list (backupset file and image copies registered in the RMAN repository, archived redo log files and their backups, and expired backup files). Then you will use CROSSCHECK to scan the backup files and check on their expiry status. After that, you will use the REPORT command to perform (display the physical structure of the database, report datafiles that do not satisfy retention policy, report datafiles that are affected by unrecoverable operations, and report obsolete backup files). Finally, you will monitor RMAN jobs using V$ views. Specifically, in this video, you will be preparing for the practice and obtain information about RMAN backups using the LIST command.