Snapshot Standby Automatization

  • From: "Marcos Colmenares H." <mcolmenares@xxxxxxxxxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 17 Sep 2015 14:35:09 -0430

Good Day,

We are trying to use a standby site as a disposable alternate site but we
need the proccess to be fully automated or with as little interaction as
possible. Has anyone had any experience with this type of setup?

Users need to Read data from a DB which can not be read from at that point,
but the software they use to read does some writes for audit which we will
do without (management had a say) we would be pausing the archivelog apply
for that alternate prior to the primary becoming "un-available" so the
snapshot the users are using is the most recent prior to the process which
stops them from accessing.

Any and all help and ideas will be greatly appreciated!

Best Regards,

Marcos Colmenares H

--

Other related posts: