RE: HH24:MI:SS in RMAN log

  • From: "John Hallas" <john.hallas@xxxxxxxxxx>
  • To: <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Apr 2008 17:16:27 +0100

Works for me still (11g)

 

export NLS_DATE_FORMAT='DD-MON-YY HH24:MI:SS'   (note the single quotes
- you don't seem to have them)

.

.

.

Finished backup at 13-APR-08 20:31:08

 

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

piece handle=/backups/db/rman/c-1945775739-20080413-04 comment=NONE

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

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kline.Michael
Sent: 14 April 2008 12:57
To: oracle-l@xxxxxxxxxxxxx
Subject: HH24:MI:SS in RMAN log

 

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

 

NLS_DATE_FORMAT=YYYY-MM-DD:HH24:MI:SS; export NLS_DATE_FORMAT

Call rman.

 

That doesn't seem to cut now. Is there something else? I'm getting:

 

 

VERSION 9.2.0.6, HP/UX:

 

channel ch00: starting piece 1 at 14-APR-08

channel ch02: finished piece 1 at 14-APR-08

piece handle=COLD_bk_upujdpacv_s1854_p1_t651995551 comment=API Version
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

 

Maybe I'm losing my setting some how?

 

Michael Kline



 

  

 

 

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.
 
SunTrust and Seeing beyond money are federally registered service 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.
In the absence of written agreement to the contrary BJSS’ relevant standard 
terms of contract for any work to be undertaken will apply.
Please 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.
BJSS Limited, a company registered in England and Wales (Company Number 
2777575), VAT Registration Number 613295452, Registered Office Address, First 
Floor, Coronet House, Queen Street, Leeds, LS1 2TW

Other related posts: