Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 2390 invoked from network); 14 Apr 2008 11:55:06 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.server4you.com with SMTP; 14 Apr 2008 11:54:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9C71683FB87; Mon, 14 Apr 2008 12:54:44 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08400-07; Mon, 14 Apr 2008 12:54:44 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0654F83FB56; Mon, 14 Apr 2008 12:54:43 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 14 Apr 2008 12:16:31 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E112583FA40 for ; Mon, 14 Apr 2008 12:16:30 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02807-01 for ; Mon, 14 Apr 2008 12:16:30 -0400 (EDT) Received: from gateway.bjss.co.uk (host29.bjss.co.uk [82.109.33.29]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 25F6983F9E1 for ; Mon, 14 Apr 2008 12:16:29 -0400 (EDT) Received: from exchange.bjss.co.uk ([172.22.32.28]) by gateway.bjss.co.uk with Microsoft SMTPSVC(6.0.3790.3959); Mon, 14 Apr 2008 17:15:47 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C89E4A.E4976FBC" Subject: RE: HH24:MI:SS in RMAN log Date: Mon, 14 Apr 2008 17:16:27 +0100 Message-ID: In-Reply-To: <5709F47931154947BA9DB0C4C3951709019CE3B8@ga016e0m13.corp.suntrust.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: HH24:MI:SS in RMAN log From: "John Hallas" To: , X-OriginalArrivalTime: 14 Apr 2008 16:15:47.0734 (UTC) FILETIME=[CC97FB60:01C89E4A] X-archive-position: 7155 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: john.hallas@bjss.co.uk Precedence: normal Reply-to: john.hallas@bjss.co.uk List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C89E4A.E4976FBC Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-NAIMIME-Disclaimer: 1 X-NAIMIME-Modified: 1 Works for me still (11g) =20 export NLS_DATE_FORMAT=3D'DD-MON-YY HH24:MI:SS' (note the single quotes - you don't seem to have them) =2E =2E =2E Finished backup at 13-APR-08 20:31:08 =20 Starting Control File and SPFILE Autobackup at 13-APR-08 20:31:09 piece handle=3D/backups/db/rman/c-1945775739-20080413-04 comment=3DNONE Finished Control File and SPFILE Autobackup at 13-APR-08 20:31:25 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Kline.Michael Sent: 14 April 2008 12:57 To: oracle-l@freelists.org Subject: HH24:MI:SS in RMAN log =20 It used to be if you wanted a detailed timestamp in the RMAN log you just had to: =20 NLS_DATE_FORMAT=3DYYYY-MM-DD:HH24:MI:SS; export NLS_DATE_FORMAT Call rman. =20 That doesn't seem to cut now. Is there something else? I'm getting: =20 =20 VERSION 9.2.0.6, HP/UX: =20 channel ch00: starting piece 1 at 14-APR-08 channel ch02: finished piece 1 at 14-APR-08 piece handle=3DCOLD_bk_upujdpacv_s1854_p1_t651995551 comment=3DAPI Versio= n 2.0,MMS Version 5.0.0.0 channel ch02: backup set complete, elapsed time: 01:17:28 channel ch02: starting incremental level 0 datafile backupset =20 Maybe I'm losing my setting some how? =20 Michael Kline =20 =20 =20 =20 LEGAL DISCLAIMER The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. =20 SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc. [ST:XCL]=20 The information included in this email and any files transmitted with it = may contain information that is confidential and it must not be used by, = or its contents or attachments copied or disclosed, to persons other than= the intended addressee. If you have received this email in error, please= notify BJSS.=0AIn the absence of written agreement to the contrary BJSS=E2= =80=99 relevant standard terms of contract for any work to be undertaken = will apply.=0APlease carry out virus or such other checks as you consider= appropriate in respect of this email. BJSS do not accept responsibility = for any adverse effect upon your system or data in relation to this email= or any files transmitted with it.=0ABJSS Limited, a company registered i= n England and Wales (Company Number 2777575), VAT Registration Number 613= 295452, Registered Office Address, First Floor, Coronet House, Queen Stre= et, Leeds, LS1 2TW ------_=_NextPart_001_01C89E4A.E4976FBC Content-Type: text/HTML; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-NAIMIME-Disclaimer: 1 X-NAIMIME-Modified: 1

Works for me still (11g)<= /span>

 

export NLS_DATE_FORMAT=3D'DD-MON-YY HH24:MI:SS'   (note the single quotes – you don’t s= eem to have them)

.

.

.

Finished backup at 13-APR-08 20:31:0= 8

 

Starting Control File and SPFILE Autobackup at 13-APR-08 20:31:09

piece handle=3D/backups/db/rman/c-1945775739-20080413-04 comment=3DNONE

Finished Control File and SPFILE Autobackup at 13-APR-08 20:31:25

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] <= span style=3D'font-weight:bold'>On Behalf Of Kline.Michael
Sent: 14 April 2008 12:57<= br> To: oracle-l@freelists.org=
Subject: HH24:MI:SS in RMA= N log

 

It used to be if you= wanted a detailed timestamp in the RMAN log you just had to:=

 <= /span>

NLS_DATE_FORMAT=3DYY= YY-MM-DD:HH24:MI:SS; export NLS_DATE_FORMAT=

Call rman.

 <= /span>

That doesn’t s= eem to cut now. Is there something else? I’m getting:<= /font>

 <= /span>

 <= /span>

VERSION 9.2.0.6, HP/= UX:

 <= /span>

channel ch00: starti= ng piece 1 at 14-APR-08

channel ch02: finish= ed piece 1 at 14-APR-08

piece handle=3DCOLD_bk_upujdpacv_s1854_p1_t651995551 comment=3DAPI Version 2.0,= MMS Version 5.0.0.0<= /span>

channel ch02: backup= set complete, elapsed time: 01:17:28

channel ch02: starti= ng incremental level 0 datafile backupset

 <= /span>

Maybe I’m losi= ng my setting some how?

 <= /span>

Michael= Kline

 

 

 

 

LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or enti= ty to which it is addressed and may contain confidential and/or privileged mate= rial. Any review, retransmission, dissemination or other use of or taking actio= n in reliance upon this information by persons or entities other than the inte= nded recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.
 
SunTrust and Seeing beyond money are federally registered servi= ce marks of SunTrust Banks, Inc.
[ST:XCL]

The information included in this email and any files transmitted with it = may contain information that is confidential and it must not be used by, = or its contents or attachments copied or disclosed, to persons other than= the intended addressee. If you have received this email in error, please= notify BJSS.
=0AIn the absence of written agreement to the contrary B= JSS’ relevant standard terms of contract for any work to be underta= ken will apply.
=0APlease carry out virus or such other checks as you = consider appropriate in respect of this email. BJSS do not accept respons= ibility for any adverse effect upon your system or data in relation to th= is email or any files transmitted with it.
=0ABJSS Limited, a company = registered in England and Wales (Company Number 2777575), VAT Registratio= n Number 613295452, Registered Office Address, First Floor, Coronet House= , Queen Street, Leeds, LS1 2TW

------_=_NextPart_001_01C89E4A.E4976FBC-- -- http://www.freelists.org/webpage/oracle-l