Server Pools in Oracle RAC

Before Release of Oracle Clusterware 11g release 2, we define a specific instance belong to specific node.a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster. And it is pretty well with small no of nodes in your RAC database. But when no of nodes […]

Read More

HOW TO CONVERT SCN TO DATE AND DATE INTO SCN

Being DBA, we all are well aware SCN. We all known about it’s important. SCN is the most important element of Oracle Database. It helps DBA in the Recovery Database.       Database SCN number some time is very important 1) Particularly when you are doing rman recovery 2) Filling gaps of archive logs between the primary […]

Read More

Log Shipping in Oracle

In this article we will learn DR creation with log shipping : Prerequisites : Source Database should be in Archive log mode . Enable Archive Log Mode In Oracle RAC Details : Database Name Source DB IP DR DB IP mgr 192.168.1.10 192.168.1.181 Step 1 : To create log shipping DR server force logging and […]

Read More

How to Check/Validate That RMAN Backups Are Good

From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms.     Some of […]

Read More

Patch 27107360 – Oracle Grid Infrastructure PSU 11.2.0.4.180116

Patch Information GI PSUs are cumulative and include the Database PSU and associated CPU program security content. This is Jan 2018 PSU having Patch number 27107360 for 11gR2. OPatch Utility Information You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2 […]

Read More

ORA-01450: maximum key length (3215) exceeded

Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error. While we rebuild the index we face the problem.

Solution: The issue was fixed with rebuilding the […]

Read More

Types of Supplemental logging at Database level

Redo log files are generally used for instance recovery and media recovery. The data needed for such operations is automatically recorded in the redo log files. However, a redo-based application may require that additional column be logged in the redo log files. The process of logging these additional columns is called supplemental logging. There are two […]

Read More

Downgrading Grid Infrastructure from 12.1.0.2 to 11.2.0.4

In the last article, we performed downgrade of Oracle RAC Database from 12c to 11gR2. In this article, we are going to downgrade Oracle Grid Infrastructure from 12c (12.1.0.2) to 11gR2 (11.2.0.4) which contains two nodes ( node 1 & node 2). Before doing CRS downgrade we need to take backup of following files : Take tar […]

Read More

Downgrading a RAC database from 12.1.0.2 to 11.2.0.4

In the last article, we performed downgrade of Oracle Standalone Database from 12c to 11gR2. In this article, we can downgrade the 2 node RAC 12.1.0.2 database to 11.2.0.4, downgraded the database only and not the grid home. Assume all commands are being run on node 1, any commands that need to be run on node 2 […]

Read More

Downgrade Oracle Database from 12c to 11gR2

We have already upgraded Oracle Database11gR2 to 12c, the whole process is still relatively smooth, although some of the previous version of the upgrade is not the same, but the overall difficulty is not too large, because of too many different features, greatly extended the upgrade time. But for Oracle 12c back to the previous […]

Read More