RE: HH24:MI:SS in RMAN log
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: <john.hallas@xxxxxxxxxx>, <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Apr 2008 16:22:50 -0500
Works fine for me on 9.2.0.8 Tru64.
(in script)
export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
...
(from output)
Starting backup at 15-APR-2008 16:01:59
...
channel ORA_SBT_TAPE_1: starting piece 1 at 15-APR-2008 16:02:28
Dave
___________________________________
Dave Herring, DBA | A c x i o m M I C S / C S O
630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of John Hallas
Sent: Monday, April 14, 2008 11:16 AM
To: Michael.Kline@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: HH24:MI:SS in RMAN log
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
*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*************************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
