cancel
Showing results for 
Search instead for 
Did you mean: 

Change tracker - Restore data

Former Member
0 Kudos

Hi All

SAP recommended that we backup and delete the entries in change tracker every 10 months. Is there a way to restore the backup in to change tracker without corrupting the production database.

Kind Regards,

Ajay 

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ajay,

MDM does not have tools for data archiving,as suggested above you can use DB tools to archive the history table.The below can shed some light,SAP recommends -

If your DBMS is Oracle, use a utility of your choice to archive your table (backup, dump) and afterwards clean the A2I_CM_HISTORY table using the the truncate command (with the reuse storage option). Remember that you must backup the table before issuing a truncate command since this command is not reversible (it does not generate role back logs!).

Thanks,

Ravi

cweissheimer
Advisor
Advisor
0 Kudos

Hello,

Use database tools to archive the A2i_cm_History table data, and restore it when necessary.

BR,

Carlos