DATABASE

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

March 23, 2021

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…

Loading

📌
0💬 read more

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

March 13, 2021

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….

Loading

📌
1💬 read more

Step by Step Physical Standby Database Creation in Oracle 5 (3)

March 12, 2021

Step by Step Physical Standby Database Creation in Oracle Data Guard is used for disaster recovery and high availability. Due to any disaster, if our PRIMARY database got crash so,…

Loading

📌
0💬 read more

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

March 7, 2021

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 11g (11.2.0.4) to 12c (12.2.0.1),…

Loading

📌
2💬 read more

How to Perform a Health Check of an Oracle Database 4.9 (7)

March 1, 2021

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…

Loading

📌
0💬 read more

Step by Step Drop Database using DBCA in Oracle 5 (1)

February 18, 2021

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…

Loading

📌
0💬 read more

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

February 14, 2021

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…

Loading

📌
2💬 read more

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

February 12, 2021

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)…

Loading

📌
6💬 read more

How to Check PGA information in Oracle 0 (0)

February 9, 2021

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…

Loading

📌
0💬 read more

How to Check Long Running Job in the Oracle Database 4.5 (2)

February 4, 2021

How to Check Long Running Job in the Oracle Database Sometimes in the database, few queries are taking a long time to complete the query, to validate which query taking…

Loading

📌
0💬 read more