Skip to Content
0
Former Member
Jul 08, 2010 at 11:15 AM

log_dir and LOGARCHMETH1

67 Views

Hello All,

I have Installed SAP System on June 30th.

On July 6th I changed the LOGARCHMETH1 value to a location in the Disk.

Immediately took a Offline Backup(as it is mandatory) and then started DB and SAP.

Now today, My log files look like this,

Contents of LOG_DIR:

#ls -ltr

total 1258752

-rw------- 1 db2smr dbsmradm 512 Jun 30 15:00 SQLLPATH.TAG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000011.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000010.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000014.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000013.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000012.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000016.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000015.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000018.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000017.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 12:14 S0000019.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 17:01 S0000020.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 17:37 S0000021.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 6 18:02 S0000022.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 7 10:54 S0000023.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 8 09:53 S0000025.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 8 09:53 S0000024.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 8 09:53 S0000026.LOG

-rw------- 1 db2smr dbsmradm 12619776 Jul 8 11:22 S0000007.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 8 14:03 S0000008.LOG

-rw------- 1 db2smr dbsmradm 67100672 Jul 8 16:10 S0000009.LOG

Contents of LOGARCHMETH1

#cd /db2/archiveLog////

  1. ls -ltr

total 308640

-rw-r r 1 db2smr dbsmradm 410 Jul 6 16:50 chive

-rw-r----- 1 db2smr dbsmradm 12451840 Jul 6 17:01 S0000000.LOG

-rw-r----- 1 db2smr dbsmradm 11530240 Jul 6 17:26 S0000001.LOG

-rw-r----- 1 db2smr dbsmradm 10944512 Jul 6 18:02 S0000002.LOG

-rw-r----- 1 db2smr dbsmradm 11722752 Jul 6 19:07 S0000003.LOG

-rw-r----- 1 db2smr dbsmradm 67100672 Jul 7 15:04 S0000004.LOG

-rw-r----- 1 db2smr dbsmradm 67100672 Jul 7 17:09 S0000005.LOG

-rw-r----- 1 db2smr dbsmradm 55078912 Jul 7 19:39 S0000006.LOG

-rw-r----- 1 db2smr dbsmradm 12619776 Jul 8 11:22 S0000007.LOG

-rw-r----- 1 db2smr dbsmradm 67100672 Jul 8 14:03 S0000008.LOG

Now my questions is:

1. I will backup the Archive Logs from the dir LOGARCHMETH1. What do I do with the files of log_dir? Do they need to be backed up?

2. If answer to question 1 is NO, then active log file is in log_dir, will it be not required? can we ignore all the files in log_dir?

3. Incase of a disaster, say right now, while doing roll forward, will it ask for a log file that is present in log_dir but not in LOGARCHMETH1?

4. After switching on the parameter LOGARCHMETH1(on July 6th) it started the sequence of log files in that location from 0. But why the sequence of naming log files in log_dir got changed to 7 on Jul 8 11:22 ?