Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Installation/Configurations10g

October 11, 2017 Oracle Real Application Cluster Intro
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Oracle Real Application Cluster Intro

RAC Defination

Oracle RAC stands for Oracle Real Application cluster. It is a clustering solution that ensures high availability of databases by providing instance failover and Load Balancing features.

Oracle RAC is composed of two or more database instances. They are composed of Memory structures and background processes same as the single instance database.

 

Oracle RAC instances use two processes

1- GES(Global Enqueue Service)

  • The Global Enqueue Service (GES) manages or tracks the status of all the Oracle enqueuing mechanism.
  • This involves all non Cache fusion intra-instance operations.
  • GES performs concurrency control on dictionary cache locks, library cache locks, and the transactions.
  • GES does this operation for resources that are accessed by more than one instance.

2- GCS(Global Cache Service)

  • The main function of the global cache service (GCS) is to track the status and location of the data blocks.
  • Status is the resource role and the resource mode.
  • The GCS is the main mechanism by which cache coherency among the multiple caches is maintained.
  • GCS maintains the modes for blocks in the global role and is responsible for block transfers between the instances.
  • The LMS processes handle the GCS messages and carry out the bulk of the GCS processing.

 

Oracle RAC instances are composed of following Background Processes

 

ACMS—Atomic Controlfile to Memory Service (ACMS)

In an Oracle RAC environment, the atomic controlfile to memory service (ACMS) per-instance process is an agent that contributes to ensuring a distributed SGA memory update is either globally committed on success or globally aborted in the event of a failure.

GTX0-j—Global Transaction Process

he GTX0-j process provides transparent support for XA global transactions in a RAC environment. The database autotunes the number of these processes based on the workload of XA global transactions.

LMON—Global Enqueue Service Monitor

The LMON process monitors global enqueues and resources across the cluster and performs global enqueue recovery operations.

LMD—Global Enqueue Service Daemon

The LMD process manages incoming remote resource requests within each instance.

 

LMS—Global Cache Service Process

The LMS process maintains records of the datafile statuses and each cached block by recording information in a Global Resource Directory (GRD). The LMS process also controls the flow of messages to remote instances and manages global data block access and transmits block images between the buffer caches of different instances. This processing is part of the Cache Fusion feature.

 

LCK0—Instance Enqueue Process

The LCK0 process manages non-Cache Fusion resource requests such as library and row cache requests.

 

RMSn—Oracle RAC Management Processes (RMSn)

The RMSn processes perform manageability tasks for Oracle RAC. Tasks accomplished by an RMSn process include creation of resources related Oracle RAC when new instances are added to the clusters.

 

RSMN—Remote Slave Monitor

Remote Slave Monitor manages background slave process creation and communication on remote instances. These background slave processes perform tasks on behalf of a coordinating process running in another instance.

 

 

October 6, 2017 Data Guard Vs SAN To SAN Replication
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Data Guard Vs SAN to SAN Replication

 

Oracle Data Guard

SAN-to-SAN

Implementation Cost

Low High

Database Aware

Yes No

Granularity of Replication

Transaction level Disk Block Level

Distance Limitations

No Limitations Limitations Exist

Recovery from human error or corruption

Easy to detect and can be recovered by replaying logs Replicates block as it is and possible that corrupt blocks gets replicated.
October 6, 2017 Comparison Between Oracle GoldenGate and DataGuard
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Comparison Between Oracle GoldenGate and DataGuard

Technical Points

Oracle Dataguard / Active Dataguard

Oracle Golden Gate

Operating System Primary Database and Standby Database Should be same. (But 11g Onwards it supports Heteregenous Data Guard Configurations.                       Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64)  and Microsoft Windows 2008 Server R2 (x64) Primary Database and Standby Database need not be same.
Database Should be Oracle Database in both Source and Target. Database can be different in Source and Target. Example :Source database can be Oracle and Target database can be MY SQL/MS SQL server.
Database Version Primary Database and Standby Database Should be same. Primary Database and Standby Database need not be same. (Including Database Software).
Replication method Data movement will be in-form of Log Files. It moves Data Transaction wise through Extract and Replicat process from Source to Target, when commits.
Database mode Source: Read write mode
Target:  Recovery Mode / Open Read Only.
Source: Read write mode
Target:  Read write mode
Replication Type Unidirectional. (Data movement will happen in single direction). Multi-Directional.
Integrated Feature No additional software to install. Oracle Data Guard /Active Data Guard includes in Enterprise Edition. Oracle GoldenGate software to install in Source as well as Target.
License Cost No additional license required for Oracle Data Guard to install. Oracle Active Data Guard is an enterprise option with Oracle Enterprise Edition. Oracle GoldenGate Software Licence required in Source and Target Databases.
Database Edition Source: Oracle Enterprise Edition
Target: Oracle Enterprise Edition.
Source: Can be Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
Target:  Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
October 6, 2017 Find and Delete Older Files in Linux
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Delete Older Files in Linux

 

Files older than 1 day

find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \;

 

Move files older than 25 hours

find /rman/arch/*.dbf -mmin +1500 -exec mv {} /rman/archbkp/ \;

 

List files older than 2hours

find /rman/arch/*.dbf -mmin +120 -exec ls -ltr {} \;

 

Delete files older than 1 day

find /rman/arch/*.dbf -mtime +1 -exec rm {} \;

 

Delete files older than 1 hours

find /rman/arch/*.dbf -mmin +60 -exec rm {} \;