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

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 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 <pdb_to_clone> open;

 

3. Generate the snapshot for the PDB to be cloned

alter session set container=<pdb_to_clone>;
ALTER PLUGGABLE DATABASE SNAPSHOT <pdb_to_clone> _yyyymmdd_hh24mi;

 

4. Create the clone PDB on the host CDB

. oraenv
sqlplus / as sysdba
CREATE PLUGGABLE DATABASE <new_clone_name> FROM <pdb_to_clone>
@<snapshot_standby> snapshot copy;

 

5. Open the cloned PDB in read-write mode

alter pluggable database <new_clone_name> 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:
Come work with the Best