RE: HH24:MI:SS in RMAN log

From: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Mon, 14 Apr 2008 09:25:13 -0400
Message-ID: <5709F47931154947BA9DB0C4C3951709019CE3CF@ga016e0m13.corp.suntrust.com>


If the NLS_DATE_FORMAT still works, I think I found it.  

The netbackup script provided by them, builds the job in a CMD_STR.  

This starts out like this:
CMD_STR="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID  

I think all I have to do was add the NLS_DATE_FORMAT here in similar format.  

Should know when it runs next week, but I may try to find a "daily" job and check for the same thing.  

Michael Kline    


From: Kline.Michael
Sent: Monday, April 14, 2008 7:57 AM
To: 'oracle-l_at_freelists.org'
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]        

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 14 2008 - 08:25:13 CDT

Original text of this message