0 Comments

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle 0 (0)

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle In this article, we are going to demonstrate add & drop standby redolog files on standby (dataguard) in Oracle. Drop or add standby redolog files require in case we resized/recreate redolog in PRIMARY so need to follow same on STANDBY database or some times […]

 43 Total Views,  1 Views Today

0 Comments

Oracle Database 19c RPM Installation On Oracle Linux 7 0 (0)

Oracle Database 19c RPM Installation On Oracle Linux 7 Oracle Database 19c can now be installed on Linux OS using an RPM.This post describes the steps for RPM based installation of Oracle Database 19c 64-bit on OEL 7 64-bit. Step 1. Prerequisite for Installation: Two most important things for rpm based installation is (1) You […]

 80 Total Views,  1 Views Today

0 Comments

Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle 0 (0)

Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle In the previous article, we have configured a Physical STANDBYdatabase where we started MRP in mount state. In this article, we are going to demonstrate Steps to Create Active Physical Standby Dataguard Using RMAN Active Duplicate in Oracle database. Active dataguard features introduced […]

 196 Total Views,  3 Views Today

0 Comments

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle 0 (0)

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and […]

 139 Total Views,  3 Views Today

0 Comments

Step by Step Oracle Database Upgrade from 11g (11.2.0.4) to 12c (12.2.0.1) 5 (2)

Step by Step Oracle Database Upgrade from 11g (11.2.0.4) to 12c (12.2.0.1) using DBUA Here we are going to demonstrate step-by-step Oracle database upgrades from 11.2.0.4 to 12.2.0.1, same steps can be followed to upgrade to 12.1.0.2 as well. List of target upgrade version from supported source version, data source support.oracle.com. Target DB Version Source […]

 255 Total Views

0 Comments

How to Perform a Health Check of an Oracle Database 5 (1)

How to perform Oracle Database health-check In this blog, we’ll be learning about how we can perform Oracle Database health-check. Many times we have seen that we got the request from Application user that their application is slow and they’re asking us to perform health checks on the specified database. We generally perform health checks […]

 284 Total Views,  1 Views Today

Spread the love

0 Comments

Step by Step Drop Database using DBCA in Oracle 0 (0)

Step by Step Drop Database using DBCA in Oracle In this article, we are going to demonstrate Step by Step DROP database using DBCA (GUI) in Oracle. Generally, we do drop the database when application testing completed or not require anymore to business. We can drop the database using the below methods: 1. Manual (Command […]

 266 Total Views,  1 Views Today

2 Comments

Step by Step How to increase SGA size in Oracle 4.3 (3)

Step by Step How to increase SGA size in Oracle I was facing a memory issue in my environment after validating the AWR  and ADDM reports and came to the conclusion that SGA is undersized. Below are both options to increase SGA_MAX_SIZE and SGA_TARGET size using pfile & spfile. in our environment, it’s running using […]

 920 Total Views,  6 Views Today

2 Comments

Step By Step Apply Combo Patch on Primary & Standby (DATAGUARD) Database in Oracle 5 (3)

Combo Patch Apply on Primary & Standby Database in Oracle In this article, we are going to demonstrate step by step apply combo patches on Oracle Primary & Standby (DATAGUARD) which released in January 2021, combo patch contains PSU (31985579) and  OJVM (32119956) patches. Below is the database, system,  patch id, etc. details. COMPONENTS PRIMARY […]

 808 Total Views,  2 Views Today

0 Comments

How to Check PGA information in Oracle 0 (0)

How to Check PGA full information in Oracle.   A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for […]

 119 Total Views,  1 Views Today