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 […]
Monthly Archives: May 2018
Basic of Data Pump in Oracle
This post is going to explain about the Oracle Data Pump. We may find n number of articles on Google regards, Oracle DataPump. Let’s add one more. Being Oracle DBA we must explore Oracle RDBMS as much as possible to be veteran in our field. Normal water become Lemonade after adding lemon as we can see the […]
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 […]
Schedule rman backup in windows
We are going to learn about the steps which we will use for schedule rman backup in windows. Most probably Organisations use Linux and Unix OS as per there requirements but sometimes as per company’s requirements, we have to use windows. Here we are going to have look at the process of schedule rman backup in windows. Let’s have look at it. […]
Undo Segment is in Needs Recovery
Whenever we face any DBA interviews we have to go through some intersting topics interviewers ask. Undo Management is the most important part of DBA’s job responsibilities. This article will help you out to solve the issue when “Undo Segment is in Needs Recovery or Undo Segments are corrupted” The database is shutdown and can’t […]
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 […]