Oracle DataGuard supports logical and physical standby databases. Logical Standby: When primary database generates any redo entries it is transferred to standby database and then redo data are converted into SQL statements and then those SQL statements are applied to standby database. To read more about Physical Standby Database Physical Standby Database: Redo Apply Architecture […]
All posts by Jagruti Jasleniya
Jagruti Jasleniya
Benefits of using Dataguard
In the previous article, we have seen basics about the architecture of Oracle Dataguard. Oracle Dataguard Architecture The main benefit of any DR server is we can say to protect Production Server’s critical data from any natural and unnatural disasters. We keep our Production Server in one place while our DR server can set up […]
Physical Standby Database: Redo Apply Architecture
In the previous article, we have seen basics about the architecture of Oracle Dataguard. Oracle Dataguard Architecture Oracle Data Guard works on physical standby and logical standby sites. Physical Standby: When primary database generates redo entries, those redo are transferred to standby database and then redo is applied to standby database. Logical Standby: When primary […]
Protection modes in Oracle Dataguard
In previous article we have gone through architecture of Oracle Dataguard and redo apply and sql apply architecture. A main role of any DR server is to protect Production Server’s critical data from any natural and unnatural disasters. Oracle Data Guard have different flavors to provide protection to Production’s critical data. That we can see […]
Evaluation and Prediction in Oracle RAC 12c
In a DBA’s routine, we perform thousands of command every day. Sometimes it also happens we don’t know the post-impact of the command. Then, Oracle 12c Comes up with very powerful feature WHAT IF EVALUATION. It shows us the impact of command without actually performing it. So with help of this our life can become […]
Manually Converting Non-RAC DB to RAC DB
In previous articles, we have seen various methods of converting Non-RAC database to RAC database. In this article, we will convert non-RAC database to RAC database using RMAN backup-restore utility. Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name MGR MGR Node 1 db1 RAC1 Node 2 db2 […]
Server Pools in Oracle RAC
Before Release of Oracle Clusterware 11g release 2, we define a specific instance belong to specific node.a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster. And it is pretty well with small no of nodes in your RAC database. But when no of nodes […]
Creating RAC database With PDBS
In this Article we will Create RAC Database with PDBS using DBCA. Step 1 : Once you use dbca , first screen that will open is as below select Create Database and click next: Step 2 : Select Advanced Mode and click Next Step 3 : Select RAC database as database type and Admin Managed […]
Oracle Dataguard Architecture
In previous article , we have seen basics about Oracle Dataguard ORACLE DATAGUARD. In this article we will see oracle dataguard architecture in depth. Let us understand above diagram with example. Let us assume our primary database is in Delhi, India and standby database is in Bangalore , India. When we have just primary database […]
Plug Single Instance PDB to RAC CDB
In this article we will Plug Single Instance PDB to RAC CDB. Single Instance CDB Name Single Instance PDB Name RAC Instance CDB RAC Instance Name RAC Node globdb pdb1 CDB1 RAC1 Node1 RAC2 Node2 Step 1 : Check status of Globdb and CDB1 [oracle@rac2 ~]$ srvctl status database -d globdb Instance globdb is running […]