Learned an interesting one today. I noticed that the nightly stats job was not running on any of our data guard logical standbys. It would not run despite running a complete remove/reset the scheduled maintenance window, resetting the parameters for the job, etc. A fellow DBA tipped me off to this issue which applies to [...]
Posts Tagged ‘standby’
10.2.04 Data guard logical standbys and dbms_scheduler
Posted in Dataguard, Statistics, tagged Dataguard, dbms_scheduler, logical, standby, statistics on August 4, 2010 | Leave a Comment »
ORA-01309: invalid session in dataguard logical standby
Posted in Dataguard, tagged Dataguard, invalid, invalid session, logical, logical standby, ORA-01309, session, standby on February 3, 2010 | 5 Comments »
We ran across a fun one today with dataguard and a logical standby. Second time we have seen it with the same fix. After making changes such as moving redo logs around or increasing TEMP (with log apply off) the redo/arch transport will correctly start and begin shipping data from the primary to the logical [...]
