通过恢复目录（Catalogue）进行PDB级别的PITR恢复

连接 CDBOCP：PDB1 将表空间脱机

SQL> alter session set container=pdb1;

Session altered.

SQL> alter tablespace askscuti offline; alter tablespace askscuti offline
*
ERROR at line 1:
ORA-01191: file 44 is already offline - cannot do a normal offline
ORA-01111: name for data file 44 is unknown - rename to correct file
ORA-01110: data file 44: ‘/u01/app/oracle/product/12.2.0/db_1/dbs/MISSING00044‘

更新控制文件中记录的数据文件信息

SQL> alter database rename file ‘/u01/app/oracle/product/12.2.0/db_1/dbs/MISSING00044‘ to ‘/u01/app/oracle/oradata/CDBOCP/PDB1/askscuti01.dbf‘;

Database altered.

再次对 44 号文件进行单独还原和恢复

RMAN> run{
restore datafile 44;
recover datafile 44;
}

Starting restore at 2019-08-04 13:01:07
starting full resync of recovery catalog
full resync complete
using channel ORA_DISK_1

datafile 44 is already restored to file /u01/app/oracle/oradata/CDBOCP/PDB1/askscuti01.dbf
restore not done; all files read only,offline,excluded,or already restored
Finished restore at 2019-08-04 13:01:13
Starting recover at 2019-08-04 13:01:13
using channel ORA_DISK_1

starting media recovery
media recovery complete,elapsed time: 00:00:01

Finished recover at 2019-08-04 13:01:15

将 CDBOCP：PDB1 表空间联机

SQL> alter tablespace askscuti online;

Tablespace altered.

所以采用 Catalogue 针对 PDB 级别进行 PITR - 可以恢复出被DROP的表空间。

（编辑：济源站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!