..read more

http://www.dbapath.com/wp-content/uploads/2021/07/11-07-P1-Cloning.mp4 protected   ..read more

Oracle Database Administration  – Complete guide Topics Duration in Days Duration in Hours Topic Introduction Day 1 1 Hour PART 1 How does a computer work? Day 1 Real time environment, Cloud vs Onprem, Teams involved Day 1 Difference between OLTP and OLAP Day 2 1 Hour People facing roles(L1,L2 and L3) Day 2 Incident, Change and Problem Management Day 2 Responsibilities of a DBA (Only one or broader perspective) Day 2 ACID Properties Day 2 Exploring Oracle Database Architecture Day 3 – Day 6 5 Hours List the major architectural components of Oracle Databas ..read more

Hello Geeks, I have been a part of quite a few WhatsApp and Social platforms like Facebook and Twitter and have seen people asking many doubts. Keeping this in mind, I have created this forum and here is how you can make the most use of it. How to work with the forum page in dbapath After choosing the forum from the menu bar, here are the tips that you need to follow. 1.Navigation or Page Overview 2. How to Ask a question 3. Search for submitted questions and answers. 4. Answer the question or comment on the question 5. Understanding the submitted answer and voting for the best. Still, co ..read more

General Background Processes. Acronym Process Name Description SMON System Monitor Process Performs recovery after instance failure and monitors temporary segments and extents. PMON Process Monitor Recovers failed process resources. If Shared Server architecture is used, PMON monitors and restarts any failed dispatcher or server processes. LGWR Log Writer Process Writes the log buffer out to the redo logs. DBWn Database Writer Process Writes dirty buffers from the buffer cache to the data files. Possible processes include DBW0–DBW9 and DBWa–DBWz CKPT Checkpoint Process Writes checkpoint infor ..read more

In this post we are going to learn Oracle RAC interview questions, This post will be updated constantly, so please do check this post often. Explain the steps involved in RAC Software and Database creation? Install the same version of operating system in all the nodes. Create required no.of groups and oracle user accounts. Create required directory structure for CRS_HOME and DB_HOME configure kernel parameters as per installation document. Set shell limits for oracle user account. Edit /etc/hosts and specify public IP, private IP and virtual Ips. Configure ssh for user equivalence and trust re ..read more

Important Oracle DBA interview questions 1. Explain the steps involved in executing a data manipulation language (DML) statements? The server process receives the statement and checks the library cache for any shared SQL area that contains a similar SQL statement. If a shared SQL area is found, the server process checks the user’s access privileges for the requested data, and the existing shared SQL area is used to process the statement. If not, a new shared SQL area is allocated for the statement, so that it can be parsed and processed. If the data and undo segment blocks are not already in t ..read more

We got the below error in one of our physical standby databases today. ORA-10567: Redo is inconsistent with data block [adrotate banner=”1″] Problem Description : ORA-00600: internal error code, arguments: [3020], [4], [2], [16777218], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 4, block# 2, file offset is 16384 bytes) ORA-10564: tablespace USERS ORA-01110: data file 4: ‘/u02/PRMRY/users01.dbf’ ORA-10560: block type ‘KTFB Bitmapped File Space Header’ Errors in file /u02/app/oracle/diag/rdbms/stdby/STDBY/trace/STDBY_mrp0_4026.trc (incident=16285 ..read more

What are the components of the physical database structure of Oracle database? Three fundamental types of physical files make up an Oracle database: Control files. Datafiles. Redo log files. What are the components of the logical database structure of Oracle database? The logical structure of Oracle database consists of tablespaces and schema objects. What is a tablespace? An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database’s data. What is SYSTEM tablespace and when is it created? Every Oracle database contains a t ..read more

Step 1: Use this below command to find the SCN difference, on both the database – Standby DB SQL> select to_char(current_scn) from v$database; TO_CHAR(CURRENT_SCN) —————————————- 20604456588 Step 2 : Stop the managed standby apply process: SQL> alter database recover managed standby database cancel; Step 3: Now Shutdown the standby database SQL> shut immediate Step 4: On the primary, take an incremental backup from the SCN number where the standby has been stuck: RMAN> run { allocate channel c1 type disk format ‘/u01/vahini_bkp/%U.bkp’; backup incremental from scn 20604456588 d ..read more