On 3/14/06, Jesse, Rich <Rich.Jesse@xxxxxxxxxxxxxxxxx> wrote: > > Hey all, > > As I'm migrating two DBs from 8.1.7.4.0 to 9.2.0.7.0 (+Jan2006 patch), I > see that the alert.log for the new 9i database has no timestamps for the > redolog changes, unlike other DBs we have. The main differences between > this and other DBs I have are: > > 1) These DBs are on Windohs; others are on Unix/Linux. > 2) These DBs are NOT in ARCHIVELOG mode (as per SLA/EULA -- > don't ask). > > I would normally just fire up another DB and put it into archivelog mode > to see if the alert.log would have timestamps, but I don't have a box > free to try this on. > > Thoughts? > > Rich > -- > //www.freelists.org/webpage/oracle-l > > > Rich, Sorry, but I don't have any 9.2 win32 dbs to test against. Perhaps an upgrade to 10g R1 with 10.1.0.4 and 10.1.0.4 patch 10 might be in order? Perhaps 10.1.0.5 + the CPUJan2006 patch instead? Here is a snipped from an alert log from yesterday. Yes, the online redo logs are being switched here far too frequently. No, the online redo logs are sized just fine - there's just too much redo being generated. That is another matter. Paul Mon Mar 13 17:22:43 2006 ARC1: Evaluating archive thread 1 sequence 4911 Committing creation of archivelog 'H:\ORACLE\ORADATA\MYDB\ARCHIVE\MYDB_562170012_1_4911.LOG' Mon Mar 13 17:23:03 2006 Private_strands 18 at log switch Thread 1 advanced to log sequence 4913 Current log# 1 seq# 4913 mem# 0: E:\ORACLE\ORADATA\MYDB\REDO01A.LOG Mon Mar 13 17:23:03 2006 ARC1: Evaluating archive thread 1 sequence 4912 Committing creation of archivelog 'H:\ORACLE\ORADATA\MYDB\ARCHIVE\MYDB_562170012_1_4912.LOG' Mon Mar 13 17:23:22 2006 Private_strands 18 at log switch Thread 1 advanced to log sequence 4914 Current log# 2 seq# 4914 mem# 0: E:\ORACLE\ORADATA\MYDB\REDO02A.LOG Mon Mar 13 17:23:22 2006 ARC1: Evaluating archive thread 1 sequence 4913 Committing creation of archivelog 'H:\ORACLE\ORADATA\MYDB\ARCHIVE\MYDB_562170012_1_4913.LOG' Mon Mar 13 17:23:41 2006 Private_strands 18 at log switch Thread 1 advanced to log sequence 4915 Current log# 3 seq# 4915 mem# 0: E:\ORACLE\ORADATA\MYDB\REDO03A.LOG Mon Mar 13 17:23:41 2006 ARC1: Evaluating archive thread 1 sequence 4914 Committing creation of archivelog 'H:\ORACLE\ORADATA\MYDB\ARCHIVE\MYDB_562170012_1_4914.LOG' Mon Mar 13 17:24:01 2006 Private_strands 18 at log switch Thread 1 advanced to log sequence 4916 Current log# 4 seq# 4916 mem# 0: E:\ORACLE\ORADATA\MYDB\REDO04A.LOG Mon Mar 13 17:24:01 2006 ARC1: Evaluating archive thread 1 sequence 4915 Committing creation of archivelog 'H:\ORACLE\ORADATA\MYDB\ARCHIVE\MYDB_562170012_1_4915.LOG' Mon Mar 13 17:24:20 2006 Private_strands 18 at log switch Thread 1 advanced to log sequence 4917 Current log# 1 seq# 4917 mem# 0: E:\ORACLE\ORADATA\MYDB\REDO01A.LOG Mon Mar 13 17:24:20 2006 ARC1: Evaluating archive thread 1 sequence 4916 Committing creation of archivelog 'H:\ORACLE\ORADATA\MYDB\ARCHIVE\MYDB_562170012_1_4916.LOG' Mon Mar 13 17:24:41 2006 Private_strands 18 at log switch Thread 1 advanced to log sequence 4918 Current log# 2 seq# 4918 mem# 0: E:\ORACLE\ORADATA\MYDB\REDO02A.LOG