9.7.6 Creating a Snapshot Database from Another Snapshot Database

To create a snapshot from a snapshot:

1. Create a first level snapshot. In the following example, the snapshot is called PDB1S1.

   create pluggable database PDB1S1
     from PDB1TM1
     create_file_dest='+SPARSE'
     snapshot copy;

2. Open and close the PDB, so you can re-open it as read-only in the next step.

   alter pluggable database PDB1S1 open;
   alter pluggable database PDB1S1 close;
   

3. Open the PDB in read-only mode so it can serve as a test master.

   alter pluggable database PDB1S1 open read only;

4. Create a snapshot from the snapshot created in step 1. In the following example, the second level snapshot is called PDB1S1_A.

   create pluggable database PDB1S1_A
     from PDB1S1
     create_file_dest='+SPARSE'
     snapshot copy;
   
   alter pluggable database PDB1S1_A open;