Format strings in RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Format strings in RMAN

  1. #1
    Join Date
    Jun 2001
    Posts
    3

    Exclamation

    I am writing a RMAN script to accomplish a backup to disk. I intend to backup the database and then backup and delete the archive log files. The following are the lines in question from the script:

    allocate channel CH1 type disk format='/opt/oracle/backup';
    ....
    backup database
    filesperset = 1
    tag = 'Test of Disk based Backup - Datafiles'
    format = '%d_%U';
    sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    backup
    filesperset = 1
    tag = 'Test of Disk based Backup - Archive logs';
    format 'Ha_%t_%s.log'
    archivelog all delete input;
    ....
    ....
    release channel CH1;

    Can I use the 2 format statements in the same script? The format in the allocate channel string is to set the directory location for the files. When I get to the part to backup the database or the archivelogs, I need to know if that format string will be appended to the other format sting, totally replace it, etc?? I would like to do both in the same script and I can do it without the format string for the archive logs but I would rather the formats work "together".

    Is it possible?

    Thanks,
    Mark

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You can do that.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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