Hi there,
first of all thank you very much for the numerous messages.
Of course i owe you some more informations:
We have 4 Oracle 8.1.7 instances running on a single cpu (PIII750) Winnt4
machine with
1 GB ram.
There are two drives created on a raid level 5 (drive c:, d:).
No other internal drives for e.g. raid 1 are available !!!!
All Oracle files including datafiles, redologs, archives and even the
controlfiles are located
on drive d: !!!!!!
(don`t beat me - i know it's sheer lunacy! - but i have to administrate it
and did not set
it up that way)
The client application running on top is a "small" CRM-solution for a
call-center !
Two of the oracle instances are the productive databases - that means each
of it has its own
CRM application & call-center !
Both of them are having the archive mode & automatic archival enabled plus
one more
test-database running in the same mode (but low/less user activations). The
last database
is very infrequently visited - no archive mode enabled !
As i have taken over this machine there were just 3 redolog groups with just
one 1MB member !
So far the archive mode was still disabled.
Almost frequently the client-server connection has gone lost - several times
a week.
By having a view on the alertlog i noticed heavy logswitching.
Therefore i decided to modify the redolog configuration as a first step on
my troubleshooting path.
(due to sequrity/recovery issues i have enabled the archive mode as well)
2 times a week (not scheduled - just triggered by a user) an import from
another host system is
started. The amount of datas do almost have the same size (thats what i was
told).
As the redolog size was set to 1MB this import has taken two hours runtime.
Now after the modification (4 members / 10MB each) the import takes more 24
hours.
Unfortunately i don`t have the init<sid>.ora available now - cause i´m not
at work.
But please find below a part of the oracle alert log taken yesterday.
What problems do you see ?
By the way i have requested 2 hd`s to build up a raid1 to place all redologs
on this logical disc - although
it is just a interim solution.
Thank you very much
Bud
ARC0: STARTING ARCH PROCESSES
ARC1 started with pid=13
Mon Mar 03 16:20:10 2003
ARC0: STARTING ARCH PROCESSES COMPLETE
Mon Mar 03 16:20:10 2003
ARC1: Archival started
Mon Mar 03 16:20:10 2003
ARC0: Beginning to archive log# 1 seq# 1874
Mon Mar 03 16:20:17 2003
Thread 1 advanced to log sequence 1876
Current log# 3 seq# 1876 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Mon Mar 03 16:20:17 2003
ARC1: Beginning to archive log# 1 seq# 1874
ARC1: Failed to archive log# 1 seq# 1874
ARC1: Beginning to archive log# 2 seq# 1875
Mon Mar 03 16:20:18 2003
ARC0: Completed archiving log# 1 seq# 1874
ARC0: Beginning to archive log# 2 seq# 1875
ARC0: Failed to archive log# 2 seq# 1875
ARC0: Beginning to archive log# 2 seq# 1875
ARC0: Failed to archive log# 2 seq# 1875
Mon Mar 03 16:20:25 2003
ARC1: Completed archiving log# 2 seq# 1875
Mon Mar 03 16:20:28 2003
Thread 1 advanced to log sequence 1877
Current log# 4 seq# 1877 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Mon Mar 03 16:20:28 2003
ARC0: Beginning to archive log# 3 seq# 1876
ARC0: Completed archiving log# 3 seq# 1876
Mon Mar 03 16:20:38 2003
Thread 1 advanced to log sequence 1878
Current log# 1 seq# 1878 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Mon Mar 03 16:20:38 2003
ARC0: Beginning to archive log# 4 seq# 1877
ARC0: Completed archiving log# 4 seq# 1877
Mon Mar 03 16:20:48 2003
Thread 1 advanced to log sequence 1879
Current log# 2 seq# 1879 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Mon Mar 03 16:20:48 2003
ARC0: Beginning to archive log# 1 seq# 1878
ARC0: Completed archiving log# 1 seq# 1878
Mon Mar 03 16:20:59 2003
Thread 1 advanced to log sequence 1880
Current log# 3 seq# 1880 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Mon Mar 03 16:20:59 2003
ARC0: Beginning to archive log# 2 seq# 1879
ARC0: Completed archiving log# 2 seq# 1879
Mon Mar 03 16:28:37 2003
Thread 1 advanced to log sequence 1881
Current log# 4 seq# 1881 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Mon Mar 03 16:28:37 2003
ARC0: Beginning to archive log# 3 seq# 1880
kccrsz: expanded controlfile section 11 from 13 to 27 records
requested to grow by 13 record(s); added 1 block(s) of records
ARC0: Completed archiving log# 3 seq# 1880
Mon Mar 03 16:36:23 2003
Thread 1 advanced to log sequence 1882
Current log# 1 seq# 1882 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Mon Mar 03 16:36:23 2003
ARC0: Beginning to archive log# 4 seq# 1881
ARC0: Completed archiving log# 4 seq# 1881
Mon Mar 03 16:44:13 2003
Thread 1 advanced to log sequence 1883
Current log# 2 seq# 1883 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Mon Mar 03 16:44:13 2003
ARC0: Beginning to archive log# 1 seq# 1882
ARC0: Completed archiving log# 1 seq# 1882
Mon Mar 03 16:51:58 2003
Thread 1 advanced to log sequence 1884
Current log# 3 seq# 1884 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Mon Mar 03 16:51:58 2003
ARC0: Beginning to archive log# 2 seq# 1883
ARC0: Completed archiving log# 2 seq# 1883
Mon Mar 03 16:59:51 2003
Thread 1 advanced to log sequence 1885
Current log# 4 seq# 1885 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Mon Mar 03 16:59:51 2003
ARC0: Beginning to archive log# 3 seq# 1884
ARC0: Completed archiving log# 3 seq# 1884
Mon Mar 03 17:07:45 2003
Thread 1 advanced to log sequence 1886
Current log# 1 seq# 1886 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Mon Mar 03 17:07:45 2003
ARC0: Beginning to archive log# 4 seq# 1885
ARC0: Completed archiving log# 4 seq# 1885
Mon Mar 03 17:15:41 2003
Thread 1 advanced to log sequence 1887
Current log# 2 seq# 1887 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Mon Mar 03 17:15:41 2003
ARC0: Beginning to archive log# 1 seq# 1886
ARC0: Completed archiving log# 1 seq# 1886
Mon Mar 03 17:23:45 2003
Thread 1 advanced to log sequence 1888
Current log# 3 seq# 1888 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Mon Mar 03 17:23:45 2003
ARC0: Beginning to archive log# 2 seq# 1887
ARC0: Completed archiving log# 2 seq# 1887
Mon Mar 03 17:31:49 2003
Thread 1 advanced to log sequence 1889
Current log# 4 seq# 1889 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Mon Mar 03 17:31:49 2003
ARC0: Beginning to archive log# 3 seq# 1888
ARC0: Completed archiving log# 3 seq# 1888
Mon Mar 03 18:04:42 2003
Thread 1 advanced to log sequence 1890
Current log# 1 seq# 1890 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Mon Mar 03 18:04:42 2003
ARC0: Beginning to archive log# 4 seq# 1889
ARC0: Completed archiving log# 4 seq# 1889
Mon Mar 03 19:19:24 2003
Thread 1 advanced to log sequence 1891
Current log# 2 seq# 1891 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Mon Mar 03 19:19:24 2003
ARC0: Beginning to archive log# 1 seq# 1890
ARC0: Completed archiving log# 1 seq# 1890
Mon Mar 03 21:32:00 2003
Thread 1 advanced to log sequence 1892
Current log# 3 seq# 1892 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Mon Mar 03 21:32:00 2003
ARC0: Beginning to archive log# 2 seq# 1891
ARC0: Completed archiving log# 2 seq# 1891
Tue Mar 04 00:48:08 2003
Thread 1 advanced to log sequence 1893
Tue Mar 04 00:48:08 2003
Current log# 4 seq# 1893 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Tue Mar 04 00:48:08 2003
ARC0: Beginning to archive log# 3 seq# 1892
Tue Mar 04 00:48:10 2003
ARC0: Completed archiving log# 3 seq# 1892
Tue Mar 04 04:02:58 2003
Thread 1 advanced to log sequence 1894
Current log# 1 seq# 1894 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Tue Mar 04 04:02:58 2003
ARC0: Beginning to archive log# 4 seq# 1893
ARC0: Completed archiving log# 4 seq# 1893
Tue Mar 04 06:59:34 2003
Thread 1 advanced to log sequence 1895
Current log# 2 seq# 1895 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Tue Mar 04 06:59:34 2003
ARC0: Beginning to archive log# 1 seq# 1894
kccrsz: expanded controlfile section 11 from 27 to 55 records
requested to grow by 27 record(s); added 2 block(s) of records
ARC0: Completed archiving log# 1 seq# 1894
Tue Mar 04 09:15:11 2003
Thread 1 advanced to log sequence 1896
Current log# 3 seq# 1896 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Tue Mar 04 09:15:11 2003
ARC0: Beginning to archive log# 2 seq# 1895
ARC0: Completed archiving log# 2 seq# 1895
Tue Mar 04 10:20:12 2003
Thread 1 advanced to log sequence 1897
Current log# 4 seq# 1897 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Tue Mar 04 10:20:12 2003
ARC0: Beginning to archive log# 3 seq# 1896
ARC0: Completed archiving log# 3 seq# 1896
Tue Mar 04 11:25:09 2003
Thread 1 advanced to log sequence 1898
Current log# 1 seq# 1898 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Tue Mar 04 11:25:09 2003
ARC0: Beginning to archive log# 4 seq# 1897
ARC0: Completed archiving log# 4 seq# 1897
Tue Mar 04 12:27:36 2003
Thread 1 advanced to log sequence 1899
Current log# 2 seq# 1899 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Tue Mar 04 12:27:36 2003
ARC0: Beginning to archive log# 1 seq# 1898
ARC0: Completed archiving log# 1 seq# 1898
Tue Mar 04 13:34:31 2003
Thread 1 advanced to log sequence 1900
Current log# 3 seq# 1900 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Tue Mar 04 13:34:31 2003
ARC0: Beginning to archive log# 2 seq# 1899
ARC0: Completed archiving log# 2 seq# 1899
Tue Mar 04 14:42:30 2003
Thread 1 advanced to log sequence 1901
Current log# 4 seq# 1901 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Tue Mar 04 14:42:30 2003
ARC0: Beginning to archive log# 3 seq# 1900
ARC0: Completed archiving log# 3 seq# 1900
Tue Mar 04 15:51:49 2003
Thread 1 advanced to log sequence 1902
Current log# 1 seq# 1902 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Tue Mar 04 15:51:49 2003
ARC0: Beginning to archive log# 4 seq# 1901
ARC0: Completed archiving log# 4 seq# 1901
Tue Mar 04 17:20:59 2003
Thread 1 advanced to log sequence 1903
Current log# 2 seq# 1903 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Tue Mar 04 17:20:59 2003
ARC0: Beginning to archive log# 1 seq# 1902
ARC0: Completed archiving log# 1 seq# 1902
Tue Mar 04 19:23:03 2003
Thread 1 advanced to log sequence 1904
Current log# 3 seq# 1904 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Tue Mar 04 19:23:03 2003
ARC0: Beginning to archive log# 2 seq# 1903
ARC0: Completed archiving log# 2 seq# 1903
Tue Mar 04 22:13:02 2003
Thread 1 advanced to log sequence 1905
Tue Mar 04 22:13:02 2003
Current log# 4 seq# 1905 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Tue Mar 04 22:13:04 2003
ARC0: Beginning to archive log# 3 seq# 1904
Tue Mar 04 22:13:13 2003
ARC0: Completed archiving log# 3 seq# 1904
Wed Mar 05 01:07:17 2003
Thread 1 advanced to log sequence 1906
Current log# 1 seq# 1906 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Wed Mar 05 01:07:17 2003
ARC0: Beginning to archive log# 4 seq# 1905
ARC0: Completed archiving log# 4 seq# 1905
Wed Mar 05 04:03:23 2003
Thread 1 advanced to log sequence 1907
Current log# 2 seq# 1907 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Wed Mar 05 04:03:23 2003
ARC0: Beginning to archive log# 1 seq# 1906
ARC0: Completed archiving log# 1 seq# 1906
Wed Mar 05 07:01:09 2003
Thread 1 advanced to log sequence 1908
Current log# 3 seq# 1908 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Wed Mar 05 07:01:09 2003
ARC0: Beginning to archive log# 2 seq# 1907
ARC0: Completed archiving log# 2 seq# 1907
Wed Mar 05 09:44:03 2003
Thread 1 advanced to log sequence 1909
Current log# 4 seq# 1909 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Wed Mar 05 09:44:03 2003
ARC0: Beginning to archive log# 3 seq# 1908
ARC0: Completed archiving log# 3 seq# 1908
Wed Mar 05 11:12:25 2003
Thread 1 advanced to log sequence 1910
Current log# 1 seq# 1910 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Wed Mar 05 11:12:25 2003
ARC0: Beginning to archive log# 4 seq# 1909
ARC0: Completed archiving log# 4 seq# 1909
Wed Mar 05 11:16:21 2003
Thread 1 advanced to log sequence 1911
Current log# 2 seq# 1911 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Wed Mar 05 11:16:21 2003
ARC0: Beginning to archive log# 1 seq# 1910
ARC0: Completed archiving log# 1 seq# 1910
Wed Mar 05 11:16:32 2003
Thread 1 advanced to log sequence 1912
Current log# 3 seq# 1912 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Wed Mar 05 11:16:33 2003
ARC0: Beginning to archive log# 2 seq# 1911
ARC0: Completed archiving log# 2 seq# 1911
Wed Mar 05 11:16:43 2003
Thread 1 advanced to log sequence 1913
Current log# 4 seq# 1913 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Wed Mar 05 11:16:43 2003
ARC0: Beginning to archive log# 3 seq# 1912
ARC0: Completed archiving log# 3 seq# 1912
Wed Mar 05 11:16:54 2003
Thread 1 advanced to log sequence 1914
Current log# 1 seq# 1914 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG
Wed Mar 05 11:16:55 2003
ARC0: Beginning to archive log# 4 seq# 1913
ARC0: Completed archiving log# 4 seq# 1913
Wed Mar 05 11:17:05 2003
Thread 1 advanced to log sequence 1915
Current log# 2 seq# 1915 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG
Wed Mar 05 11:17:05 2003
ARC0: Beginning to archive log# 1 seq# 1914
ARC0: Completed archiving log# 1 seq# 1914
Wed Mar 05 11:17:17 2003
Thread 1 advanced to log sequence 1916
Current log# 3 seq# 1916 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG
Wed Mar 05 11:17:17 2003
ARC0: Beginning to archive log# 2 seq# 1915
ARC0: Completed archiving log# 2 seq# 1915
Wed Mar 05 11:44:40 2003
Thread 1 advanced to log sequence 1917
Current log# 4 seq# 1917 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG
Wed Mar 05 11:44:40 2003
ARC0: Beginning to archive log# 3 seq# 1916
ARC0: Completed archiving log# 3 seq# 1916
Received on Thu Mar 06 2003 - 06:14:09 CST