How Problems with Oracle GoldenGate

Oracle GoldenGate Best Practices 101

comment 0 Comment time 1 day ago

CONTENTSSECTION 1-) GOLDENGATE INSTALLATION • Goldengate Installation• Extract Process• GGSCI commands• Parameter Files• As400 Extract Example• Oracle Extract Example• Pump Example• Replicate Process• GGSCI commands• Parameter files• Replicate Example• Manager Operation• GGSCI commands• Parameter File• Manager Example• Useful commands SECTION 2-) USE OF GOLDENGATE • Goldengate Daily Usage• INFO• STATS• Using Extracta. As400 ExampleI. infoii.

Read More

How to fix Oracle

Recovering Deleted Datafile, Tables in Oracle Database and Understanding “Point In Time Recovery”

comment 0 Comment time 2 months ago

Recovering Deleted Datafile, Tables in Oracle Database and Understanding “Point In Time Recovery” Scenario 1: Loss of a datafile Scenario 2: Loss of all datafiles  Scenario 3: Point-In-Time Recovery Scenario 4: Loss of datafiles, control files, online redo log files and server parameter file  Prerequisites Create a Oracle database with the name PRİMARYDB running in

Read More

longs-to-clob

How to Simply do Oracle Physical Standby Database Using RMAN Backup/Restore and Change DBNAME Using NID Utility

comment 0 Comment time 4 months ago

In the development environment, a quick copy of a database with a different dbname or sid may be required. In such cases, we need to use rman duplicate or standard rman restore method. In this post, we will change the dbname by doing a quick copy. Steps Perform a backup of the primary standby database

Read More

Oracle Streams

Database Replication with Oracle 11G Streams

comment 0 Comment time 4 years ago

Starting from Oracle HA (High Availability) products, Oracle Dataguard, RAC and RMAN are the most commonly used products. Oracle Streams emerges as a replication product, but mainly uses Oracle Logical Standby technology. Oracle Streams generally consists of three different processes called Apply, Propagate and Capture. Apply is the process that runs the LCR records in

Read More

golden-gate-step-by-step

Database Replication with Oracle Goldengate 11G İnstallation Step By Step On Oracle Linux

comment 1 Comment time 4 years ago

Oracle’s GoldenGate is a software solution that enables DML, DDL, DCL and TCL replication of existing data between databases. If you want to explain this sentence briefly, thanks to Oracle GoldenGate, we can transfer and operate the records of the transactions performed on the source database on the target databases we want, in real time

Read More

oracle-block-corruption

Oracle Block Corruption Fix

comment 0 Comment time 3 years ago

This post describes how to repair multiple or single-block corruption of data files, including system data files, in the Oracle database. Block corruption is a common source of database outages. Database block becomes corrupted when its content is different from what the Oracle database expects to find. If block corruption is not prevented or repaired,

Read More

Oracle cluster check

Big DBA as one of the Top 100 Oracle Blogs on the web.

comment 0 Comment time 2 months ago

Today I received an email from Anuj Agarwal, founder of Feedspot .Thank you for your attention. I will try to be worthy.

Read More