Overview - Dataguard Broker Property – Binding One of our primary DB was down due to “ORA-00257: archiver error. Connect internal only, until freed”. As all know most of the time this is due to because of primary DB archive destination 100% full and unable to archive a redo log. Immediately we went and check, but surprisingly our primary archive destination is 95% free, and we had enough space. Unfortunately, Standby Database destination was 100% full. We cleared the space on standby db server and Issue is resolved, everyone able to connect to DB now, I can assume now that whoever reading this blog will thing that standby mode is “MAXIMUM PROTECTION MODE”, due to primary not able to transfer the redo because standby destination was full. But that’s not the case, our standby mode is “Maximum Performance mode”, so technically it should not be the case. Here is the Binding Variable comes into Play, we set to `mandatory` (default value:- optional). Why we set
Yet another blog for dba's. Shared my work experience here. Hope it will be useful for you guys all.