How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN in 12c MT(Multitenant ) database
(Doc ID 2214510.1)
Last updated on SEPTEMBER 03, 2024
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Goal
- 12c came with new feature of recovering a table from RMAN backup
Example: RMAN>recover table <table_name> OF PLUGGABLE DATABASE <pdb_name> until time "to_date('11/23/2016 14:58:30','mm/dd/yyyy hh24:mi:ss')" auxiliary destination '</path/>' remap table <username>.<tablename1>:<tablename2> preview;
- But if don't want to do anything on production then follow below steps to do PITR restore / recovery of MT database in 12c to extract information from the dropped / truncated table
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |