How to schedule RMAN hot backup for physical standby database setup
Team,
I am having 2 sites where in 1st server primary database is running and in 2nd server physical standby database is running. I would like to check with you whether I should be scheduling the RMAN hot backup on both database?
right now, I am running a RMAN backup in primary server,in case if the database is failed over, is there any automated way to hedule a backup from secondary server? or should I be scheduling the RMAN backup via cron jobs in both servers?
Also would like to know I am scheduling the RMAN hot backup from primary site which is takeing a backup including archive log files and then delete the archived files, however the archived files are not getting deleted from secondary site.Is there any parameter to be amended to delete the archived log from both primary and secondary databases post successful backup.