{"id":17141,"date":"2022-02-24T15:47:47","date_gmt":"2022-02-24T14:47:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/"},"modified":"2023-06-20T10:04:04","modified_gmt":"2023-06-20T08:04:04","slug":"pdb-snapshot-carousel-with-oracle-21c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/","title":{"rendered":"PDB Snapshot Carousel with Oracle 21c"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

In a previous blog <\/a>, I talked about refreshable PDB technology which can be used to refresh a target PDB.<\/p>\n

We have seen here<\/a> how the target refreshable PDB can be used as a master to provide PDB snapshots.<\/p>\n

In this blog we are going to continue in the same topic and talk about PDB Snapshot Carousel which is a library of PDB snaphots. It consists to automatically or manually generate a certain number of snapshots for a given PDB. The source PDB can be a normal PDB or a refreshable one.<\/p>\n

As specified in documentation <\/a> , a PDB snaphot carousel can be useful to maintain a library of recent PDB copies for PITR and cloning.<\/p>\n

This feature is only available for following editions ( documentation <\/a> )<\/p>\n

EE-ES<\/strong> Oracle Database Enterprise Edition on Engineered Systems
\nDBCS EE<\/strong> Oracle Database Cloud Service Enterprise Edition
\nDBCS EE-HP<\/strong> Oracle Database Cloud Service Enterprise Edition – High Performance
\nDBCS EE-EP<\/strong> Oracle Database Cloud Service Enterprise Edition – Extreme Performance
\nExaCS<\/strong> Oracle Database Exadata Cloud Service
\nExaCC<\/strong> Oracle Database Exadata Cloud@Customer<\/p>\n

However if you do not have such environment, you can set following parameter “_exadata_feature_on” to TRUE for testing.<\/p>\n

Let’s consider PDB1FRES as the source for the snapshots. When configured PDB snapshot carousel can automatically generate a snapshot for each defined interval. The maximum snapshots that can be created is defined by the MAX_PDB_SNAPSHOTS in the CDB_PROPERTIES.<\/p>\n

The default value is 8 and is the maximum.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
SQL> col PROPERTY_NAME <\/code>for<\/code> a40<\/code><\/div>\n
SQL> col PROPERTY_VALUE <\/code>for<\/code> a40<\/code><\/div>\n
SQL> <\/code>set<\/code> lines 150<\/code><\/div>\n
SQL> <\/code>select<\/code> PROPERTY_NAME,PROPERTY_VALUE <\/code>from<\/code> cdb_properties <\/code>where<\/code> property_name=<\/code>'MAX_PDB_SNAPSHOTS'<\/code>;<\/code><\/div>\n
<\/div>\n
PROPERTY_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PROPERTY_VALUE<\/code><\/div>\n
---------------------------------------- ----------------------------------------<\/code><\/div>\n
MAX_PDB_SNAPSHOTS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\"\"<\/a><\/p>\n

The MAX_PDB_SNAPSHOTS can be configured using for exemple<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
ALTER<\/code> PLUGGABLE <\/code>DATABASE<\/code> SET<\/code> MAX_PDB_SNAPSHOTS = 5<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In this test the maximum is set to the default value. To configure PDB1FRES to generate snapshot every 2 minutes, let’s just run following<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n<\/td>\n
\n
\n
SQL> show pdbs;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB1FRES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
<\/div>\n
SQL> <\/code>alter<\/code> session <\/code>set<\/code> container=PDB1FRES;<\/code><\/div>\n
<\/div>\n
Session altered.<\/code><\/div>\n
<\/div>\n
SQL> show pdbs;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB1FRES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
<\/div>\n
SQL> <\/code>ALTER<\/code> PLUGGABLE <\/code>DATABASE<\/code> PDB1FRES SNAPSHOT MODE EVERY 2\u00a0 MINUTES;<\/code><\/div>\n
<\/div>\n
Pluggable <\/code>database<\/code> altered.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
<\/div>\n
SQL> <\/code>SELECT<\/code> SNAPSHOT_MODE, SNAPSHOT_INTERVAL <\/code>FROM<\/code>\u00a0\u00a0 DBA_PDBS;<\/code><\/div>\n
<\/div>\n
SNAPSH SNAPSHOT_INTERVAL<\/code><\/div>\n
------ -----------------<\/code><\/div>\n
AUTO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Not that we can also create a new PDB that will take snapshots every 2 minutes using the command CREATE PLUGGABLE DATABASE. The SNAPSHOT MODE can also be MANUAL or NONE<\/p>\n

If we query the DBA_PDB_SNAPSHOTS later, we can see that snapshots are automatically being generated<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>SELECT<\/code>\u00a0 CON_NAME, SNAPSHOT_NAME, scn_to_timestamp(snapshot_scn) <\/code>as<\/code> snaptime , SNAPSHOT_SCN\u00a0 <\/code>FROM<\/code>\u00a0 DBA_PDB_SNAPSHOTS <\/code>ORDER<\/code> BY<\/code> SNAPSHOT_SCN;<\/code><\/div>\n
<\/div>\n
CON_NAME\u00a0 SNAPSHOT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SNAPTIME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SNAPSHOT_SCN<\/code><\/div>\n
--------- ------------------------- ----------------------------------- ------------<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421048 23-FEB-22 03.10.53.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436486<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421168 23-FEB-22 03.12.51.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436585<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421287 23-FEB-22 03.14.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436668<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421407 23-FEB-22 03.16.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436751<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421527 23-FEB-22 03.18.49.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436830<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421647 23-FEB-22 03.20.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436905<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421767 23-FEB-22 03.22.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45437166<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421887 23-FEB-22 03.24.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45437249<\/code><\/div>\n
<\/div>\n
8 <\/code>rows<\/code> selected.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

What happen when the maximum number of snapshots (8) is reached. The database will remove the oldest snaphot and so on<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>SELECT<\/code>\u00a0 CON_NAME, SNAPSHOT_NAME, scn_to_timestamp(snapshot_scn) <\/code>as<\/code> snaptime , SNAPSHOT_SCN\u00a0 <\/code>FROM<\/code>\u00a0 DBA_PDB_SNAPSHOTS <\/code>ORDER<\/code> BY<\/code> SNAPSHOT_SCN;<\/code><\/div>\n
<\/div>\n
CON_NAME\u00a0 SNAPSHOT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SNAPTIME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SNAPSHOT_SCN<\/code><\/div>\n
--------- ------------------------- ----------------------------------- ------------<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421168 23-FEB-22 03.12.51.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436585<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421287 23-FEB-22 03.14.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436668<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421407 23-FEB-22 03.16.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436751<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421527 23-FEB-22 03.18.49.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436830<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421647 23-FEB-22 03.20.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45436905<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421767 23-FEB-22 03.22.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45437166<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097421887 23-FEB-22 03.24.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45437249<\/code><\/div>\n
PDB1FRES\u00a0 SNAP_745266373_1097422007 23-FEB-22 03.26.50.000000000 PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45437336<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Not that you will not see snapshots PDB carousel with the SHOW PDBS command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
SQL> show pdbs;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB1FRES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now that we have our snapshots, we can for example create a new PDB using one snapshot<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>create<\/code> pluggable <\/code>database<\/code> MYPDB <\/code>from<\/code> PDB1FRES using snapshot SNAP_745266373_1097421767;<\/code><\/div>\n
<\/div>\n
Pluggable <\/code>database<\/code> created.<\/code><\/div>\n
<\/div>\n
SQL> show pdbs;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 MYPDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB1FRES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
<\/div>\n
<\/div>\n
SQL> <\/code>alter<\/code> pluggable <\/code>database<\/code> MYPDB <\/code>open<\/code>;<\/code><\/div>\n
<\/div>\n
Pluggable <\/code>database<\/code> altered.<\/code><\/div>\n
<\/div>\n
SQL> show pdbs<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 MYPDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> WRITE <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB1FRES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To drop a snapshot, just use the command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>alter<\/code> pluggable <\/code>database<\/code> drop<\/code> snapshot SNAP_745266373_1097422487;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To drop all snapshots we can find following lines in the documentation <\/a><\/p>\n

To drop all snapshots in a PDB snapshot carousel, set the MAX_PDB_SNAPSHOTS database property to 0 (zero), as shown in the following statement:
\nALTER PLUGGABLE DATABASE SET MAX_PDB_SNAPSHOTS=0;
\nThis technique is faster than executing ALTER PLUGGABLE DATABASE … DROP SNAPSHOT snapshot_name for every snapshot.<\/em><\/p>\n

To disable the snapshot mode<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>ALTER<\/code> PLUGGABLE <\/code>DATABASE<\/code> PDB1FRES SNAPSHOT mode none;<\/code><\/div>\n
<\/div>\n
Pluggable <\/code>database<\/code> altered.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>SELECT<\/code> SNAPSHOT_MODE, SNAPSHOT_INTERVAL <\/code>FROM<\/code>\u00a0\u00a0 DBA_PDBS;<\/code><\/div>\n
<\/div>\n
SNAPSH SNAPSHOT_INTERVAL<\/code><\/div>\n
------ -----------------<\/code><\/div>\n
NONE<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/h3>\n

Hope this help.
\nThanks to Tim for his useful blog <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. We have seen here how the target refreshable PDB can be used as a master to provide PDB snapshots. In this blog we are going to continue in the same topic and […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,59],"tags":[137,2503,2491,2480],"type_dbi":[],"class_list":["post-17141","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-oracle-21c","tag-pdb-carousel-snapshots","tag-pdb-snapshots","tag-refreshable-clone-pdb"],"acf":[],"yoast_head":"\nPDB Snapshot Carousel with Oracle 21c - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PDB Snapshot Carousel with Oracle 21c\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. We have seen here how the target refreshable PDB can be used as a master to provide PDB snapshots. In this blog we are going to continue in the same topic and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-24T14:47:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-20T08:04:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"PDB Snapshot Carousel with Oracle 21c\",\"datePublished\":\"2022-02-24T14:47:47+00:00\",\"dateModified\":\"2023-06-20T08:04:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/\"},\"wordCount\":469,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png\",\"keywords\":[\"Oracle 21C\",\"PDB carousel Snapshots\",\"PDB snapshots\",\"Refreshable clone PDB\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/\",\"name\":\"PDB Snapshot Carousel with Oracle 21c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png\",\"datePublished\":\"2022-02-24T14:47:47+00:00\",\"dateModified\":\"2023-06-20T08:04:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PDB Snapshot Carousel with Oracle 21c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PDB Snapshot Carousel with Oracle 21c - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/","og_locale":"en_US","og_type":"article","og_title":"PDB Snapshot Carousel with Oracle 21c","og_description":"By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. We have seen here how the target refreshable PDB can be used as a master to provide PDB snapshots. In this blog we are going to continue in the same topic and […]","og_url":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/","og_site_name":"dbi Blog","article_published_time":"2022-02-24T14:47:47+00:00","article_modified_time":"2023-06-20T08:04:04+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png","type":"","width":"","height":""}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"PDB Snapshot Carousel with Oracle 21c","datePublished":"2022-02-24T14:47:47+00:00","dateModified":"2023-06-20T08:04:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/"},"wordCount":469,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png","keywords":["Oracle 21C","PDB carousel Snapshots","PDB snapshots","Refreshable clone PDB"],"articleSection":["Database Administration & Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/","url":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/","name":"PDB Snapshot Carousel with Oracle 21c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png","datePublished":"2022-02-24T14:47:47+00:00","dateModified":"2023-06-20T08:04:04+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Picture1-3.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-snapshot-carousel-with-oracle-21c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PDB Snapshot Carousel with Oracle 21c"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17141"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17141\/revisions"}],"predecessor-version":[{"id":26117,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17141\/revisions\/26117"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17141"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}