1.8. Configuring RMAN Settings with Enterprise Manager
RMAN settings can be configured using Enterprise Manager (EM). In Oracle 10g, EM is a web-based console, which allows most DBA activities to be performed from a GUI screen instead of from the typical command-line interface. The main home page can be accessed at http://hostname.domain:EM portnumber/em. The hostname is the server or machine and can be identified by typing hostname at the Unix or Windows command prompt. The domain name is the name of network you are on. The domain name varies for whatever network you are on, for instance, sybex.com. Also, the port number for the first database with EM agent running is 5500, which is the default. Each additional database increments this port number by 1. So, an additional database on this server will be listening on port 5501. In the examples in this chapter, you have installed the EM Database Control as opposed to Grid Control, which is an additional software component to support 10g Grid Control options.
We will demonstrate how to access EM. Once in the web application, you will navigate to the screens that are capable of modifying the configuration settings.
Let's look at the EM screens that allow the configuration of some of the RMAN settings:
First, enter http://hostname.domain:5500/em in the web browser to get to the EM main home page, which take you to the following login screen. The hostname is the name of the computer or server that is running EM, which is dstuns-xp and the network domain. At this point, enter the user id SYS and its password and connect as SYSDBA.
After logging in and clicking the Login button, the main EM Database Control main page appears, as you can see in the following graphic. (Notice that we saved this as two screens because of the size.) The Maintenance table will be selected to navigate to the maintenance screens that contain the screens that allow configuration modifications:
Next, select the Backup/Recovery section and click Configure Backup Settings, which will navigate to one of the configuration settings screens available in EM Database Control:
This screen displays the configuration settings for backups. These values can be modified, which will have the same effect as the RMAN command CONFIGURE. There are also configurations settings for recovery and the recovery catalog.
NOTE
It is important to know that an account equal to the Windows Administrator account or that account itself should be used in the Host Credentials sections for the Windows environment. In the Unix environment, the Oracle account or similar privileged account should be used. This is because the EM 10g web applications essentially host out to the operating system to execute these commands with RMAN CLI.