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;

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; ';
}

Comments

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Oracle 10g/11g Linux:SMS the alert logs ORA- errors generated in timestamp

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.