Thursday Mar 20, 2014

New Technical article: Back Up a Thousand Databases Using Enterprise Manager Cloud Control 12c

Friends,

I am pleased to announce that a new technical article of mine has been published (January 2014) on the Oracle Technical Network.


Back Up a Thousand Databases Using Enterprise Manager Cloud Control 12c

This detailed technical article explains the set up and scheduling of full and incremental RMAN Database backups for  thousands of databases using Enterprise Manager Cloud Control (Enterprise Manager) 12c, and how this is done more easily and efficiently than the older, more time-consuming, manual method of performing Unix shell scripting, RMAN scripting, and cron jobs for each database to be backed up. 

And with the Database Group Backup feature new to Enterprise Manager Cloud Control 12c, it can be even faster to set up RMAN backups for multiple databases - even if there are thousands - that are part of an Enterprise Manager Database Group.

The article also highlights the advantages of using PDBs in Oracle Database 12c and backing them up using RMAN. RMAN cannot backup individual schemas, and it has always been difficult to perform point-in-time-recovery (PITR) at an individual schema level, since schemas can easily be distributed across multiple tablespaces. The advantage in using PDBs in a Container Database is that you can easily set up RMAN backups at the Container Database level, and yet perform PITR at the PDB level. This is a clear technical advantage of the Multi-tenant architecture of Oracle Database 12c.

The set up and scheduling of RMAN database backups forms a part of the Base Database Management features of Enterprise Manager that enables numerous customers to use Enterprise Manager 12c more and more.  In fact I had personally introduced Enterprise Manager to HDFC bank in India in 2007 for the purpose of their RMAN backups, they started using it for the first time, and today they are a DBaaS-Exadata reference customer who have presented in OOW for the last 2 years.

Regards,


Porus.

Thursday Aug 29, 2013

New Technical article: Set Up and Manage Oracle Data Guard using Oracle Enterprise Manager Cloud Control 12c

This detailed technical article explains the set up of Oracle Data Guard Standby databases using Enterprise Manager Cloud Control 12c, and their management, performance, conversion to snapshot standby, switchover, failover etc. The article also includes the improvements in Database 12c for managing standbys via Enterprise Manager using a new database role which is not sysdba.

[Read More]

Thursday Aug 01, 2013

New White Paper: Advanced Uses of Oracle Enterprise Manager 12c (published AUGUST 2013)

Friends,

I am pleased to say a new Oracle white paper of mine has been published on 1st August 2013:

White Paper: Advanced Uses of Oracle Enterprise Manager 12c

This white paper includes information on EM12c Release 3 (12.1.0.3) and Managing Database 12c with EM12c Release 3.

This white paper is also currently visible in the main Oracle Enterprise Manager page:

http://www.oracle.com/us/products/enterprise-manager/index.html

Happy Reading!!

Regards,

Porus.

Friday Mar 08, 2013

Managing Data Center Chaos with Enterprise Manager

This is the book I wrote, published in December 2012 and is the first EM12c book in the world:

http://www.packtpub.com/oracle-enterprise-manager-12c-cloud-control/book
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

This book is a solid introduction to EM12c and can be used as a complimentary gift to clients seeking to know more about EM12c and its capabilities. It is written in easy to understand English. Please have a look at the updated chapter of contents:

Table of Contents

Preface
Chapter 1: Chaos at Data Centers
 
Chapter 2: Enter Oracle Cloud Control
Chapter 3: Ease the Chaos with Performance Management
Chapter 4: Ease the Chaos with Configuration Management and Security Compliance
Chapter 5: Ease the Chaos with Automated Provisioning
Chapter 6: Ease the Chaos with Automated Patching
Chapter 7: Ease the Chaos with Change Management
Chapter 8: Ease the Chaos with Test Data Management
Chapter 9: Ease the Chaos with Data Masking
Chapter 10: Ease the Chaos with Exadata Management
Chapter 11: Real-life Examples and Case Studies, and It's a Wrap: The Future is the Cloud
Index

Preface

Chapter 1: Chaos at Data Centers
Team effort
Common solutions used in data centers
Summary

Chapter 2: Enter Oracle Cloud Control
The Grid – where the cloud came from
Overview of version 12c
Striking new features in 12c
Bonus sections

Chapter 3: Ease the Chaos with Performance Management
Laying the foundation
Top activity
Testing infrastructure changes
SQL Monitoring
Doctor in the database
Real-Time ADDM
Compare Period ADDM
Active Session History (ASH) analytics
Summary

Chapter 4: Ease the Chaos with Configuration Management and Security Compliance
Lifecycle management
Auto discovery
Inventory
Detailed configuration
Search capability
History and compares
Topology
Custom configurations
Client configurations
Compliance
Compliance library
Configuration and compliance reporting
Summary

Chapter 5: Ease the Chaos with Automated Provisioning
Lifecycle management
First steps: Software Library
Provisioning library
Provisioning profiles
Deployment procedures
Customization
Lock down
Configuration details
Compliance standards
Granting permissions to the Provisioning Operator
Running EM as the Provisioning Operator
Running the procedure
Other possibilities
Summary

Chapter 6: Ease the Chaos with Automated Patching
Recommended patches
Patch plan
Out-of-place patching
Pre-patching analysis
Deployment
Plan template
Patching roles
Refreshes
Other patching procedures
Reporting
Summary

Chapter 7: Ease the Chaos with Change Management
Change management
Schema comparison
Schema Change Plan
Schema synchronization
Synchronization rules and mode
Synchronization results
Executing the synchronization
Synchronization without a Change Plan
Data comparison
Continuous comparison
Use cases
Summary

Chapter 8: Ease the Chaos with Test Data Management
Test Data Management
Creating packages
Creating the Application Data Model
Data subsetting
Applications
Table rules
Rule parameters
Space estimates
Pre/Post subset script
Generate subset
Benefits and capabilities
Summary

Chapter 9: Ease the Chaos with Data Masking
Finding sensitive data
Creating data masking definitions
New capabilities
Adding columns to mask
Defining the masking format
Advanced options
Generated Script
Scheduling the job
Testing the results
Format library
Benefits and capabilities
Summary

Chapter 10: Ease the Chaos with Exadata Management
Meeting the challenges
Discovering Exadata
Adding the hosts
Adding non-host targets
Adding the cluster and databases
Monitoring and managing Exadata
Database machine resource utilization
Exadata grid
Infiniband network
Database performance pages
Total capabilities
Summary

Chapter 11: Real-life Examples and Case Studies, and It's a Wrap: The Future is the Cloud
Case study – telecom
Case study – pharmaceutical
Case study – computer manufacturer
Case study – online store
Case study – financial institution
Case study – university
Future of cloud computing
Summary

Index

Enjoy the world of Enterprise Manager.

Regards,

Porus.

Thursday Feb 21, 2013

Endless Growth

Studies show that many corporations world-wide expect their IT footprint to grow in the coming years. They expect more servers, more databases, more data, and more of everything.

They require more floor space in their data centers, and also the corresponding greater power footprint. Have you heard of a data center where no more servers can be added because the power supply has reached its limit, or the UPS (Uninterruptible Power Supply) can no longer cope? This story is not new.

The growth seems to be endless, and this is fuelled by today's information age, where larger and larger volumes of data need to be stored and distributed to satisfy an ever-growing demand. More applications are coming to use those databases, on more and more application servers.

So for the IT Manager, this will mean more of everything in his/her data center. There may be different hardware platforms, there may be different operating systems (e.g. Solaris, Linux, IBM-AIX, Microsoft Windows), and in each case there may be different versions – such as the different flavors of Linux supplied by different vendors including Oracle Enterprise Linux, Red Hat, SUSE Linux, and so on.

To add to the complexity, nothing placed in production should be treated as static. Software changes in development cycles, enhancements take place, or security/functional issues are found. For almost anything in the IT world, new patches are bound to be released. These will also need to be applied to production, test, reporting, staging, and development environments in the Data Center on an ongoing basis.

For the Database side of things, Oracle releases quarterly a combination of security fixes known as the Critical Patch Update (CPU). Other patches are bundled together and released every quarter in the form of a Patch Set Update (PSU), and this also includes the CPU for that quarter.

Oracle strongly recommends applying either the PSU or the CPU every calendar quarter. If you prefer to apply the CPU, continue doing so. If you wish to move to the PSU, you can do so, but in that case continue only with the PSU.

The quarterly patching requirement, as a direct recommendation from Oracle, is followed by many companies which prefer to have their Databases secured with the latest security fixes. This underscores the importance of patching.

However, if there are hundreds of development, test, staging and production Databases in the Data Center to be patched, the situation quickly turns into a major manual exercise every three months. DBAs and their Managers start planning for the patch exercise in advance, and a lot of resources are allocated to make it happen – with the Administrators working on each Database serially, at times overnight and at times over the weekend.

There are a number of steps involved in patching each Database, such as locating the appropriate patch in My Oracle Support (MOS), downloading the patch, transferring it to each of the target servers, upgrading the OPATCH facility in each Oracle Home, shutting down the Databases and Listeners running from that Home, applying the patch, starting each of the Databases in restricted mode, applying any supplied SQL scripts, restarting the Databases in normal mode, and checking the patch inventory.

These steps have to be manually repeated on every Database Home on every server, and on every Database in that Home. Dull repetition of these steps in patching the hundreds of servers in a data center is a very monotonous task, and it can lead to an increase in human errors.

To avoid these issues inherent in manual patching, some companies decide not to apply the quarterly patches on their Databases. They wait for a year, or a couple of years, before they consider patching, and some even prefer to apply year-old patches instead of the latest patches. This is counter-productive and leads to their Databases being insecure and vulnerable to attacks, since the latest recommended CPUs from Oracle have not been applied.

What then is the solution, to convince these companies to apply patches regularly? If the patching process can be mostly automated (but still under the control of the DBAs), it would reduce the quarterly patching effort to a great extent. Companies would then have the confidence that their existing team of DBAs would be able to manage the patching of hundreds of Databases in a controlled and automated manner, keeping human error to a minimum.

The Database Lifecycle Management pack for Oracle Enterprise Manager Cloud Control 12c is able to achieve this via its Patch Automation capability. We will now look into Patch Automation and the close integration of Enterprise Manager with My Oracle Support.

 For the full Oracle Technet article, refer to http://www.oracle.com/technetwork/articles/oem/havewala-patching-oem12c-1864147.html

About

Blog by Porus Homi Havewala

Search

Categories
Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today