السلام عليكم


اريد ان اقوم بعمل replication بين قاعدتين بيانات, بحيث ان احدهما فقط تستقبل عن الاخرى, يعني وواحدةرئيسية والاخرى تتغير بتغير الاولى.

هل هذا الحل متاح في اوراكل؟

السلام عليكم
راجع هذا الرابط:

http://www.araboug.org/ib/index.php?showtopic=27690

you can use oracle data guard



Introduction to Oracle Data Guard

Oracle Ddatabases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database. Then, if the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.
With Data Guard, administrators can optionally improve production database performance by offloading resource-intensive backup and reporting operations to standby systems.
This chapter includes the following topics that describe the highlights of Oracle Data Guard:

• Data Guard Configurations
• Data Guard Services
• Data Guard Broker
• Data Guard Protection Modes
• Data Guard and Complementary Technologies
• Summary of Data Guard Benefits
  

ata Guard configuration consists of one production database and one or more standby databases. The databases in a Data Guard configuration are connected by communicate with each other. For example, you can have a standby database on the same system as the production database, along with two standby databases on other systems at remote locations.
You can manage primary and standby databases using the SQL command-line interfaces or the Data Guard broker interfaces, including a command-line interface (DGMGRL) and a graphical user interface that is integrated in Oracle Enterprise Manager.
Primary Database

A Data Guard configuration contains one production database, also referred to as the primary database, that functions in the primary role. This is the database that is accessed by most of your applications.
The primary database can be either a single-instance Oracle database or an Oracle R

1.1.2 Standby Databases

A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to nine standby databases and incorporate them in a Data Guard configuration. Once created, Data Guard automatically maintains each standby database by transmitting redo to the standby database.
Similar to a primary database, a standby database can be either a single-instance Oracle database or an Oracle Physical standby database
Provides a physically identical copy of the primary database, with Logical standby database
Contains the same logical information as the production database, although the physical organization and structure of the data can be different. The logical standby database is kept synchronized with the primary database though SQL Apply, which transforms the data in the redo received from the primary database into SQL statements and then executing the SQL statements on the standby database.
A logical standby database can be used for other business purposes in addition to disaster recovery requirements. This allows users to access a logical standby database for queries and
1.1.3 Configuration Example

Figure 1-1 shows a typical Data Guard configuration that contains a primary database that transmits redo data to a standby database. The standby database is remotely located from the primary database for Figure 1-1 shows a tstandby redo log files to a standby database.

Description of "Figure 1-1 Typical Data Guard Configuration"

تم تعديل 15 فبراير 201214 سنة بواسطة abdo_m_mohamed