Evaluation and Prediction in Oracle RAC 12c

In a DBA’s routine, we perform thousands of command every day. Sometimes it also happens we don’t know the post-impact of the command.

Then, Oracle 12c Comes up with very powerful feature WHAT IF EVALUATION.

It shows us the impact of command without actually performing it. So with help of this our life can become easier, first perform an evaluation of command you want to actually apply to your production.

We can use eval and (more...)

Manually Converting Non-RAC DB to RAC DB

In previous articles, we have seen various methods of converting Non-RAC database to RAC database.

In this article, we will convert non-RAC database to RAC database using RMAN backup-restore utility.

Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name
MGR MGR Node 1 db1 RAC1
Node 2 db2 RAC2

Step 1: Check details of Single Instance Database :

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
MGR	       (more...)