I am implementing an automated rman backup procedure for an Oracle database. Say I want to perform a full backup every monday. How do one schedule it? Through dbms_job system or operating system scheduler? Which one is preferred
Assume I am using the following command to backup the database.
backup database format 'c:\rman_backups\%d_%t';
Can someone tell how do I schedule it using windows task scheduler and dbms_job system?
Is there a way to get email notification everytime a backup completes or the log of error when it fails.
I can use "rman cmdfile logfile" to run the commands in cmdfile. But how do I have the contents of logfile emailed to me?
What are the best practices?