lamp2lapo

My previous article on implementing incremental RMAN backups on XE had some problems:

• I failed to set a recovery window so that RMAN could accurately determine which backups were okay to delete
• I referred to my tag as whole_db_cpy in my copy and whole_db_copy in my incremental backup

This combination led to a very small database taking up 8 Gigabytes of backup space. I could verify the backups and the data was all there but I wasn’t using my space as efficiently as I could have.  By setting the recovery window to seven days, RMAN will ensure that I retain the appropriate backups to restore data within that window.  Since this script runs once a day, this should equate to at most one full backup and 8 incremental backups.
I have updated the article so that it is now correct. Please let me know if you find anything else that is wrong with the article!