Management applications.
22
|
Chapter 1: Introducing Oracle
Database Management Features
Oracle includes many features that make the database easier to manage. Ease in Oracle management fundamentally improved with the introduction of Oracle Database 10 g , and has continued to evolve toward being more self-tuning and self-managing with the release of Oracle Database 11 g . If youare still managing Oracle databases using techniques (such as scripts) from previous releases and are moving to one of the newer releases, now is the time to reevaluate your thinking on management.
Starting with Oracle Database 10 g , statistics are automatically gathered to an Automatic Workload Repository (AWR) within the database. Oracle’s Automatic Database Diagnostic Monitor (ADDM) evaluates the statistics on a regular basis and sends alerts of potential problem conditions to Oracle Enterprise Manager, where youcan evaluate the condition in more detail and potentially take corrective actions. Some of the newer fully automated features, such as Automatic Memory Management, also leverage data gathered in the AWR.
Oracle has a near real-time view of current database conditions as it makes automated recommendations. Such recommendations will often be more accurate than would be possible with the manual processes you might have used in the past. In the following subsections we’ll introduce the impact this has on Oracle Enterprise Manager and add-on packs, Information Lifecycle Management, backup and recovery, and database availability.
Oracle Enterprise Manager
Oracle includes Oracle Enterprise Manager (EM) with its most widely deployed database products. EM provides a database management tool framework and an HTML-based interface used to manage database users, instances, and features. EM
can also manage Oracle Application Server, Oracle Applications, Oracle’s Linux release, and software products from other vendors.
The database console in Oracle’s current version provides information on database status, availability, schema, data movement configuration, and software maintenance. New with Oracle Database 11 g is the Support Workbench and diagnosability infrastructure leveraged in reporting problems to Oracle Support. Multiple database administrators can access the EM repository at the same time.
EM can be deployed in several ways: as a central console for monitoring multiple databases leveraging agents, as a “product console” (installed by default with each individual database), or through remote access, also known as “studio mode.” When deployed as a central console, Enterprise Manager is referred to as “Grid Control” and can be used for rapid installation of Oracle software, provisioning, and automated rolling patch updates.
Database Management Features
|
23
A subset of Enterprise Manager functionality is accessible through Microsoft Pocket PC Internet Explorer on wireless PDAs using EM2Go. EM2Go can monitor the status of the Oracle database and Oracle Application Server.
Information Lifecycle Management and ILM Assistant
Introduced in 2006, Information Lifecycle Management (ILM) provides a means to
define classes of data and storage tiers and move the data to the storage tiers that
provide the right combination of performance and cost. The ILM Assistant interface
for setting up and managing ILM can be downloaded from the Oracle Technology
Network at http://otn.oracle.com . For more details, see Chapter 5.
Backup and Recovery
As every database administrator knows, backing up a database is a rather mundane but necessary task. An improper backup makes recovery difficult, if not impossible.
Unfortunately, people often realize the extreme importance of this everyday task only after losing business-critical data resulting from a failure of a related system.
The following sections introduce some features used in performing database backup operations. We discuss backup and recovery strategies and options in
22
|
Chapter 1: Introducing Oracle
Database Management Features
Oracle includes many features that make the database easier to manage. Ease in Oracle management fundamentally improved with the introduction of Oracle Database 10 g , and has continued to evolve toward being more self-tuning and self-managing with the release of Oracle Database 11 g . If youare still managing Oracle databases using techniques (such as scripts) from previous releases and are moving to one of the newer releases, now is the time to reevaluate your thinking on management.
Starting with Oracle Database 10 g , statistics are automatically gathered to an Automatic Workload Repository (AWR) within the database. Oracle’s Automatic Database Diagnostic Monitor (ADDM) evaluates the statistics on a regular basis and sends alerts of potential problem conditions to Oracle Enterprise Manager, where youcan evaluate the condition in more detail and potentially take corrective actions. Some of the newer fully automated features, such as Automatic Memory Management, also leverage data gathered in the AWR.
Oracle has a near real-time view of current database conditions as it makes automated recommendations. Such recommendations will often be more accurate than would be possible with the manual processes you might have used in the past. In the following subsections we’ll introduce the impact this has on Oracle Enterprise Manager and add-on packs, Information Lifecycle Management, backup and recovery, and database availability.
Oracle Enterprise Manager
Oracle includes Oracle Enterprise Manager (EM) with its most widely deployed database products. EM provides a database management tool framework and an HTML-based interface used to manage database users, instances, and features. EM
can also manage Oracle Application Server, Oracle Applications, Oracle’s Linux release, and software products from other vendors.
The database console in Oracle’s current version provides information on database status, availability, schema, data movement configuration, and software maintenance. New with Oracle Database 11 g is the Support Workbench and diagnosability infrastructure leveraged in reporting problems to Oracle Support. Multiple database administrators can access the EM repository at the same time.
EM can be deployed in several ways: as a central console for monitoring multiple databases leveraging agents, as a “product console” (installed by default with each individual database), or through remote access, also known as “studio mode.” When deployed as a central console, Enterprise Manager is referred to as “Grid Control” and can be used for rapid installation of Oracle software, provisioning, and automated rolling patch updates.
Database Management Features
|
23
A subset of Enterprise Manager functionality is accessible through Microsoft Pocket PC Internet Explorer on wireless PDAs using EM2Go. EM2Go can monitor the status of the Oracle database and Oracle Application Server.
Information Lifecycle Management and ILM Assistant
Introduced in 2006, Information Lifecycle Management (ILM) provides a means to
define classes of data and storage tiers and move the data to the storage tiers that
provide the right combination of performance and cost. The ILM Assistant interface
for setting up and managing ILM can be downloaded from the Oracle Technology
Network at http://otn.oracle.com . For more details, see Chapter 5.
Backup and Recovery
As every database administrator knows, backing up a database is a rather mundane but necessary task. An improper backup makes recovery difficult, if not impossible.
Unfortunately, people often realize the extreme importance of this everyday task only after losing business-critical data resulting from a failure of a related system.
The following sections introduce some features used in performing database backup operations. We discuss backup and recovery strategies and options in
Similar Books
