Audit log

[Former Member]

Dear all,

My old production hdd get crashed

i had installed new hdd & sap

but now i want to import old audit log into new system

can someone guide me how to do that

i have dynamic audit log file

i have old hdd backup

so how can i restore it

i on windows server 2008

Thanks in advance

Azhar

[Former Member]

i had to merge old & new audit log

i know new location if copy & paste only .aud file to new location then it will work or not

[Former Member]

Hello Azhar,

that's what I though in the first place, if you just copy and paste to the new location it should work.

Regards,

Javier

[Former Member]

You will have to update the new location path in SM19. Please read the discussion and standard SAP documentation carefully.

Thank you !

[Former Member]

What kind of audit log are you talking about ? Please explain the problem scenario clearly.

- SAP Security Audit Logs

- DB2 audit logs

- Something else

[Former Member]

i am talking about sap security audit log

[Former Member]

You will have to copy the security audit logs into the new server disk and then update the location/path of the folder in SM19/SM20.

Read more about 'how to configure security audit loggging/SM19'.

Thank you !

[Former Member]

Hello Azhar,

I assume you are running DB2 LUW and you have a valid back up.

You can either use command recover or manually call restore + rollforward to the end of logs.

Please check chapter 8.4 Database recovery of the DBA guide

http://service.sap.com/instguidesnw

-> your NW release

  -> Database specific

     -> Operations

SAP DBA Guide: IBM DB2 for LUW

Regards,

Javier

[Former Member]

i want to restore audit log not db2 log

*.aud file

[Former Member]

Hello Azhar,

sorry I didn't realize you were talking about DB2 audit.  You probably can just copy the logs over to your new server. Also as far as I see in note 1474404, you don't really need to keep the logs once you get the needed information off them.

http://service.sap.com/sap/support/notes/1474404

"

The DB2 audit facility generates, and allows you to maintain, an audit trail for

a series of predefined database events. The records that are generated from this

facility are kept in an audit log file. The analysis of these records can reveal

usage patterns that would identify system misuse by certain users or user

groups. Once such system misuse has been identified, you can take actions to

reduce or eliminate them.

"

I hope this helps,

Regards,

Javier