Oracle 10g:Get RMAN Backup Completion Mail
Follow this steps to get rman backup completion mail.
1.Create Procedure to for mail.
CREATE OR REPLACE PROCEDURE usp_rman_backup_info
as
Begin
UTL_MAIL.SEND(sender=>'DatabaseExperts@de.com', recipients=>'Comma separated email list',subject=>'DatabaseName RMAN Backup info', message => 'RMAN Backup completed @'||to_char(sysdate,'hh24:mi:ss'));
end;
as
Begin
UTL_MAIL.SEND(sender=>'DatabaseExperts@de.com', recipients=>'Comma separated email list',subject=>'DatabaseName RMAN Backup info', message => 'RMAN Backup completed @'||to_char(sysdate,'hh24:mi:ss'));
end;
2.Update RMAN Script.
SQL ' BEGIN SYS.usp_rman_backup_info; END; '; at end of script.
delete noprompt obsolete;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
SQL ' BEGIN SYS.usp_rman_backup_info; END; ';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
SQL ' BEGIN SYS.usp_rman_backup_info; END; ';
}
Comments
Post a Comment
Dear User,
Thank you very much for your kind response