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
Comments
Post a Comment