Steps to recover unknown tables from a know schema in 19C ASM DB with RMAN tape backup only

User_WWXJJ

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,

Sunny kichloo

Steps seems fine you can proceed with that.

Also don't you have flashback enabled on database?

Dumitru Motei

Hi Sunny,

Thank you for your replay. No flashback unfortunately.

Regards,

Dumitru Motei

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!

Sunny kichloo

You are going to compare whole database object or few schema objects.If it is related to schema there is no major risk