Changing the Time Format In RMAN Logs for Oracle Backups

When you debug scripts, it may be useful to change the default RMAN date timestamp parameter, which is:

Mon DD YYYY HH24:MI:SS

A date of June 30th 2010 at 1:10 p.m. displays as 06-30-2010 13:10:00.

Procedure

  1. Right-click the Client and then click Properties.
  2. On the Properties dialog box, click the Advanced button.
  3. On the Additional Settings tab of the Advanced Properties dialog box click Add.
  4. On the Add Additional Setting dialog box:
    1. In the Name box, enter NLS_DATE_FORMAT.
    2. In the Category box, select OracleAgent.
    3. In the Type box, select String.
    4. In the Value box, type the time format.
    5. Click OK to close the Additional Settings dialog box.
  5. Click OK to close the Advanced Properties dialog box.

Example

To set the time format so the day comes first, type DD-MM-YYYY HH24:MI:SS in the Value box.