Switchover from dataguard primary to standby
Last week, we initiated a planned switchover of our primary and standby dataguard instances. 11.2.0.3, physical standby. Dead easy. The database change went absolutely perfectly. No problems. Brilliant. A 5 step process and everything did as the Oracle docs said they should. The problem... the problem was everything else. Some background: The company has been using active data guard to populate a read-only standby for about 9 months, and since it was installed have never done a switchover (or a failover). Almost all client jobs are cron- & script-based (running on the DB host), or run manually. A week before the switch, I'd gone through a list of apps with a senior developer and checked that they all referenced a DNS name rather than an IP address. That's a relatively short list of about 10 apps of various types and sizes. Come the switch, most things went as smoothly as you'd hope! The vast majority of the Tomcat apps switch...