Q

Simplify backup RMAN script

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?

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?
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

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close