Re: No timestamps for redolog switches on Windohs?

On 3/14/06, Jesse, Rich <Rich.Jesse_at_quadtechworld.com> 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
> --
> http://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

--
http://www.freelists.org/webpage/oracle-l