Recover a dropped table to a specific Point in Time using RMAN
Starting from 12c, RECOVER TABLE command that allows point in time recovery of a table or a table partition. We must have RMAN backups of the tables or table partitions as they existed at the point in time to which you want to recover the dropped objects. Host Database Name CDB Database Version srvdb01.localdomain orcl No 19.3.0.0.0 1. Let’s check the table row count and drop the dept table. [oracle@srvdb01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 6 21:41:01 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> conn scott Enter password: Connected. SQL> set time on 22:06:42 SQL> select count(*) from dept; COUNT(*) ---------- ...