We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article we will see RMAN duplicate target database for standby using active database command to prepare auxiliary database. Note: For this process, we need to copy password file from primary side to standby side under $ORACLE_HOME/dbs Database Detail […]
Articles Tagged: Oracle
Oracle Net Configuration for Data Guard
In Previous article we have seen Primary Database Preparation for Data Guard Configuration. Setting the parameter on primary database for physical standby database. In this article we will see Oracle Net Configuration on Primary and Standby. Step 1 : Configure tnsnames.ora file at Production. [oracle@test1 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # […]
Setting the parameter on primary database for physical standby database.
In the previous article, we have seen basics about the Architecture of Oracle Dataguard. Oracle Dataguard Architecture We can configure DataGuard with main three stages. Preparing Primary Database. Setting up net services between primary and standby database. Creating Standby Database. In this article, we will set the parameters on the primary database. We will see […]
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 […]
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 […]
Redolog in Oracle
As DBA we are aware that Oracle is a mixture of CRD files. Now we are going to have look at Redolog. Let’s have a technical definition of Redolog. The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as […]
Controlfile in Oracle Database
Today we are going to have look at the most important element of the Oracle Databases.Being Oracle DBA we must have good knowledge about Controlfile. It plays an important role in Oracle Database. If something happens wrong with it we are not able to start our database. Let’s have some important knowledge about Controlfile. Whenever we […]
Control file recovery
Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the most important element of our database. Let’s have a look at the steps which are required for the recovery of controlfile. Instance terminates on startup with ORA-00600: internal […]
Tip and Tricks to pass OCM exam
I wrote an exam on 9th and 10th Apr in India, After 17 long days, the result was out. Now officially I’ve successfully passed 11G OCM, Oracle Database 11g Certified Master Exam. It was almost more than 15 months that I’ve been preparing for this exam but actual preparation started almost 6 years back when I […]
Spfile and Pfile in Oracle
Today we are going to have look on the topic of “PFile and SPFile”. This is the most important element of the Oracle database. Being Oracle DBA we must aware about “PFile and SPFile”. This file plays an important role in Oracle database. Let’s have look at the technical definition of “PFile and SPFile”. It will be […]