Backup and Recovery Scenario of Oracle 19c Multi-tenant Architecture

Dost Muhammad Khalil 34 minutes ago Uncategorized Leave a comment 2 Views

Ensuring the preservation of organizational data and preventing data loss is one of the primary responsibilities of a Database Administrator (DBA). This responsibility often takes precedence over any other tasks due to its critical nature.

Oracle’s backup and recovery solutions have long been recognized in the market for their robustness and ability to handle a wide range of scenarios. However, with the introduction of the Multitenant Architecture in Oracle 12c, backup and recovery strategies have become more complex.

While the numerous benefits of Oracle’s Multitenant Architecture are beyond the scope of this article, our focus here is to outline the possible backup and recovery scenarios for Container Databases (CDBs), particularly in Oracle 19c.

Experienced DBAs managing a multitenant environment will recognize the importance of having hands-on expertise in performing backups and recoveries for the following scenarios:

  1. Complete restore of the entire CDB from a full backup on the same location.

  2. Complete restore of the entire CDB from a full backup on a different location.

  3. Point-in-time recovery of the entire CDB from a full backup on the same location.

  4. Point-in-time recovery of the entire CDB from a full backup on a different location.

  5. Restore of the entire CDB except selected PDBs from a full backup on the same location.

  6. Restore of the entire CDB except selected PDBs from a full backup on a different location.

  7. Point-in-time recovery of the entire CDB except selected PDBs on the same location.

  8. Point-in-time recovery of the entire CDB except selected PDBs on a different location.

  9. Point-in-time recovery of a single PDB within an existing CDB

Note: The below Scenarios will be tested with backup of Complete container and backup type can be Full or Full+Incremental (L0+L1)

While the scenarios above cover most practical use cases, the actual scenarios are not limited to.

Among all these scenarios, the most critical is the last one — performing a point-in-time recovery of a single PDB in a production CDB without impacting the other running PDBs.

In upcoming articles, I will provide detailed, practical guides and documentation for implementing each of these scenarios step by step.

Regards,

Dost Muhammad Khalil

dostmuhammadkhalil9211@gmail.com

+966 554344916

    About Dost Muhammad Khalil

    As an Oracle Database Administrator, I bring a wealth of technical expertise and problem-solving skills to ensure the smooth operation and high performance of mission-critical databases. With a strong foundation in database administration, performance tuning, backup and recovery, and security, I have a proven track record of delivering reliable and scalable database solutions that meet business needs. My ability to communicate effectively with stakeholders, project managers, and technical teams enables me to collaborate seamlessly and deliver projects on time and within budget. Additionally, my passion for staying up-to-date with emerging technologies and best practices in database administration allows me to stay ahead of the curve and continuously improve the performance and reliability of database environments. With a commitment to excellence and a strong work ethic, I am confident in my ability to deliver outstanding results as an Oracle Database Administrator. I look forward to connecting with like-minded professionals and exploring opportunities to make a positive impact in the field of database administration.

    Leave a Reply

    Powered by OracleSolutions | Designed by
    © Copyright 2026, https://oraclesolutions.pk All Rights Reserved