How to set the date and time format for RMAN

Wednesday, May 21, 2025

How to set the date and time format for RMAN

setting the date and time format for RMAN

You can set the date and time format for RMAN output using the NLS_DATE_FORMAT and NLS_LANG environment variables before starting RMAN.

For Unix/Linux:

export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

rman target /

For Windows (Command Prompt):

set NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

rman target /

[oracle@orcl dbs]$

[oracle@orcl dbs]$ export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

[oracle@orcl dbs]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

[oracle@orcl dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Wed May 21 12:41:50 2025

Version 19.3.0.0.0

connected to target database: DB1 (DBID=1788905834)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

1 Full 17.95M DISK 00:00:01 2025-03-06 12:58:33

BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20250306T125831

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_03_06/o1_mf_s_1195045112_mwm6zsr4_.bkp

SPFILE Included: Modification time: 2025-03-06 12:48:41

SPFILE db_unique_name: DB1

Control File Included: Ckp SCN: 2142808 Ckp time: 2025-03-06 12:58:32

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

2 Full 17.95M DISK 00:00:01 2025-04-29 07:01:08

BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20250429T070107

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199689267_n10y9nxy_.bkp

SPFILE Included: Modification time: 2025-04-29 05:55:51

SPFILE db_unique_name: DB1

Control File Included: Ckp SCN: 2493621 Ckp time: 2025-04-29 07:01:07

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

3 Full 17.95M DISK 00:00:02 2025-04-29 07:11:13

BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20250429T071111

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199689871_n10ywkbc_.bkp

SPFILE Included: Modification time: 2025-04-29 05:55:51

SPFILE db_unique_name: DB1

Control File Included: Ckp SCN: 2494671 Ckp time: 2025-04-29 07:11:11

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

4 Full 17.95M DISK 00:00:02 2025-04-29 07:21:18

BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20250429T072116

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199690476_n10zhg00_.bkp

SPFILE Included: Modification time: 2025-04-29 07:14:43

SPFILE db_unique_name: DB1

Control File Included: Ckp SCN: 2495971 Ckp time: 2025-04-29 07:21:16

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

5 Full 17.95M DISK 00:00:02 2025-05-21 10:39:40

BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20250521T103938

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_21/o1_mf_s_1201689578_n2vccdph_.bkp

SPFILE Included: Modification time: 2025-05-21 10:19:41

SPFILE db_unique_name: DB1

Control File Included: Ckp SCN: 2919395 Ckp time: 2025-05-21 10:39:38

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

6 Full 1.21G DISK 00:00:38 2025-05-21 12:15:41

BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20250521T121502

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/backupset/2025_05_21/o1_mf_nnndf_TAG20250521T121502_n2vjy7y0_.bkp

List of Datafiles in backup set 6

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- ------------------- ----------- ------ ----

1 Full 2923534 2025-05-21 12:15:03 NO /u01/app/oracle/oradata/DB1/system01.dbf

3 Full 2923534 2025-05-21 12:15:03 NO /u01/app/oracle/oradata/DB1/sysaux01.dbf

4 Full 2923534 2025-05-21 12:15:03 NO /u01/app/oracle/oradata/DB1/undotbs01.dbf

7 Full 2923534 2025-05-21 12:15:03 NO /u01/app/oracle/oradata/DB1/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

7 Full 474.72M DISK 00:00:11 2025-05-21 12:15:59

BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20250521T121502

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/2FACECCE69615207E0630400040AB366/backupset/2025_05_21/o1_mf_nnndf_TAG20250521T121502_n2vjzns9_.bkp

List of Datafiles in backup set 7

Container ID: 3, PDB Name: PDB

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- ------------------- ----------- ------ ----

9 Full 2627500 2025-04-30 06:56:07 NO /u01/app/oracle/oradata/DB1/pdb/system01.dbf

10 Full 2627500 2025-04-30 06:56:07 NO /u01/app/oracle/oradata/DB1/pdb/sysaux01.dbf

11 Full 2627500 2025-04-30 06:56:07 NO /u01/app/oracle/oradata/DB1/pdb/undotbs01.dbf

12 Full 2627500 2025-04-30 06:56:07 NO /u01/app/oracle/oradata/DB1/pdb/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

8 Full 481.67M DISK 00:00:10 2025-05-21 12:16:24

BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20250521T121502

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/33E6395D57264163E0630400040A2C41/backupset/2025_05_21/o1_mf_nnndf_TAG20250521T121502_n2vk0g8j_.bkp

List of Datafiles in backup set 8

Container ID: 4, PDB Name: DEMO1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- ------------------- ----------- ------ ----

16 Full 2915005 2025-05-21 10:08:05 NO /u01/app/oracle/oradata/demo1/system01.dbf

17 Full 2915005 2025-05-21 10:08:05 NO /u01/app/oracle/oradata/demo1/sysaux01.dbf

18 Full 2915005 2025-05-21 10:08:05 NO /u01/app/oracle/oradata/demo1/undotbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

9 Full 553.92M DISK 00:00:21 2025-05-21 12:17:00

BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20250521T121502

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/2FAC79D13BBE3BB3E0630400040A98FA/backupset/2025_05_21/o1_mf_nnndf_TAG20250521T121502_n2vk17nv_.bkp

List of Datafiles in backup set 9

Container ID: 2, PDB Name: PDB$SEED

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- ------------------- ----------- ------ ----

5 Full 2137894 2025-03-06 12:44:14 NO /u01/app/oracle/oradata/DB1/pdbseed/system01.dbf

6 Full 2137894 2025-03-06 12:44:14 NO /u01/app/oracle/oradata/DB1/pdbseed/sysaux01.dbf

8 Full 2137894 2025-03-06 12:44:14 NO /u01/app/oracle/oradata/DB1/pdbseed/undotbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

10 Full 17.95M DISK 00:00:02 2025-05-21 12:17:06

BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20250521T121704

Piece Name: /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_21/o1_mf_s_1201695424_n2vk22pc_.bkp

SPFILE Included: Modification time: 2025-05-21 10:55:24

SPFILE db_unique_name: DB1

Control File Included: Ckp SCN: 2923603 Ckp time: 2025-05-21 12:17:04

RMAN>

ANURAG PANDEY

I am Anurag Pandey, working as Cloud Database Architect | Cloud Migration and Modernization Expert .Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible, Audit, Email - anuragkumarjoy@gmail.com

No comments:

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Real World Oracle AI Cloud Database Solutions

Wednesday, May 21, 2025