I know…
The date format on RMAN it’s not good, but it’s to make it better. Take a look:
db-server>rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Aug 12 11:00:59 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: MYDB (DBID=1286311368) RMAN> list backup of controlfile; using target database control file instead of recovery catalog List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 541 Incr 1 17.80M DISK 00:00:01 12-AUG-15 BP Key: 541 Status: AVAILABLE Compressed: NO Tag: BKPINCR_LV1_20150812_0923 Piece Name: +DGFRA/MYDB/backupset/2015_08_12/ncnnn1_bkpincr_lv1_20150812_0923_0.4613.887534683 Control File Included: Ckp SCN: 7301745 Ckp time: 12-AUG-15 RMAN> exit Recovery Manager complete.
I’ts a simple NLS export on SO before access RMAN:
db-server>export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'; db-server>rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Aug 12 11:05:57 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: MYDB (DBID=1286311368) RMAN> list backup of controlfile; using target database control file instead of recovery catalog List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 541 Incr 1 17.80M DISK 00:00:01 2015/08/12 09:24:42 BP Key: 541 Status: AVAILABLE Compressed: NO Tag: BKPINCR_LV1_20150812_0923 Piece Name: +DGFRA/MYDB/backupset/2015_08_12/ncnnn1_bkpincr_lv1_20150812_0923_0.4613.887534683 Control File Included: Ckp SCN: 7301745 Ckp time: 2015/08/12 09:24:41
Matheus.
