RMAN - 1) altering date formats in logfile 2) backing up init.ora, password file
I've got 2 questions :
1) Is there a way to change date formats on the RMAN logfile? I'm not talking about the file formats specified in the script..but the date that appears in the logfile itself. Altering my session's nls_date format doesn't do it.
For eg, when I initiate a backup, my logfile looks like the below. Notice the highlighted line. It merely specifies a date. There is no timestamp..I wish to include a timestamp in the log. Any suggestions?
2) How does one backup init.ora (not spfile) and password files in RMAN?
THanks, Anand
RMAN> run { execute script dwdev_incr0; }
executing script: dwdev_incr0
released channel: ORA_DISK_1
allocated channel: t1
channel t1: sid=16 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: t2
channel t2: sid=17 devtype=SBT_TAPE
channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0
Starting backup at 21-APR-04
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00022 name=/u03/oradata/DWDEV/retail_dat1_01.dbf
input datafile fno=00017 name=/u06/oradata/DWDEV/pos_dat2_01.dbf
.....
.....
Re: RMAN - 1) altering date formats in logfile 2) backing up init.ora, password file
Quote:
Originally posted by Axr2
I've got 2 questions :
1) Is there a way to change date formats on the RMAN logfile? I'm not talking about the file formats specified in the script..but the date that appears in the logfile itself. Altering my session's nls_date format doesn't do it.
I don't think you can change that
Quote:
2) How does one backup init.ora (not spfile) and password files in RMAN?
RMAN can't back uo the init file, why are you using it anyway unless you're on 8i
Re: Re: RMAN - 1) altering date formats in logfile 2) backing up init.ora, password file
Quote:
Originally posted by stmontgo
I don't think you can change that
RMAN can't back up the init file, why are you using it anyway unless you're on 8i