Transaction logs

[Former Member]

Hi,

Can any body tell me the difference between transaction logs and redologs, action logs??

Is there any place in SAP where seperately these transaction logs are located??

Thanks in advance,

Ramakrishna

[Former Member]

Hi,

Thanks for the reply.

Best Regards,

DVRK

[Former Member]

Hi,

For all the changes happening at the DB level,it records all those changes in the REDO Log file,Normally Redo log file refers to the Online Redo logs which are currently active in the system. Once the redo logs get filled or by executing alter system switch log file it can generate Offline redo logs which are generally called as Archive Logs.

Archive logs are required to rebuild the system from the previous backups.

Normally in an SAP environment the Redo logs are located in

/oracle/<sid>/origlogA

/oracle/<sid>/origlogB

/oracle/<sid>/mirrlogA

/oracle/<sid>/mirrlogB

and offline logs can be found in

/oracle/<sid>/saparch.

Regards,

Sam