Re: RMAN display of date AND time

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Fri, 7 Oct 2005 01:54:20 -0700 (PDT)
Message-ID: <20051007085420.72271.qmail@web33110.mail.mud.yahoo.com>

Hi Dave,

You can export the NLS_DATE_FORMAT shell variable before starting rman. For example:

export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"

Charlotte

>> "Herring Dave - dherri"

<Dave.Herring_at_acxiom.com>
>>Sent by: oracle-l-bounce_at_freelists.org
>>06/10/2005 22:54
>>Please respond to Dave.Herring
>>
>> To: "Oracle-L_at_Freelists. Org (E-mail)"
<oracle-l_at_freelists.org>
>> cc:
>> Subject: RMAN display of date AND time
>>
>>
>>
>>Is there any way to get RMAN to display the time
portion of the date in it's l
og? For example, during a backup I'll messages like:
>>
>>channel c3: starting piece 1 at 06-OCT-05
>>
>>... but I'd like these messages to include the time
as well. I thought it'd b
e simple enough to issue the following command before any allocation of channel
commands, but that didn't work either:
>>
>>SQL "ALTER SESSION SET nls_date_format = ''DD-MON-YY
HH24:MI:SS''";
>>
>>Any ideas?
>>
>>Dave
>>-------------------------------------
>>Dave Herring, DBA
>>Acxiom Corporation
>>3333 Finley
>>Downers Grove, IL 60515
>>wk: 630.944.4762
>><mailto:dherri_at_acxiom.com>
>>-------------------------------------
>>
                

---

Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 07 2005 - 03:57:56 CDT