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

RMAN Full Database Backup Scripts in Oracle 5 (1)

RMAN Full Database Backup Scripts in Oracle. In this article, we are going to prepare a script for RMAN full database backup which includes backup of datafiles, control files, spfile along with archives. This RMAN full database script will create a backup in a specified location (local directory) on the database server. Generally, we do […]

 48 Total Views

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 […]

 140 Total Views,  4 Views Today

0 Comments

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

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, in that case, our STANDBY may become our PRIMARY database. Here, our client requirement, we need to create a STANDBY database using RMAN backup. Below […]

 262 Total Views,  1 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

Identity key store file not found in Weblogic 0 (0)

Identity key store file not found weblogic.nodemanager.common.ConfigException In this post, we are going to demonstrate how to fix the issue of Identity key store file not found weblogic.nodemanager.common.ConfigException. When we tried to start node manager, we encounter the below error. The cause of this issue is because the DemoIdentity.jks is not generated at the time […]

 170 Total Views,  2 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