Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: No timestamps for redolog switches on Windohs?

RE: No timestamps for redolog switches on Windohs?

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Wed, 15 Mar 2006 08:43:49 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697545F50@QTEX1.qg.com>


OK, this is wierd. After a few replies to the contrary from Paul D, Paul V, and Jay H, I rechecked my alert log:

...
Thread 1 advanced to log sequence 905
  Current log# 5 seq# 905 mem# 0: F:\...\REDO05A_SERVER.DBF Thread 1 advanced to log sequence 906
  Current log# 1 seq# 906 mem# 0: F:\...\REDO01A_SERVER.DBF Thread 1 advanced to log sequence 907
  Current log# 2 seq# 907 mem# 0: F:\...\REDO02A_SERVER.DBF Thread 1 advanced to log sequence 908
  Current log# 3 seq# 908 mem# 0: F:\...\REDO03A_SERVER.DBF Thread 1 advanced to log sequence 909
  Current log# 4 seq# 909 mem# 0: F:\...\REDO04A_SERVER.DBF Tue Mar 14 15:24:48 2006
  Replication after-import: trying to enable constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"   Replication after-import: constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" is enabled successfully   Replication after-import: trying to enable constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS"   Replication after-import: constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS" is enabled successfully ...
  Replication after-import: constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW" is enabled successfully Wed Mar 15 08:26:04 2006
Thread 1 advanced to log sequence 910
  Current log# 5 seq# 910 mem# 0: F:\...\REDO05A_SERVER.DBF Wed Mar 15 08:26:31 2006
Thread 1 advanced to log sequence 911
  Current log# 1 seq# 911 mem# 0: F:\...\REDO01A_SERVER.DBF

(names have been changed to protect the innocent)

So, when I was running catalog on the create, there were no timestamps on log switches, but afterwards there are! Like I said: Wierd!  

Rich  

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org
<mailto:oracle-l-bounce_at_freelists.org> ] On Behalf Of Jesse, Rich
> Sent: 14 March 2006 19:44
> To: Oracle-L_at_Freelists
> Subject: No timestamps for redolog switches on Windohs?
>
> 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
<http://www.freelists.org/webpage/oracle-l>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 15 2006 - 08:43:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US