Good Morning/Afternoon/Evening
Environment:
Oracle 11.2.0.3 EE on Solaris
This Production database is operating with a Physical Standby on a remote server with an ASYNC update method using real-apply.
I have been trying to tweak my archivelog backup/retention process to keep two (2) copies of the archived logs on the Primary (Production) server.
Somehow I have managed to start generating the RMAN-08591 message where before it was not appearing. I 'believe' I have put the RMAN parameter files back to what they were before the error began but I can't be 100% certain and I don't think it's relevant to my question anyway.
I have read about setting at least one of my destinations to 'MANDATORY' but I have also read where that's not recommended due to potential of stopping the Primary database if there were an issue transporting the archived log files.
I've also read about the "_log_deletion_policy='ALL' " hidden parameter but hesitate to include that without more specific feedback from Oracle Support.
So, my question is: How do I set up my RMAN parameters and possibly any database parameters to allow me to capture two (2) copies of my archived logs before they are deleted by RMAN?
Here is the RMAN archivelog deletion policy from a 'show all;:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
Here is my RMAN parameter file when doing both my weekly Level 0 and my daily Level 1 cumulative backups:
backup incremental level 1 cumulative database plus archivelog tag 'Incr_db';
backup archivelog all not backed up 2 times tag 'Incr_arch';
delete noprompt obsolete;
I realize I am requesting a backup of the archivelogs twice but that was the initial way I thought of to get two (2) copies of the log files before they were deleted via the RMAN Policy.
Thanks very much for any insight!!
-gary