How to Create a Clone using Carousel Snapshot and Active Standby Database
Contents
- Switch the physical standby to snapshot standby
- Open the PDB to be cloned in read-write mode
- Generate the snapshot for the PDB to be cloned
- Create the clone PDB on the host CDB
- Open the cloned PDB in read-write mode
- 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 <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