[hypermail] Hypermail Problem: Folder's Date Range is Wrong

From: Frank Naude <naudefj_at_telkomsa.net_at_hypermail-project.org>
Date: 22 Jun 2003 12:59:11 -0400
Message-Id: <1056301151.2838.391.camel_at_frank.naude.co.za>

Hi,

Hypermail reports wrong "Starting" and "Ending" dates for some folders. To simulate, use the attached rc and mbox files ($ hypermail -c test.rc -m test.mbx):

First folder:

   1 messages: Starting Mon Mar 20 1995 - 09:08:17 CST,    Ending Mon Mar 20 1995 - 09:08:17 CST

Message listed:

   Mon Jan 22 1996 - 03:01:34 CST

• Re: How many levels or redo mirroring ? Bruce Pihlamae

BTW: Hypermail version is pre-2.1.8 from the CVS Server.

Best regards.

Frank Naude
naudefj_at_telkomsa.net

dir = test
folder_by_date = "%Y/%b"
reverse_folders = 1

>From daemon Sun Jan 21 17:14:18 1996

Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM)

        id AA22280; Sun, 21 Jan 1996 17:14:16 -0500 Message-Id: <9601212214.AA22280_at_alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3)

   with BSMTP id 0413; Sun, 21 Jan 96 17:04:56 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 3135; Sun, 21 Jan 1996 17:04:54 -0500 Date: Mon, 22 Jan 1996 09:01:34 +0000 Reply-To: bpihlama_at_nla.gov.au
Sender: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu> From: Bruce Pihlamae <bpihlama_at_NLA.GOV.AU> Organization: CSC

Subject:      Re: How many levels or redo mirroring ?
X-To:         Ken Friday <ken.friday_at_TELDTA.COM>, ORACLE-L_at_CCVM.SUNYSB.EDU

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>

> If I'm running my entire database (database, control, and redolog
> files) on RAID 0+1, does it make sense to have Oracle mirror the redo
> logs (in addition to the RAID protection) ?

If all your disks are already mirrored (RAID1) then don't bother doing Oracle mirroring on the REDO logs. Its extra overhead you don't need.

If you have only striped (RAID0) then you have no recoverability so you should using the Oracle REDO log mirroring.

Having said that, it is not good practice to use RAID1 mirroring on 'write only' files because of the overhead and slowness of writes. Better to RAID1 your database and keep things like REDO logs, RBS and TEMP on other fast write devices. In this case you would use Oracle's REDO log mirroring.

Bruce...

---

   T T T T T T T T        Bruce Pihlamae
   I I I I I I I I        bpihlama_at_nla.gov.au
   I I I I I I I I        National Library of Australia
   T T T T T T T T        Phone: +616 262-1480
  -----------------       Fax:   +616 273-2116
 ===================

 "If you swallow a live frog first thing in the morning;   nothing worse will happen to either of you that day."

>From owner-oracle-l_at_CCVM.SUNYSB.EDU Mon Mar 20 09:08:17 1995
Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65/1.1.8.2/01Aug94-0142PM)

        id AA15095; Mon, 20 Mar 1995 09:08:13 -0500 Message-Id: <9503201408.AA15095_at_alice.jcc.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2)

   with BSMTP id 8899; Mon, 20 Mar 95 08:54:17 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 2206; Mon, 20 Mar 1995 08:54:16 -0500 Date: Mon, 20 Mar 1995 08:35:28 GMT Reply-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> From: John C Flack <jflack_at_ACF.DHHS.GOV>

Subject:      USER_SOURCE
X-To:         ORACLE-L_at_CCVM.SUNYSB.EDU

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.sunysb.edu>

Dave Henley -
  The problem is that USER_SOURCE is not really a table, it is a view. The underlying table for that view is a data dictionary table owned by SYS. Exporting a user doesn't really export any rows in the data dictionary tables, it exports CREATE object commands for the objects owned by the userFrom owner-hypermail-outgoing_at_hypermail.org Tue Jun 24 12:49:36 2003 Return-Path: <owner-hypermail-outgoing_at_hypermail.org> Received: by dev.hypermail.org (Postfix, from userid 501)

        id AA6112704F3; Tue, 24 Jun 2003 12:49:36 -0500 (CDT) Received: from violet.rahul.net (violet.rahul.net [66.237.72.28])

	by dev.hypermail.org (Postfix) with ESMTP id 4EB572704F2
	for <hypermail_at_hypermail.org>; Tue, 24 Jun 2003 12:49:36 -0500 (CDT)
Received: by violet.rahul.net (Postfix, from userid 1448)
	id EB591BC52; Tue, 24 Jun 2003 11:47:01 -0700 (PDT)

To: hypermail_at_hypermail.org, Frank Naude <naudefj_at_telkomsa.net> Subject: Re: [hypermail] Hypermail Problem: Folder's Date Range is Wrong In-Reply-To: <1056301151.2838.391.camel_at_frank.naude.co.za> References: <1056301151.2838.391.camel_at_frank.naude.co.za> X-Mailer: VM 7.05 under Emacs 19.34.1
From: Peter C.McCluskey <pcm_at_rahul.net> Message-Id: <20030624184701.EB591BC52_at_violet.rahul.net> Date: Tue, 24 Jun 2003 11:47:01 -0700 (PDT) Sender: owner-hypermail_at_hypermail.org Precedence: bulk
Reply-To:

 I've checked in a fix for this. It looks like it was recently introduced (two getdatestr() calls in one argument list - getdatestr() returns a static buffer).

-- 
------------------------------------------------------------------------------
Peter McCluskey          | "To announce that there must be no criticism of
http://www.rahul.net/pcm | the President, or that we are to stand by the
                         | President right or wrong, is not only unpatriotic
                         | and servile, but morally treasonable to the
                         | American public." - Theodore Roosevelt

Received on Tue 24 Jun 2003 03:26:23 PM GMT