{"id":7654,"date":"2020-06-30T08:54:21","date_gmt":"2020-06-30T08:54:21","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/use-the-oracle-database-refreshable-clone-feature-part-two-demonstration\/"},"modified":"2026-11-03T19:28:47","modified_gmt":"2026-11-03T19:28:47","slug":"use-the-oracle-database-refreshable-clone-feature-part-two-demonstration","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/de\/blogs\/use-the-oracle-database-refreshable-clone-feature-part-two-demonstration\/","title":{"rendered":"Use the Oracle Database refreshable clone feature – Part Two: Demonstration"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

Part one of the series provides an introduction to Oracle\u00ae; refreshable clones, including when and why to use them. In this post, I demonstrate how to set up, configure, maintain, and drop a refreshable clone pluggable database (PDB) in Oracle 18c.<\/p>\n

Prerequisites for a refreshable clone PDB<\/strong><\/p>\n

To follow along with this demonstration, complete the following prerequisites:<\/p>\n

    \n
  1. Have a database link for a newly created refreshable clone pointing to a local or a remote container.<\/li>\n
  2. Set archive_log_mode<\/em> to enabled<\/em>.<\/li>\n
  3. Use an engineered system or Enterprise Edition (EE) Oracle Cloud. If it’s not available in the same platform or version, set the hidden parameter, _exadata_feature_on<\/em>`, to `True<\/em>` for this demonstration.<\/li>\n
  4. Set `local_undo_mode<\/em>` to `enabled`.<\/em><\/li>\n<\/ol>\n

    You can set the refreshable PDB in either CLOSED<\/strong> or OPEN READ ONLY<\/strong> mode and in OPEN READ ONLY<\/strong> mode for queries after a refresh.<\/p>\n

     Environment<\/strong><\/p>\n

    For this demonstration, make sure your environment conforms to the following specifications:<\/p>\n

    – Install Oracle 18c and perform the prerequisites on the machine and database.<\/p>\n

    – For the role of the production database:<\/p>\n

         – Set the container database (CDB) name: YCDB1<\/strong><\/p>\n

         – Set the PDB Name: PURCH_PDB<\/strong><\/p>\n

    – For the role of refreshable clone PDB:<\/p>\n

         – Set the CDB Name: XCDB1<\/strong><\/p>\n

         – Set the PDB Name: PDB2_REFRO<\/strong><\/p>\n

         – Set the PDB to refresh automatically every 30 minutes<\/p>\n

     Demonstration<\/strong><\/p>\n

    This demonstration performs the following activities:<\/p>\n

      \n
    • Sets up the environment.<\/li>\n
    • Finds the refresh mode of the production database.<\/li>\n
    • Shows how to the refresh mode of the refreshable clone, including disabling refresh on the refreshable clone.<\/li>\n
    • Switch between production and the refreshable clone.<\/li>\n<\/ul>\n

      Set up the refreshable clone environment:<\/strong><\/p>\n

      For the refreshable clone environment, take the following actions.<\/p>\n

      Actions to take on YCDB1:<\/strong><\/p>\n

      1. Create a production database and open it.<\/p>\n

      \"PDB<\/p>\n

      2. Import the data from the EXPDP<\/strong> dumps that you took by using the `impdp<\/em>` utility or importing an HR schema into PURCH\\_PDB<\/strong>. For this example, import an HR schema by running the following script on the database: <\/p>\n

       @?\/demo\/schema\/human_resources\/hr_main.sql<\/em><\/p>\n

      After it finishes, validate the HR schema details, as shown in the following figure:<\/p>\n

      \"PDP<\/p>\n

      Actions to take on XCDB1: <\/strong><\/p>\n

      1. Create a database link to point to the production database, PURCH\\_PDB<\/strong>.<\/p>\n

      2. Create a refreshable PDB<\/strong>, set the refresh period to every 30 minutes, and validate that the data is refreshed.<\/p>\n

      You can use all the attributes when you create a PDB that you plan to use to create a database in another location. For example, to modify a PDB datafile location, use CREATE\\_FILE\\_DEST<\/strong> or  FILE\\_NAME\\_CONVERT<\/strong><\/p>\n

      \nThe only addition is the REFRESH MODE<\/strong> attribute. To simplify this demonstration, I did not add any of the optional attributes.<\/p>\n

      \"PDB<\/p>\n

      Find the refresh mode and production database details<\/strong><\/p>\n

      You can query table DBA_PDBS<\/strong> to check details of the refreshable PDB mode, status, last refresh SCN, and its parent production database details. For PDB2\\_REFRO<\/strong> PDB, check the output as shown in the following example:<\/p>\n

      \"PDB<\/p>\n

      After you complete your task, you should convert the refreshable PDB back to MOUNTED<\/strong> mode for a continuous refresh according to the schedule. Use the following commands to do this activity. The  open_mode.sql<\/em> used here is a query to check the current open_mode of the database.<\/p>\n

      You might see the following error if you did not close the database instance
      \nfor refresh:<\/p>\n

          ORA-65025: Pluggable database is not closed on all instances<\/em><\/p>\n

      \"pdb<\/p>\n

       <\/strong><\/p>\n

      Change the refresh mode of the refreshable clone<\/strong><\/p>\n

      You can change the mode of a refreshable clone as follows:<\/p>\n

        \n
      • Change manual refresh to automatic refresh.<\/li>\n
      • Change automatic refresh to manual refresh.<\/li>\n
      • Disable refresh from automatic or manual refresh mode.<\/li>\n<\/ul>\n

        Convert a manual refresh to an automatic refresh and vice versa<\/strong><\/p>\n

        Note<\/strong>: You cannot change the PDB refresh mode when logged into one other PDB. For example, you can’t change the mode of XPDB<\/strong> while logged into YPDB<\/strong>.
        \nIf you try, the following error occurs:<\/p>\n

        ORA-65118: An operation affecting a pluggable database cannot be performed from another pluggable database.<\/p>\n

        \"pdb<\/p>\n

         In manual refresh mode, you can refresh your cloned PDB as needed by using the following command:<\/p>\n

        \"PDB<\/p>\n

        Disable PDB refresh and convert a read-only clone to a read-write-enabled database <\/strong><\/p>\n

        You can disable the refresh mode of a PDB to convert your refreshable clone into
        \nread-write mode.<\/p>\n

        Note<\/strong>: After you disable refresh for your pluggable database, you cannot enable it again. You must re-create the PDB to have it be a refreshable PDB. If you try to convert from the NONE<\/strong> refresh mode to refresh mode, you get the following error:<\/p>\n

                                 ORA-65261: pluggable database PDB2_REFRO3 not enabled for refresh.<\/em><\/p>\n

        \"PDB<\/p>\n

         After you disable refresh, the PDB has read-write access.<\/p>\n

        \"PDB<\/p>\n

        Switch from production to the refreshable clone and vice versa. <\/strong><\/p>\n

        Before Oracle 18c, you needed to perform all the steps to switch over the role, including shutting the primary and opening it as read-only.<\/p>\n

        In this demonstration, I do the following: <\/p>\n

        1. Create user C##SWITCHUSER<\/strong> on the container databases XCDB1 and YCDB1 by using grant connect, sysoper<\/strong>.<\/p>\n

        2. Create a database link, dblink<\/strong>, pointing to another container database. In YCDB1<\/strong>, create the dblink, XCDB1SYSOPER<\/strong>, to connect XCDB1<\/strong>. Use database views, DBA\\_DB\\_LINKS and V$DATABASE<\/strong> to collect database details after creating the database link.<\/p>\n

        3. Open the refreshable clone database as read-only.<\/p>\n

        4. Run the switchover command.<\/p>\n

        5. Validate the database status and open mode after switching the production and refreshable clone databases.<\/p>\n

        Actions to take on YCDB1:<\/strong><\/p>\n

        Complete prerequisites 1 through 3 before executing the switchover command.<\/p>\n

        Database link details:<\/p>\n

        \"pdb<\/p>\n

         <\/p>\n

        Actions to take on XCDB1<\/strong><\/p>\n

        Check the database link details and find the database open mode<\/strong> by using DBA\\_DB\\_LINKS<\/strong> and V$DATABASE<\/strong>.<\/p>\n

        \"PDP<\/p>\n

        After the switchover completes, the source PDB PURCH\\_PDB<\/strong> becomes the refreshable clone PDB. This PDB is currently in MOUNT<\/strong> status, and from now on, you can open it only in READ ONLY<\/strong> mode. In contrast, the original refreshable clone, PDB PDB2\\_REFRO<\/strong> is now open in READ<\/strong> or WRITE<\/strong> mode
        \nand functions as a source PDB. <\/p>\n

        Conclusion:<\/strong><\/p>\n

        You should not consider the refreshable clone PDB feature as a replacement for Data Guard from the perspective of high availability. However, you can use a refreshable clone to maintain a replica database on another server.<\/p>\n

        This post describes how to use refreshable PDBs as replicas so that you can resume certain low-load, non-critical application operations, whether the switchover is a planned or unplanned event. Keep in mind, that you should consider the switchovers from the point of view of Recovery Time Objectives (RTOs, time to resume operations) and Recovery Point Objectives (RPOs, such as achieving minimal data loss).<\/p>\n","protected":false},"excerpt":{"rendered":"

        Use the Oracle Database refreshable clone feature—;Part Two: Demonstration<\/p>\n","protected":false},"author":2,"featured_media":7656,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26463","content_type":"blog","created_by":"10130","authored_on":"2024-01-08T09:54:21+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Tejashkumar Patel, Oracle Database Administrator, Rackspace Technology","seo_description":"Continue learning about Oracle refreshable clone pluggable databases (PDBs) in Oracle 18c. Utilize Oracle refreshable clones effectively.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26463-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2020-06-30T08:54:21","rxt_solutions":"Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Using Oracle Database Refreshable Clones | Rackspace Technology","field_topics":"","field_slug":"use-the-oracle-database -refreshable-clone-feature-part-two-demonstration","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7654","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/comments?post=7654"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7654\/revisions"}],"predecessor-version":[{"id":9594,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7654\/revisions\/9594"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media\/7656"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media?parent=7654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/categories?post=7654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/tags?post=7654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}