Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases. Let’s […]
Category: ORACLE DATABASE
Flashback in Oracle
We are going to have look at another part of the Oracle database. Flashback is going to be the topic of our discussion of today. Let’s start with its introduction after that with its example. Being DBA we have to make us familiar with Flashback technology. It is considered as a good feature of Oracle Database. What is […]
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 […]
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 […]
kfed script for ASM disk troubleshooting
Today we are going to learn about the kfed “script for ASM disk troubleshooting” As per our new DBA in the journey of Database we are normally known about troubleshooting regards errors, Now we are going to learn about disk troubleshooting. Few lines of this post explain the definition. The kfed is an undocumented ASM utility that is […]
Archivelog in Oracle Database
Today we are going to learn about the most important element of Oracle Database which come’s much important after it’s backbone.Being Oracle DBA we must aware of Archive logs.Now we are going to have look at the technical definition of archive log. An archived redo log file is a copy of one of the filled members of a […]
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 […]
Purging AUDIT TRAIL RECORDS -AUD$ Table
Today we are going to have look at the database security’s phase. In this phase, we are going to have look at Purging AUDIT TRAIL RECORDS The parameterAUDIT_TRAIL_TYPE is specified using one of three constants. DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD: Standard audit trail (AUD$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD: Fine-grained audit trail (FGA_LOG$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD: Both standard and fine-grained audit trails. If you want […]
Facts about Instance
Today we are going to have look at some more interesting facts about “Oracle Technology”. This post about is the “ASM Instance and Database Instance”. Being an Oracle DBA our Oracle journey starts with Database Instance. As we go into the deep knowledge of Oracle we get new terms of Oracle technology. We are going to learn about ASM instance and […]