Introduction:- Being a core Oracle DBA we have deep knowledge of Oracle Database Architecture. In any architecture, we go through the proper function. After having a good knowledge of database architecture we must work beyond of it. In this article, we are going o have a tour of Oracle Application R12c architecture. This architecture is totally different from […]
All posts by Anuradha Mudgal
Creation of Physical Standby in Oracle One Node
Introduction:- Data plays an important role in business operations on a day to day life. Without data, we can not perform our business operations. Data helps to generate business reports, With the help of data, all kind of business’s departments( Hr, Top management, Technical Departments, Accounts Departments etc.) can achieve their goals on time. Loss of data […]
Installing Oracle Statspack
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about Oracle Statspack. We are going to learn what is Oracle Statspack? how does it work, why do we need of Oracle Statspack? Statspack is a performance tuning tool provided by Oracle with the Oracle9i database distribution. […]
Monitoring changes to Oracle tables
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The main purpose of this type of monitoring, in my opinion, is to know the most altered tables, the amount of changes in these tables since the last collection of statistics. Why since the last collection of statistics? Because every time a […]
Procedure for authorizing and disallowing users in Oracle Database Vault Realm
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – In this article, we have look at the document the procedure required to authorize a user as a participant in the Oracle Database Vault Realm and then disallow it. All this procedure is possible through Enterprise Manager, but as it is […]
Rebuilding / Moving MGMTDB on Grid Infrastructure 12c
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this article, we are going to know about how to rebuilding/moving MGMTDB on grid infrastructure 12c. Stop the ora.crf resource on each node in your cluster and disable it so that it does not start automatically: [root@rac1 ~]# crsctl […]
Deleting diskgroup via asmcmd
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to show that via asmcmd it is also possible to remove a disk group. Let’s briefly see how to do this. We list the disk groups: [oracle@london1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block […]
Difference between Oracle DBA and Oracle Apps DBA
Normally people start their journey from a software engineer in Information Technology. We all are aware of few fields of IT like testing engineer, data analyst, software engineer, web designer, coder etc. But in information-technology, we have an ocean of different kind of professions. In IT sectors administration plays an important role in business. without an administrator, IT projects can not […]
Introduction to Oracle AWR
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Today let’s talk a little about a fantastic feature we have in Oracle Database that helps us in performance analysis: the AWR. What is AWR? AWR stands for Automatic Workload Repository, ie it is a repository of information about the […]
Amount of redo generated during user-managed backup
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – In this article, we have a quick journey on redo log during user-managed backup. RMAN is the most recommended tool for performing backup and recovery of an Oracle database, but we know that this is not always the case and many […]