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.
Thanks in advance.
Follows will be able to help you..
If you haven't used RMAN before (which seems to be the case), get hold of a good book on RMAN and/or read the standard documentation on RMAN
User's Guide : http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm
Reference : http://docs.oracle.com/cd/E11882_01/backup.112/e10643/toc.htm
RAC Deployment Guide Chapter on Backup and Recovery : http://docs.oracle.com/cd/E11882_01/rac.112/e16795/backup.htm#i443637
Hemant K Chitale