Rman date format



Ever get annoyed that rman date formats just show the date and no time element (i know i do). Well it's easily fixed

just run

export NLS_DATE_FORMAT='dd-mon-yyyy hh24:mi:ss';

Then when you start your rman session it's all changed to this format

 rman target=/

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Oct 28 08:39:12 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DB(DBID=1234567)

RMAN> configure device type disk parallelism 4;
backup as copy database format '+DATA';
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

RMAN>

Starting backup at 28-oct-2014 08:39:28
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=477 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=10 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=86 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=160 device type=DISK
channel ORA_DISK_1: starting datafile copy

Some stuff removed here........

Finished backup at 28-oct-2014 08:41:58

Starting Control File and SPFILE Autobackup at 28-oct-2014 08:41:58
piece handle=/oracle/DB/recovery_area/DB/autobackup/2014_10_28/o1_mf_s_862130518_b4yopq2d_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 28-oct-2014 08:42:01

As easy as that - so if you set that in the .profile it will always be set

0 comments:

Post a Comment