Home » RDBMS Server » Backup & Recovery » timestamp in RMAN backup logs
timestamp in RMAN backup logs [message #272780] Sun, 07 October 2007 05:57 Go to next message
oracle_scorpiongirl
Messages: 39
Registered: November 2005
Member
My RMAN backup log says:

channel ch01: starting piece 1 at 02-JAN-07

everytime it starts a backup piece.

How do I get the RMAN backup log to say:

channel ch01: starting piece 1 at 02-JAN-07:11:56:57

( I mean, how do I include hr:mm:ss)

I thought I tried setting the NLS_DATE variable in the bash_profile, but it doesn't seem to work.

Suggestions?

Report message to a moderator

Re: timestamp in RMAN backup logs [message #272781 is a reply to message #272780] Sun, 07 October 2007 06:05 Go to previous message
oracle_scorpiongirl
Messages: 39
Registered: November 2005
Member
Correction: I set the NLS_DATE_FORMAT.

And also, we are using RMAN catalog database and I set the variable in both catalog and target server. (even though I thought that the value set in the target server will overwrite the one in catalog server)

[Updated on: Sun, 07 October 2007 06:11]

Report message to a moderator

Previous Topic: 10G R2 RMAN with EM
Next Topic: RMAN error in oracle 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 19:03:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.