Problem solve
Get help with specific problems with your technologies, process and projects.
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.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments