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
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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