Modify the time display of the Rman List command output as needed
$ Rman Target/Recovery manager:release11.2.0.4.0-Production on Wed Jul1 -: +: - -Copyright (c)1982, ., Oracle and/or its affiliates. All rights reserved.connected to target DATABASE:YB1 (DBID=1592461412) RMAN>list backup;usingTarget Database control file instead of recovery cataloglist of Backup sets===================BS Key type LV Size Device Type Elapsed time completion time------- ---- -- ---------- ----------- ------------ -------------------- atFull2.25MDISKxx:xx:Geneva -jul-: BP Key: atstatus:available compressed:no tag:tag20150701t141217 Piece Name:/u01/app/oracle/fast_recovery_area/yb1/backupset/2015_07_01/O1_MF_NNNDF_TAG20150701T141217_BS7161SD_.BKP List of DatafilesinchBackupSet atFile LV Type Ckp SCN Ckp time Name---- -- ---- ---------- -------------------- ----3Full1062085 on-jul- - -: A: -/u01/app/oracle/oradata/yb1/Undotbs01.dbfrman>
Set the time format by setting the parameter Nls_date_format:
$export nls_date_format='yyyy-mm-dd HH24:MI:SS' $ rman Target/Recovery manager:release11.2.0.4.0-Production on Wed Jul1 -: +: $ -Copyright (c)1982, ., Oracle and/or its affiliates. All rights reserved.connected to target DATABASE:YB1 (DBID=1592461412) RMAN>list backup;usingTarget Database control file instead of recovery cataloglist of Backup sets===================BS Key type LV Size Device Type Elapsed time completion time------- ---- -- ---------- ----------- ------------ ------------------- atFull2.25MDISKxx:xx:Geneva --£ º BP Key: atstatus:available compressed:no tag:tag20150701t141217 Piece Name:/u01/app/oracle/fast_recovery_area/yb1/backupset/2015_07_01/O1_MF_NNNDF_TAG20150701T141217_BS7161SD_.BKP List of DatafilesinchBackupSet atFile LV Type Ckp SCN Ckp time Name---- -- ---- ---------- ------------------- ----3Full1062085 -- -- on -: A: -/u01/app/oracle/oradata/yb1/Undotbs01.dbfrman>
Modify the time format of the Rman List command output