Customize the date and time format displayed by RMAN

By default, the date and time formats displayed by RMAN are displayed only on the RMAN backup and recovery page, but no specific time is specified. Sometimes you need to view the specific time, for example, to view multiple Incarnation events of the current day. To solve this problem, set the Environment Variable Parameter NLS_DATE_FORMAT, as described below. 1. Default format of RMAN Date and Time: robin @ SZDB: ~> Rman target/Recovery Manager: Release 10.2.0.3.0-Production on Sat Jun 1 13:54:49 2013 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to target database: GOBO1 (DBID = 733951103) RMAN> list incarnation; using target database control file instead of recovery catalog List of Database Incarnations DB Key Inc Key DB Name db id status Reset SCN Reset Time ------------------------ -------------- --- ---------- 1 GOBO1 733951103 PARENT 1 18-FEB-09 2 2 GOBO1 733951103 PARENT 79915248 20-SEP-12 3 3 3 GOBO1 733951103 PARENT 80298787 31-MAY-13 4 4 GOBO1 733951103 CURRENT 80307144 31-MAY-13 RMAN> exit Recovery Manager complete. 2. Modify environment variables to customize the RMAN date and time format. robin @ SZDB: ~> Export NLS_DATE_FORMAT = 'yyyymmdd hh24: mi: ss'; robin @ SZDB: ~> Rman target/Recovery Manager: Release 10.2.0.3.0-Production on Sat Jun 1 13:55:30 2013 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to target database: GOBO1 (DBID = 733951103) RMAN> list incarnation; using target database control file instead of recovery catalog List of Database Incarnations DB Key Inc Key DB Name db id status Reset SCN Reset Time ------------------------ -------------- --- ---------- 1 GOBO1 733951103 PARENT 1 20090218 16:43:43 2 2 2 GOBO1 733951103 PARENT 79915248 20120920 15:00:44 3 3 3 GOBO1 733951103 PARENT 80298787 21:03:41 4 4 4 GOBO1 20130531 CURRENT 733951103 80307144 22:28:05 3. Permanent modification the best way to format the RMAN date and time is to add the parameter directly. bash_profile robin @ SZDB: ~> Echo "export NLS_DATE_FORMAT = 'yyyymmdd hh24: mi: ss'" >> ~ /. Bash_profile