<<Back to Oracle Backup & Recovery Main Page Restoring/Recovering Table from RMAN Backup oracle 19c Point In Time table Restore/Recovery in Oracle Today I had a situation where application team accidently deleted data from a table in prod database and wanted to restore it from backup. The requirement was to restore the table with different name washout touching the original table so that the application team can compare it and find out the different eventually deleted rows Before 12.2 the task was complicated and it was achieved by restoring the full database on 3rd server and export the table from restored database and import it in original database. Oracle has now automated the procedure and made it quite easy. Now you just have to run one command and the rest is taken care by oracle Scenarios Container DB Name: CDBDB Pluggable DB Name: PDB1 Table to be restored: TEST Schema/Owner of the table: EMPLOYEE New Table Name After Restore: TEST_0701 Restore Timestamp: 01-JUL
A Blog to share interesting Database Facts and Experience.