
dbapath
150 FOLLOWERS
The idea of dbapath.com is to provide technical information on various database administration tasks which include Oracle 11g, 12c, Rac, and Data Guard.The content is organized in such a way that the topics are segregated under the various categories like Oracle 11g, Oracle 12c, ORA-Errors, interview questions etc.
dbapath
3y ago
http://www.dbapath.com/wp-content/uploads/2021/07/11-07-P1-Cloning.mp4
protected
  ..read more
dbapath
4y ago
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
dbapath
5y ago
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
dbapath
5y ago
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
dbapath
5y ago
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
dbapath
5y ago
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
dbapath
5y ago
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
dbapath
5y ago
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
dbapath
5y ago
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