Enable Dataguard Broker and Configuring its component DGMGRL

Data Guard Configurations and Broker Configurations:

A Data Guard configuration consists of one primary database and up to nine standby databases. The databases in a Data Guard configuration are connected by Oracle Net and may be dispersed geographically. There are no restrictions on where the databases are located as long as they can communicate with each other. For example, you can have a standby database on the same system as the primary database, along with two standby databases on another system.

The Data Guard broker logically groups these primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit. You can manage a broker configuration using either the Oracle Enterprise Manager graphical user interface or the Data Guard command-line interface.

Role Transitions-Swithover and Failover

A database operates in one of the following mutually exclusive roles: primary or standby. Data Guard enables you to change these roles dynamically by issuing the SQL statements or by using either of the Data Guard broker's interfaces. Oracle Data Guard supports the following role ransitions:

Convert Physical standby to Snap shot standby database

Snap Shot Standby database ( 11gR2 Feature ):

-- A physical standby database which is in OPEN ( READ WRITE ) mode is called as Snap Shot Standby datase.

-- We can convert the physical standby to Snap shot standby database.

-- Advantage of Snap shot standby is that We don't require an another server to create a clone database. Some standby database can be used as a clone database by converting it into Snap shot standby database.

Convert Physical standby to Active standby database

Active Standby database ( 11gR1 Feature):

-- A physical standby database which is in OPEN READ ONLY mode is called as Active Standby database.

-- We can convert the Physical standby to Logical standby as below

-- STEP1: Stop the MRP

-- STEP2:  Open the database in read only mode

-- STEP3:  Start the MRP 

-- Advantage of Active Data guard is standby can serve the DRL ( SELECT ) statements , while currently being synchronized with the primary by the MRP.

step by step process of creating physical standby database

Steps to create a Physical standby database:

1). Prepare primary database for standby database creation

      -- Enable archiving

      -- Enable force logging

      -- Set primary database initialization parameters

      -- Configure standby redo logs

DataGuard Introduction

-- Oracle Data Guard ensures the High Availability, Data Protection and Disaster Recovery for enterprise data.

-- Oracle Data Guard maintains the one or many Secondary databases(Standby databases) as alternative to the Primary (Production) database.

Oracle Database Startup and Shutdown options

Dropping or Removing the Database and DeInstallation of Oracle DB server

Dropping or Removing the Database:

-- There are 3 ways to drop or remove the database from the Oracle DB Server. They are

                1). Mannually

Oracle Database Creation ( Using OMF )

=>> At first Goto oracle home location and check the databases available.

#

#su - oracle

$ps -eaf | grep smon

$cat /etc/oratab

$clear

Oracle Database Creation ( Silent Mode )

=>> At first Goto oracle home location and check the databases available.

#

#su - oracle

$ps -eaf | grep smon

$cat /etc/oratab

$clear

Oracle Database Creation Mannually

Mannual DB Creation:


To create the database mannually, Open a terminal and follow the below commands..

#su - oralce

$.  .bash_profile


Here we should create a parameter file on going to the oracle home database location

$cd  $ORACLE_HOME/dbs

Oracle Database creation using DBCA utility

Database Creation using DBCA:

[root@ram ~]#

[root@ram ~]# xhost +

[root@ram ~]# su - oracle

[oracle@ram ~]$ . .bash_profile

[oracle@ram ~]$ dbca

ORACLE 11gR2 INSTALLATION ON RHEL 5.6 USING VMWARE WORKSTATION-Silent Mode

This kind of Installation takes place in two major situations that are

1. When GUI installation is not supported 
2. When softwate need to be installed remotely

Here also We take all the steps what we see in GUI mode installation except RDBMS installation step

• Download  Oracle DB Server  and  Prepare it to Install
• Checking OS level Requirements
• Kernel Parameters Setup
• Security Limits Setup
• RPM Packages Installation for Oracle
• USERS  and  GROUPS creation 
• Directories  and  Permissions  setup

ORACLE 11gR2 INSTALLATION ON RHEL 5.6 USING VMWARE WORKSTATION-GUI Mode

STEPS FOR INSTALLING ORACLE 11gR2 DB SERVER:

• Download Oracle DB Server and Prepare it to Install
• Check OS level Parameters Required
• Kernel Parameters Setup
• Security Limits Setup
• RPM Packages Installation for Oracle
• Users and Groups creation
• Directories and Permissions Setup
• Install RDBMS (Oracle DB Server) software
• Check the Installed RDBMS software

Step by step redhat 5.6 installation on Vmware workstation

Step 1: Open the vmware workstation console File àNew à Virtual Machine

Choose Typical à Next

Step 2: select your installer disc image file from your local drive

VMWARE WORKSTATION INSTALLATION

• ·         Downlaod Vmware workstaion software
• ·         Here I show you VMWARE WORKSTATION 11 installation process

• ·         Run the Vmware workstation SetUp file by Double clicking on the file that you dowloaded

INTRODUCTION TO ORACLE DATABASE SERVER

ORACLE DATABASE:

   è Oracle is a Relational Database.

   è In Relational Database, All data is stored in two dimensional tables that are composed of rows and columns.

   è Oracle Database enables us to store the data, update it and efficiently retrive it.

   è Oracle provides a software to create and manage the Oracle database.

   è The database consists of Physical and Logical structures in which system, user and control information is stored.

   è The software that manages the database is called as Oracle Database Server.