Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does Oracle9i Data Guard differ from Oracle8i Data Guard?

April 26, 2017Data differ guard Oracle8i oracle9i

0

Posted

How does Oracle9i Data Guard differ from Oracle8i Data Guard?

1 Answer

0

Posted

Both products provide broadly similar standby database capabilities. Some of the new new capabilities that Oracle9i data Guard provides include the ability to provide a zero data loss failover capability without the need for third party remote data mirroring hardware and software, a new GUI management console integrated into OEM and support for a RAC primary system. Oracle9i Release 2 Data Guard will support a Logical Standby configuration which will enable the standby database to have a different data structure from the primary system by regenerating SQL from the standby log files which is applied to the Logical Standby. Customers will have the ability to modify columns, add additional indexes and materialized views to optimize the standby database for decision support queries.