Database Software

Is there any other way to set the NLS_DATE_FORMAT from within RMAN?

The NLS_DATE_FORMAT can be set at the operating system level, it can also be set in the database.

Where the default NLS_DATE_FORMAT="DD-MON-YYYY" the output from RMAN does not give the information I would like as "DD-MON-YYYY HH24:MI:SS" is more detailed.

Unfortunately with NMDA (networker) it is not possible to set the NLS_DATE_FORMAT in a straightforward manner. I have the option of setting it in the shell's profile (rc script) for it to pick up (I would prefer to avoid workarounds).

So, is there any other way to set the NLS_DATE_FORMAT from within RMAN? I also tried:

sql 'alter session set NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"';

Does not do anything as that is probably its own session seperate to the allocated channels sessions. For anything to work it would need to apply to all channels to the database.

I even had a look at if there was an equivalent glogin.sql (sqlplus) for rman, does not look like it.