12c Database Installation on RHEL 6.6

12c Database installation is quite simple. There are several pre-requisites which should be taken care before starting the installation. Once the pre-requisite have been satisfied you can proceed with below steps.

Step 1 :   Untick the check box and click on “Next”

Read More »

DGMGRL Setup for RAC to Non-RAC

Data Guard Broker helps to automate many of the tasks like switch-over , fail-over etc.

I would like to demonstrate configuration of oracle data guard broker and would like to show how easy to switch-over between primary and standby databases with single line command.

In below example, I have primary database on cluster environment 2 Node RAC and standby database is non-cluster environment. Moreover, Primary database on ASM storage whereas standby database is on file-system.

Read More »

OnlineTable Migration


Online Table Migration using GoldenGate


I would like to demonstrate a case study of table partitioning and “online migration” in a OLTP system with “near Zero Downtime”.

In such cases, GoldenGate is the best tool to achieve this goal of an on-line migration.

1)  Find out dependant objects.

Read More »

RMAN backup jobs through DBMS_SCHEDULER

It is very easy to create the RMAN backup jobs through DBMS_SCHEDULER.

Benefits of using DBMS_SCHEDLER for RMAN jobs:

  • For multinode RAC configuration, executing the RMAN jobs through OS cronjobs will fail when the node is not available. While using DBMS_SCHEDULER , the job can be run from serviving instance.
  • It is easy to maintain the logs at OS level as well as in the database dictionary.
  • By default execution of the job can be fixed for specific instance using service and can be changed at any time.

Read More »