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

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: