RMAN - how to alter date formats in logfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN - how to alter date formats in logfile

Threaded View

  1. #1
    Join Date
    Oct 2002
    Posts
    807

    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
    .....
    .....
    Last edited by Axr2; 04-21-2004 at 04:27 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width