How to drop a two-node Oracle RAC database database manually. In this article, we wrote an Clear steps for dropping a two node oracle database with Pre-requisite steps. Server: sewnpossqa01/02 Database : npossqa1 DB Unique name: sewnpossqa1 Step 1: Take consistent export of NPOSSQA1 database… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Architecture. SNO Article Name Article Link 1 Startup and Shutdown modes in Oracle https://www.ktexperts.com/startup-and-shutdown-modes-in-oracle/ 2 ORACLE ARCHITECTURE -4(PHYSICAL REPRESENTATION OF DATABASE) https://www.ktexperts.com/oracle-architecture-4physical-representation-of-database/ 3 ORACLE OPTIONAL BACKGROUND PROCESSES https://www.ktexperts.com/oracle-optional-background-processes/ 4 ORACLE ARCHITECTURE -2… Read More
Startup and Shutdown modes in Oracle In this article we will discuss different STARTUP and SHUTDOWN MODES. Startup Modes : Startup nomount Startup mount Open Startup restrict Startup force Startup suspend Before reading article please check below image Startup Nomount : Oracle open… Read More
ORACLE ARCHITECTURE -4(PHYSICAL REPRESENTATION OF DATABASE ) In this article we will cover Physical representation of Database. Physical representation is nothing but Physical files(CRD). From Oracle version 6 to 12c every database has three files. They are : 1.Controlfile 2.Redolog files 3.Datafiles Please check below to… Read More
ORACLE OPTIONAL BACKGROUND PROCESSES Optional Background Processes Archiver Process Name: ARC0 through ARC9 Max Processes: 10 The ARCn process is responsible for writing the online redo log files to the mentioned archive log destination after a log switch has occurred. ARCn is present only if… Read More
ORACLE SERVER ARCHITECTURE What is Oracle Sever ? Oracle Server is a combination of Instance and database . What is an Oracle instance ? Instance is a gateway in-order to access the database. Without instance we can’t access database and its objects . Every database… Read More
ORACLE ARCHITECTURE -1 What is DATABASE ? A database is an organized collection of data, generally stored and accessed electronically from a computer system. As a database administrator we can say one more definition A Database is a collection of Logical level and Physical level In Logical level… Read More
REDOLOG FILE MANAGEMENT Redolog files are used to store latest transactional information which are used for recovery purpose incase of any instance failure. These are mandatory files for the database. The latest transactional data will send to redolog buffers then it will send… Read More
Oracle Server Architecture An Oracle server includes an Oracle Instance and an Oracle database. Oracle instance: An Oracle Instance is a combination of two different sets of components. The first component includes the Memory components. That is nothing but SGA (shared global area or system global area) The second… Read More
Steps for Update Statement Process in SGA: update processes >update emp set sal=5000 where empno=7903; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3… Read More
