Converting a Snapshot Standby DB to Physical Standby

Converting a Snapshot Standby database into a Physical Standby Database. Step 1 verify open mode of database (it should be in read write) SQL>select open_mode from v$database; SQL> conn sys/oracle@standby

Converting physical standby DB to snapshot standby

Managing Snapshot standby database in Oracle. In this article we will see step by step procedure to convert physical standby database to snapshot standby database. At Standby database Step 1.

Oracle GoldenGate Scenario: Cascading replication

Cascading replication by using Oracle GoldenGate. 1. Scenario: 1.1.    Creating a Cascading Reporting Configuration Oracle GoldenGate supports cascading synchronization, where Oracle GoldenGate propagates data changes from the source database to

Errors and Solutions in Oracle GoldenGate Setup

Errors and Solutions in Oracle GoldenGate Setup. Errors and solution    1.ERROR: GGSCI (ol6-GG-sys1.localdomain) 3> start extract DPUMP_NR Sending START request to MANAGER … ERROR: opening port for MGR MGR

Oracle GoldenGate Bidirectional Replication Setup

Oracle GoldenGate Bidirectional Replication Setup. 1. Scenario 2: Bidirectional replication Summary of the software / configuration items would be as given in below table. SNo Software/Configuration Item Value @ Site

Intial Load in Oracle GoldenGate.

Intial Load in Oracle GoldenGate. 1.        Initial load performing initial data load ============================================================== This example illustrates using the GoldenGate direct load method to extract records from an Oracle 11g database.

Oracle GoldenGate Uni-Directional replication setup

Configure Step by step Oracle GoldenGate Unidirectional Method.   Scenario 1: Uni-Directional replication setup Sno Config item Site1 Site2 1 GoldenGate software location /u01/app/oracle/ product/ogg1 /u01/app/oracle/ product/ogg2 3 GoldenGate database

Editions in Oracle Database VS MYSQL Database

Software Editions in Oracle Database VS MYSQL Database.   Editions of Database Server: The following is a list of Oracle database editions in order of priority: Enterprise Edition: It is the

Quiz Questions for Oracle GoldenGate

Quiz Questions for Oracle GoldenGate.   1.Which statements are true about Oracle GoldenGate? (Select more than one.) Oracle Golden Gate is an Oracle Database product that supports other Oracle products.