Oracle Data Guard Interview Question And Answers

Here are some Oracle Data Guard Interview Question And Answers, hope it will help for you. What is a Dataguard? Oracle Dataguard is a disaster recovery solution from Oracle Corporation that has been utilized in the industry extensively at times of Primary site failure, failover, switchover scenarios. When did Oracle start supporting standby databases? Oracle Database […]

How to start,stop Oracle Goldengate

Below article “How to start,stop Oracle Goldengate” will help you for any planned activity of golden gate. Also I have taken Oracle RAC database as an example, you can change commands if you having standalone database. Oracle GoldenGate, databases and the CRS must be stopped properly on a node reboot for a planned maintenance activity. […]

How to export LOB objects in oracle

Given article “How to export LOB objects in oracle” will help you to reduce maximum amount of time while exporting LOB tables: LOB object does not use parallelism so here we will distribute export and take backup. It will reduce your maximum time Note: This is for export of LOB tables. #!/bin/bash ############################################################################# # EXPORT […]

ORACLE GOLDENGATE ARCHITECTURE

If you wanted to learn some basic concept of Oracle GOLDENGATE  this article “ORACLE GOLDEN GATE ARCHITECTURE” will help you out: Oracle GoldenGate is a tool provided by oracle for transactional data replication among oracle databases and other RDBMS tools (SQL SERVER, DB2. Etc). Its modular architecture gives you the flexibility to easily decouple or […]

Oracle RAC important questions

If you need to know more basic and some higher level things of RAC this article “Oracle RAC important questions” will help you out: What is RAC? RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance failover, media failover features. What […]

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA