How to Create a Clone using Carousel Snapshot and Active Standby Database

By: Christian Arsenault
Topic: Databases | Posted: Sep 14, 2021 at 11:00 AM EST
Share on:
Twitter LinkedIn Share

Contents

Pre-requisites

  1. Switch the physical standby to snapshot standby
  2. Open the PDB to be cloned in read-write mode
  3. Generate the snapshot for the PDB to be cloned
  4. Create the clone PDB on the host CDB
  5. Open the cloned PDB in read-write mode
  6. Switch the snapshot standby back to physical standby

 

Pre-requisites

  • Must have a physical standby in sync with the source database to be cloned
  • Must have a CDB (container database) ready to host the new snapshot clone that uses the same file system as the physical standby
  • A valid database link between the host CDB and the physical standby must exist and the user must have the “create pluggable database” granted

 

1. Switch the physical standby to snapshot standby

. oraenv
sqlplus / as sysdba
shutdown immediate
startup mount
alter database convert to snapshot standby;
alter database open;

 

2. Open the PDB to be cloned in read-write mode

alter pluggable database 
      open;

 

3. Generate the snapshot for the PDB to be cloned

alter session set container=
     ;
ALTER PLUGGABLE DATABASE SNAPSHOT 
     
       _yyyymmdd_hh24mi
     ;

 

4. Create the clone PDB on the host CDB

. oraenv
sqlplus / as sysdba
CREATE PLUGGABLE DATABASE 
      FROM 
     
@
      snapshot copy;

 

5. Open the cloned PDB in read-write mode

alter pluggable database 
      open;

 

6. Switch the snapshot standby back to physical standby

. oraenv
sqlplus / as sysdba
shutdown immediate
startup mount
alter database convert to physical standby;
shutdown immediate
startup
Share on:
Twitter LinkedIn Share