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?
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:
  


Current Time: Wed Dec 07 08:48:13 CST 2016

Total time taken to generate the page: 0.18796 seconds