When using RMAN catalog it is preferred to use backup script stored in catalog. It is best if scripts can be reused for different retention.<\/p>\n\n\n\n
You can use variables in RMAN script this way:<\/p>\n\n\n\n
create global script global_backup_full_database \ncomment 'backup full of database. Parameter sysdate+n,tag db, tag archivelog'\n{\nallocate channel c1 type SBT_TAPE PARMS 'BLKSIZE=1048576,SBT_LIBRARY=\/usr\/lib\/ddbda\/libddboostora.so, ENV=(CONFIG_FILE=\/opt\/ddbda\/config\/oracle_ddbda.cfg)' FORMAT '%d_%U';\nbackup as backupset database filesperset 1 keep until time '&1' tag &2;\nbackup as backupset archivelog all delete input filesperset=1 keep until time '&1' tag &3;\n}\n<\/pre>\n\n\n\n\n\n\n\nYou can then call the script from rman this way:<\/p>\n\n\n\n
\nRUN\n{ \n EXECUTE SCRIPT global_backup_full_database \n USING 'sysdate+15'\n backup_daily_db\n backup_daily_arch;\n} \n<\/pre>\n","protected":false},"excerpt":{"rendered":"When using RMAN catalog it is preferred to use backup script stored in catalog. It is best if scripts can be reused for different retention. You can use variables in RMAN script this way: create global script global_backup_full_database comment ‘backup full of database. Parameter sysdate+n,tag db, tag archivelog’ { allocate channel c1 type SBT_TAPE PARMS … <\/p>\n