I would appreciate if anyone can advise on the following scenario on a subject that at present our organisation does not have a great deal of knowledge. In our environment we are running a COTS document management system using Oracle 9i as the backend database. In our core offices this system has been configured in in a MSCS environment with Oracle Failsafe. This cluster environment is configured in an active/passive mode.
In the oracle application folders on both server nodes oracle fail safe generates a log file in the ora92\network\log folder . This file is called fslservername.log. On investigation we have discovered that this log is only updated on the server that is active. Whilst logging entries are made approximatley 4 times a minute. A sample of the entries are as follows:
"06-SEP-2004 13:25:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=erdm_cluster))(COMMAND=status)(ARGUMENTS=64)(SERVICE=Fslmc35glera)(VERSION=153092352)) * status * 0
06-SEP-2004 13:25:45 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MC34.MC34GLERC.scotland.gov.uk)(CID=(PROGRAM=E:\Objective\Objective 6i SP3 Server\bin\objindex.exe)(HOST=MC35GLERA)(USER=objective))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.12.128.97)(PORT=3186)) * establish * MC34.MC34GLERC.scotland.gov.uk * 0
06-SEP-2004 13:26:15 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MC34.MC34GLERC.scotland.gov.uk)(CID=(PROGRAM=E:\Objective\Objective 6i SP3 Server\bin\objindex."
Regarding this log file I would appreciate if anyone can help on the following points:
What is failsafe generating when writing to this log and should it be checked frequently.
Is it safe to archive these logs on routinely basis. If so what frequency would be recommended, daily, weekly, monthly etc.
Assistance in this request would be greatly appreciated.