Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Steps to recover unknown tables from a know schema in 19C ASM DB with RMAN tape backup only

Hi there,
Our developer deleted by mistake during application upgrade some tables. We don`t know which tables(no audit) so we can not used the rman table recovery option.
My idea is to recover data like below:
a. create a new instance from the production db spfile, add listener and tnsnames entries
b. recover and restore database from tape from an older backup
c. Make a diff using dba_objects on prod and new restored data
d. export data from the new database
e. import only tables results at diff or import using the table_exists_action=skip option
Please let me know if this approach is good and how to proceed exactly on step b. as I have a full backup from weekend and I need to restore and recover until the last backup before tables deletion.
Also, for step e, please let me know what option should be the best practice.
Regards,
Answers
-
Steps seems fine you can proceed with that.
Also don't you have flashback enabled on database?
-
Hi Sunny,
Thank you for your replay. No flashback unfortunately.
Regards,
-
I have tried to duplicate database on the standby server(Active DG config). While duplicating RMAN has changed SID of the new instance as on the PROD DB. Do you know if there is any risk in this case?
Should I duplicate on a new server, keep the same server and run nid utility t the and or the duplicate process will change my SID back into ?
Many thanks in advance!
-
You are going to compare whole database object or few schema objects.If it is related to schema there is no major risk