9.7.6 Creating a Snapshot Database from Another Snapshot Database
To create a snapshot from a snapshot:
-
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;
-
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;
-
Open the PDB in read-only mode so it can serve as a test master.
alter pluggable database PDB1S1 open read only;
-
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;
Related Topics
Parent topic: Managing Exadata Snapshots