{"id":12832,"date":"2019-09-20T16:51:49","date_gmt":"2019-09-20T14:51:49","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/"},"modified":"2023-06-15T16:41:48","modified_gmt":"2023-06-15T14:41:48","slug":"oracle-19c-point-in-time-recovery-in-a-pdb","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/","title":{"rendered":"Oracle 19c : Point-In-Time Recovery in a PDB"},"content":{"rendered":"

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

Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not.
\nA PITR of a PDB does not affect remaining PBDs. That means that while doing a PITR in PDB, people can use the other PDBs. In this blog we are using an oracle 19c database with local undo mode enabled<\/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<\/td>\n
\n
\n
SQL> <\/code><\/div>\n
\u00a0\u00a0<\/code>1\u00a0 <\/code>SELECT<\/code> property_name, property_value<\/code><\/div>\n
\u00a0\u00a0<\/code>2\u00a0 <\/code>FROM<\/code>\u00a0\u00a0 database_properties<\/code><\/div>\n
\u00a0\u00a0<\/code>3* <\/code>WHERE<\/code>\u00a0 property_name = <\/code>'LOCAL_UNDO_ENABLED'<\/code><\/div>\n
<\/div>\n
PROPERTY_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PROPE<\/code><\/div>\n
-------------------- -----<\/code><\/div>\n
LOCAL_UNDO_ENABLED\u00a0\u00a0 <\/code>TRUE<\/code><\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
SELECT<\/code> con_id, tablespace_name <\/code>FROM<\/code>\u00a0\u00a0 cdb_tablespaces <\/code>WHERE<\/code>\u00a0 tablespace_name <\/code>LIKE<\/code> 'UNDO%'<\/code>;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID TABLESPACE_NAME<\/code><\/div>\n
---------- ------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 UNDOTBS1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 UNDOTBS1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1 UNDOTBS1<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We suppose that
\n-We have a tablespace named MYTABPDB2
\n-We have a valid backup of the whole database
\n-A recovery catalog is not used<\/p>\n

Now connecting to the PDB2, let\u2019s drop a tablespace after creating a restore point.<\/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> show con_name;<\/code><\/div>\n
<\/div>\n
CON_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
PDB2<\/code><\/div>\n
<\/div>\n
SQL> <\/code>create<\/code> restore point myrestpoint;<\/code><\/div>\n
<\/div>\n
Restore point created.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n
SQL> <\/code>drop<\/code> tablespace mytabpdb2 including contents <\/code>and<\/code> datafiles;<\/code><\/div>\n
<\/div>\n
Tablespace dropped.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And now let’s perform a PITR to the restore point myrestpoint<\/p>\n

1- Connect to the root container<\/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
[oracle@oraadserver ~]$ rman target \/<\/code><\/div>\n
<\/div>\n
[oracle@oraadserver ~]$ rman target \/<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 19.0.0.0.0 - Production <\/code>on<\/code> Fri Sep 20 13:07:07 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL (DBID=1546409981)<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Close the PDB<\/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<\/td>\n
\n
\n
RMAN> <\/code>ALTER<\/code> PLUGGABLE <\/code>DATABASE<\/code> PDB2 <\/code>close<\/code>;<\/code><\/div>\n
<\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

3- Do the PITR<\/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
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n<\/td>\n
\n
\n
RMAN> run<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>SET<\/code> TO<\/code> RESTORE POINT myrestpoint;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>RESTORE PLUGGABLE <\/code>DATABASE<\/code> pdb2;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>RECOVER PLUGGABLE <\/code>DATABASE<\/code> pdb2;<\/code><\/div>\n
}2> 3> 4> 5> 6><\/code><\/div>\n
<\/div>\n
executing command: <\/code>SET<\/code> until clause<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=54 device type=DISK<\/code><\/div>\n
<\/div>\n
channel ORA_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>to<\/code> restore <\/code>from<\/code> backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00013 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/system01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00014 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/sysaux01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00015 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/undotbs01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00016 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: reading <\/code>from<\/code> backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_20\/o1_mf_nnndf_TAG20190920T141945_gr9jzry9_.bkp<\/code><\/div>\n
channel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_20\/o1_mf_nnndf_TAG20190920T141945_gr9jzry9_.bkp tag=TAG20190920T141945<\/code><\/div>\n
channel ORA_DISK_1: restored backup piece 1<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:07<\/code><\/div>\n
Finished restore <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
<\/div>\n
Starting recover <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
current<\/code> log archived<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
<\/div>\n
Finished recover <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4- Open the PDB on resetlogs mode<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>alter<\/code> pluggable <\/code>DATABASE<\/code>\u00a0 pdb2 <\/code>open<\/code> resetlogs;<\/code><\/div>\n
<\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

I did not get any error from RMAN, but when looking the alert log file, I have following errors<\/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
PDB2(4):Pluggable <\/code>database<\/code> PDB2 dictionary <\/code>check<\/code> beginning<\/code><\/div>\n
PDB2(4):Tablespace <\/code>'MYTABPDB2'<\/code> #7 found <\/code>in<\/code> data dictionary,<\/code><\/div>\n
PDB2(4):but <\/code>not<\/code> in<\/code> the controlfile. Adding <\/code>to<\/code> controlfile.<\/code><\/div>\n
PDB2(4):File #25 found <\/code>in<\/code> data dictionary but <\/code>not<\/code> in<\/code> controlfile.<\/code><\/div>\n
PDB2(4):Creating OFFLINE file <\/code>'MISSING00025'<\/code> in<\/code> the controlfile.<\/code><\/div>\n
PDB2(4):Pluggable <\/code>Database<\/code> PDB2 Dictionary <\/code>check<\/code> complete<\/code><\/div>\n
PDB2(4):<\/code>Database<\/code> Characterset <\/code>for<\/code> PDB2 <\/code>is<\/code> AL32UTF8<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Seems there is some issue with the recovery of MYTABPDB2 tablespace. Connected to PDB2 I can have<\/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<\/td>\n
\n
\n
SQL> <\/code>select<\/code> FILE_NAME,TABLESPACE_NAME <\/code>from<\/code> dba_data_files <\/code>where<\/code> TABLESPACE_NAME=<\/code>'MYTABPDB2'<\/code>;<\/code><\/div>\n
<\/div>\n
FILE_NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
TABLESPACE_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/product\/19.0.0\/dbhome_3\/dbs\/MISSING00025<\/code><\/div>\n
MYTABPDB2<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The tablespace was not recovered as expected.
\nWhat happens? In fact this issue is expected according Doc ID 2435452.1<\/strong> where we can find
\nIf the point in time recovery of the pluggable database is performed without the catalog, then it is expected to fail<\/em><\/p>\n

As we are not using a recovery catalog, backup information are stored in the control file and it seems that the actual control file is no longer aware of the data file 25.
\nAs specified in the document, we have to use a recovery catalog<\/p>\n

Now let\u2019s connect to a catalog and do again the same PITR
\nAfter connecting to the catalog we do a full backup. Then we drop the tablespace and run again the same recovery command while connecting to the catalog. We use the time before the tablespace was dropped.<\/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
[oracle@oraadserver trace]$ rman catalog rman\/rman@rmancat<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 19.0.0.0.0 - Production <\/code>on<\/code> Fri Sep 20 15:28:29 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> recovery catalog <\/code>database<\/code><\/div>\n
<\/div>\n
RMAN> <\/code>connect<\/code> target \/<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL (DBID=1546409981)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After closing PDB2 we run following bloc<\/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
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n<\/td>\n
\n
\n
RMAN> run<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>SET<\/code> UNTIL <\/code>TIME<\/code> \"to_date('20-SEP-2019 15:27:00','DD-MON-YYYY HH24:MI:SS')\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>RESTORE PLUGGABLE <\/code>DATABASE<\/code> pdb2;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>RECOVER PLUGGABLE <\/code>DATABASE<\/code> pdb2;<\/code><\/div>\n
}<\/code><\/div>\n
2> 3> 4> 5> 6><\/code><\/div>\n
executing command: <\/code>SET<\/code> until clause<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
channel ORA_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>to<\/code> restore <\/code>from<\/code> backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00013 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/system01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00014 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/sysaux01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00015 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/undotbs01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00016 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00026 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/mytabpdb201.dbf<\/code><\/div>\n
channel ORA_DISK_1: reading <\/code>from<\/code> backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_20\/o1_mf_nnndf_TAG20190920T152554_gr9nws0x_.bkp<\/code><\/div>\n
channel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_20\/o1_mf_nnndf_TAG20190920T152554_gr9nws0x_.bkp tag=TAG20190920T152554<\/code><\/div>\n
channel ORA_DISK_1: restored backup piece 1<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:15<\/code><\/div>\n
<\/div>\n
datafile 26 switched <\/code>to<\/code> datafile copy<\/code><\/div>\n
input datafile copy RECID=5 STAMP=1019489668 file <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/mytabpdb201.dbf<\/code><\/div>\n
Finished restore <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
starting <\/code>full<\/code> resync <\/code>of<\/code> recovery catalog<\/code><\/div>\n
full<\/code> resync complete<\/code><\/div>\n
<\/div>\n
Starting recover <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
<\/div>\n
Finished recover <\/code>at<\/code> 20-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We then open PDB2 with resetlogs mode and then verify with sqlplus<\/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>select<\/code> FILE_NAME,TABLESPACE_NAME <\/code>from<\/code> dba_data_files <\/code>where<\/code> TABLESPACE_NAME=<\/code>'MYTABPDB2'<\/code>;<\/code><\/div>\n
<\/div>\n
FILE_NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
TABLESPACE_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/mytabpdb201.dbf<\/code><\/div>\n
MYTABPDB2<\/code><\/div>\n
<\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And this time the PITR works fine. The tablespace was restored.<\/p>\n

Conclusion<\/h3>\n

As seen in this blog, it is recommended to use a recovery catalog when coming to do some PITR operations in a multitenant environment.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a […]<\/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,59],"tags":[1171,1702,223,270],"type_dbi":[],"class_list":["post-12832","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-oracle-19c","tag-pitr","tag-pluggable-databases","tag-rman"],"acf":[],"yoast_head":"\nOracle 19c : Point-In-Time Recovery in a PDB - 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\/oracle-19c-point-in-time-recovery-in-a-pdb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 19c : Point-In-Time Recovery in a PDB\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-20T14:51:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:41:48+00:00\" \/>\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\/oracle-19c-point-in-time-recovery-in-a-pdb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 19c : Point-In-Time Recovery in a PDB\",\"datePublished\":\"2019-09-20T14:51:49+00:00\",\"dateModified\":\"2023-06-15T14:41:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/\"},\"wordCount\":397,\"commentCount\":1,\"keywords\":[\"Oracle 19c\",\"PITR\",\"Pluggable Databases\",\"RMAN\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/\",\"name\":\"Oracle 19c : Point-In-Time Recovery in a PDB - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2019-09-20T14:51:49+00:00\",\"dateModified\":\"2023-06-15T14:41:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 19c : Point-In-Time Recovery in a PDB\"}]},{\"@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":"Oracle 19c : Point-In-Time Recovery in a PDB - 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\/oracle-19c-point-in-time-recovery-in-a-pdb\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 19c : Point-In-Time Recovery in a PDB","og_description":"By Mouhamadou Diaw Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/","og_site_name":"dbi Blog","article_published_time":"2019-09-20T14:51:49+00:00","article_modified_time":"2023-06-15T14:41:48+00:00","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\/oracle-19c-point-in-time-recovery-in-a-pdb\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 19c : Point-In-Time Recovery in a PDB","datePublished":"2019-09-20T14:51:49+00:00","dateModified":"2023-06-15T14:41:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/"},"wordCount":397,"commentCount":1,"keywords":["Oracle 19c","PITR","Pluggable Databases","RMAN"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/","name":"Oracle 19c : Point-In-Time Recovery in a PDB - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2019-09-20T14:51:49+00:00","dateModified":"2023-06-15T14:41:48+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c-point-in-time-recovery-in-a-pdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 19c : Point-In-Time Recovery in a PDB"}]},{"@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\/12832","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=12832"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12832\/revisions"}],"predecessor-version":[{"id":25960,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12832\/revisions\/25960"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12832"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}