Customize the date and time format displayed by RMAN

By default, only the date is displayed on the RMAN backup and recovery interface, but there is no specific time. 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 1 gobo 1 733951103 PARENT 1 18-FEB-09
2 2 GOBO1 733951103 PARENT 79915248 20-SEP-12
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 1 GOBO1 733951103 PARENT 1 20090218 16:43:43
2 2 GOBO1 733951103 PARENT 79915248 20120920 15:00:44
3 3 GOBO1 733951103 PARENT 80298787 20130531 21:03:41
4 4 GOBO1 733951103 CURRENT 80307144 20130531 22:28:05

-- Author:

3. permanently modify the RMAN Date and Time Format
The best way is to add the parameter directly to. bash_profile.
Robin @ SZDB: ~> Echo "export NLS_DATE_FORMAT = 'yyyymmdd hh24: mi: ss'" >> ~ /. Bash_profile