Brian, I would like to simplify my RMAN script to have a generic one. I need to pass a parameter to the RMAN script (in this case it is a SID for a FORMAT string of the backup statement). Can it be done?

    Requires Free Membership to View

    Login

When you allocate a channel, you can specify the FORMAT of the file names. Alternatively, you can specify the FORMAT in the BACKUP command. In either case, the string "%d" includes the database name in the file format. So a FORMAT clause may look like the following: 
FORMAT 'full_backup_%d_%Y%M%D_%U'
Notice that I included other format strings as well. You can find all of the format strings in this document.

This was first published in April 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top