Re: High Availability servers

leichivp_at_my-deja.com (Slava) wrote in message news:<a775741a.0201220714.6f2faf27_at_posting.google.com>... meet the poster's requirement of "load balancing".
>
> Hi,
> this is citation from Oracle9i Database Concepts :
> "Logical standby database is a new feature that takes standard Oracle
> archive logs, transforms them back into SQL transactions, and then
> applies them to an open standby database. Because the database is
> open, it is physically different from the primary database. As the
> standby is logically the same as the primary, it can be used to take
> over processing if the primary database is mistakenly harmed by human
> error, a corruption, or a disaster. Because transactions are applied
> using SQL, the standby database can be used concurrently for other
> tasks. Decision support can be optimized by using different indexes
> and materialized views than those on the primary."
>
> Regards,
> Slava.

This is very new to me. It certainly is a major change in 9i.

However, the dataset is completely different than the primary. Sharing does not exist. From this quote, it is not clear if the standby can be opened read and write. Sounds it does. In this case, the change can't be seen by the primary.

So I still think this does not meet the original posting's requirement.

But to load balancing read only activity migh be a realistic application. Received on Tue Jan 22 2002 - 14:35:34 CST