hi, once I used a script which asked both primary and standby comparing arch sequences and gap between them - this way You have always got a context so are able to let's say assume that gap of 1 is ok, while gap of 5 is a error state. Probably it is enough as this check if standby is running and how far behind primary it is, so in general everything one needs (except fs storage consumption) Regards Remigiusz W dniu 20.09.2011 19:51, Uzzell, Stephan pisze: > Hey Listers, > Any cool tricks for monitoring a bunch of physical standby environments? We > have 20 or so physical standby databases, and are having trouble figuring the > best strategy to monitor them. We do not currently have enough DBAs to sit > around watching them. > > We are currently using two scheduled tasks to grab the current_scn from > v$database, alternating every 45 minutes or so; we then parse the two output > files using perl, do some quick math, and as long as there is a change in the > SCN, we feel things are probably OK. > > The problem is that the SCN does not advance at a regular interval. Some > database are busier than others. Some database therefore do not have the SCN > advance between a pair of tests; other times one of the scheduled tasks > hangs. So we get periodic "BAD" reports that are not really bad. > > Definitely not the best system. Any recommendations for the best way to > monitor - to only get alerts if / when there is actually something wrong? > > Thanks! > > Stephan Uzzell > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711-- //www.freelists.org/webpage/oracle-l