Re: No timestamps for redolog switches on Windohs?
- From: "Paul Drake" <bdbafh@xxxxxxxxx>
- To: Rich.Jesse@xxxxxxxxxxxxxxxxx
- Date: Tue, 14 Mar 2006 15:13:43 -0500
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
Other related posts:
