Need to plan rman hot backup 3 node RAC database with ASM , database is in archive log mode.
1. Level 0 backup once in week and level 1 backup for rest of days in a week.
2. Retention policy would be to hold 3 level 0 backups
3. Every 3 hours Archive log backup would be executed and the logs that are backed up over 2 times will get deleted.
Can you please help me out how will we configure rman in such cases. if possible please provide me scripts as well. Backup will be taken in tape.
Follows will be able to help you..