RE: No timestamps for redolog switches on Windohs?

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: "Oracle-L@Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Mar 2006 08:43:49 -0600

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@xxxxxxxxxxxxx
>  [mailto:oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx> ] On Behalf Of Jesse, Rich
>  Sent: 14 March 2006 19:44
>  To: Oracle-L@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
>  --
>  //www.freelists.org/webpage/oracle-l
<//www.freelists.org/webpage/oracle-l> 
> 
> 
> 
> 


Other related posts: