DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Threaded View

  1. #1
    Join Date
    Oct 2002

    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

    allocated channel: t2
    channel t2: sid=17 devtype=SBT_TAPE
    channel t2: Tivoli Data Protection for Oracle: version

    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 03: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

By using this site, you agree to the Privacy Policy