Tags

,

 

** This procedure helps if flashback is not enabled on the databse, with recyclebin turned off we can do flashback before drop as well.
** Assuming the backups are available to the server used for restore or copy the backups to the server.

Rman recovery is straight forward, i.e. restore the backups and recover it to certain point.
We can utilize the RMAN utility to restore the backups to recover the lost table. We need to identify the last good state of the table and use the timestamp to recover the table.

Restore and Recover the database on different server:

— Start instance with sample pfile or with mandatory parameters.
— Restore spfile and controlfile from the autobackup.
— Restore the database and Recover it before the drop/truncate operation.

rman target /as sysdba
RMAN> Set DBID 19034656;
RMAN>restore spfile from autobackup;
RMAN>restore controlfile from autobackup;  ##if it’s not available restore it from PROD.

catalog the restored backup pieces

RMAN> restore database from tag ‘<tag info’;
RMAN>recover database until scn;

Once recovery is done, open the database with resetlogs:
sqlplus> alter database open resetlogs;

Now the database is available, you can use the exp/imp, expdp/impdp, or sqlldr to extract the table and restore in the original server.