Rman Tutorial

Oracle Database Backup & Recovery Using Recovery Manager(RMAN) TUTORIAL

comment 0 Comment time 2 weeks ago

Create a Oracle database with the name PRİMARYDB running in ARCHIVELOG mode. For simplicity the database can be created with all files located under one common area: For example “/opt/oracle/oradata/primarydb/” Archive log files can be located at “/opt/oracle/oradata/primarydb/arch” Use small redo log file sizes (1 megabyte) to simulate redo activity. Before using RMAN, we need

Read More

oracle dataguard

How to use the Oracle Data Guard Switchover Operations

comment 0 Comment time 2 months ago

Dataguard Switchover is a planned role change. In other words, it is the transition of the live database to the standby role and the standby database to the live role. We may be doing Dataguard switchover for testing the functionality of our backup database, doing maintenance work in our live database, etc.Dataguard Switchover operation can

Read More

Oracle Software

Cloning an Oracle Real Application Cluster(RAC) Database Software Home

comment 0 Comment time 2 months ago

In this post we will demonstrate how to create the Oracle RAC Database Software Clone manually, add them to the respective clone.pl script on Oracle Full Rack Exadata Compute Node. Create a tarball of the source home Node1 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl /orcl .tar Node2 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl

Read More

Oracle Streams

Database Replication with Oracle 11G Streams

comment 0 Comment time 1 week 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 1 week 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 4 months 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