Data deleted while running data base utility from Ztable

[Former Member]

Hi,

Data is deleted from ztable while running database utility. Is there any way to restore the only z table data .

I want only restore  ztable data not all back database base back up.

Regards

Durgesh

[former_member206552]

Hi Durgesh

If you are using oracle and have flashback enabled

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr003.htm

Oracle Flashback Table: Returning Individual Tables to Past States

Best Regards

Marius

[Former Member]

What did you use to do the backup? If you used SAP's brbackup tool then you can only restore the whole database. You can do a point in time recovery to just before when the ztable was emptied, so that you'd only lose changes since then. If that isn't good enough, you'll have to do a complete restore to a separate temporary database, extract the contents of the ztable from there and manually insert them into the real database.

If you used other DB backup tools you may be able to do a selective restore - check the documentation for the backup utility you used.

Steve.

[former_member188883]

Hi Durgesh,

It is not directly possible to restore data of Z-table from the backup.

Suggestion would be to restore the backup on some temporary system.

Take an export of Z-table and then import it into the affected system.

Hope this helps.

Regards,

Deepak Kori