Rman Backup Script

ls Desktop  oracle_backup.rman  oracle_backup. SH

[[email protected] ~]$ cat Oracle_backup.rman run{configureBACKUPOptimization on; CONFIGURE Controlfile autobackup on; CONFIGURE RETENTION POLICY toRECOVERY WINDOW of 7Days ; CONFIGURE controlfile autobackup FORMAT forDEVICE TYPEDISK  to '/u01/backup/%f'; ALLOCATE CHANNEL CH1 DEVICE TYPEDISKFORMAT'/u01/backup/%u'; ALLOCATE CHANNEL CH2 DEVICE TYPEDISKFORMAT'/u01/backup2/%u';BACKUP DATABASESKIP Inaccessible FilespersetTenPLUS ARCHIVELOG Filesperset - DELETE  AllINPUT; RELEASE CHANNEL CH1; RELEASE CHANNEL CH2;} ALLOCATE CHANNEL forMaintenance DEVICE TYPEDISK; Crosscheck BACKUPSET;DELETENoPrompt OBSOLETE;

[[email protected] ~]$ cat oracle_backup.sh #!/Bin/Bashexport Oracle_sid=OrclexportLog="/U01/$ORACLE _sid+' Date+%Y%M%D%H%M ' "Rman target/Msglog $LogCmdfile="/Home/Oracle/Oracle_backup.rman "

You can then perform a backup execution oracle_backup.sh by scheduling the task periodically.

Rman Backup Script