Recover From a DROP/TRUNCATE/DELETE TABLE with RMAN
How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN in 19c MT(Multitenant ) database
To restore table after accidentally dropped /truncated /delete & commit records (table Point in Time recovery)
Prod Table truncated accidentally.
DB: prod Oracle 19.12 Multitenant (Total DB Size 23TB)
By the time issue reported, “As of timestamp” clause not worked because already 4 hours passed:
Estimation of auxiliary Space requirements to restore:
sum of the size of (System + Sysaux+ Undotbs + temp tbs+ apps tbs (for ex: Users))
(180GB+60GB+ 120GB+1700GB=2.06 TB)
RMAN DB partial restore on non-prod with SYSTEM+SYSAUX+UNDO tbs and APS tbs. — successfully restored.
Using RMAN backup 30 MB of table restored & recovered after applying many conditions . It took 10 hours .
For More info refer Docs ID 2214510.1, ID 1521524.1
See also: