0354-0359

Previous Table of Contents Next

Page 354

• Back up control files
• Enable/disable automatic archiving
• Switch log files
• Create/drop redo log files/groups

The interface is similar to the tree structure in the OEM console Navigator window. (See Figure 15.10.)

Figure 15.10.
Oracle Backup
Manager.

Unfortunately, the Backup Manager is not reliable enough for actual backup operations. It has far too many bugs to trust in a critical situation. However, one useful feature of Backup Manager is the Backup wizard. The Backup wizard will generate a script that can be run by the Job Control system.

CAUTION

Do not rely on Backup Manager in a critical situation. Backup Manager allows the user to perform complex tasks such as the following:

• Starting and stopping the database
• Restricting access to the database
• Altering tablespaces offline and online
• Performing online backups

However, the user should use more reliable tools such as Server Manager or SQL*Plus.

Data Manager

Data Manager is a front-end graphical user interface (GUI) designed to work with the Export, Import, and SQL*Loader utilities. These are line-command utilities that can be awkward to use. Oracle has attempted to simplify them by combining the three tools into a single interface.

Data Manager begins by connecting to a database. Data Manager always shows the current database and user in the top of the Data Manager window. (See Figure 15.11.)

Page 355

Figure 15.11.
The Export tab.

Export

The Export tab allows the user to export data from the database to a file. (See Figure 15.11.) The export process centers around the export of tables. Typically, a set of tables is exported and may be accompanied by its corresponding indexes, grants, rows, and constraints. This file may then be imported into any other Oracle database. The export may be run from the local machine or the server. The user may choose the appropriate dump directory by clicking the Browse button. Next, the user must decide what to export. Here are the options:

• The Users option will export objects owned by a single user. Click the Specify button to show all available users.
• The Tables option will export individual tables. Click the Specify button to show all available tables.
• The Full option exports the entire database.
• The Advanced button will provide different options depending on the current selected tab. With Export selected, the Advanced button provides access to the other export details such as buffer size , record length, and data path . Choose the Generate Log File option to ensure that a log file can later be accessed if a corresponding import fails. (See Figure 15.12.)

Import

The Import tab imports data from the dump file of a previous Export session. This file must reside on the machine running Data Manager. The import process centers around the import of tables. Typically a set of tables is imported and may be accompanied by its corresponding indexes, grants, and rows (provided these options were exported). The user has three options to determine which objects are imported. (See Figure 15.13.)

Page 356

Figure 15.12.
Advanced Export
Options dialog box.

• The Users option will import objects owned by a single user. Click the Specify button to show all available users.
• The Tables option will import individual tables. Click the Specify button to show all available tables.
• The Full option imports the entire file.

Figure 15.13.
The Import tab.

CAUTION

Import can only read data that has been generated by the Export utility. It will not work with any other type of data.

Page 357

Load

The Load tab is used to import data from foreign sources such as fixed-format and delimited-format files. It can also perform functions on the data as it is being imported. Load has five main files. (See Table 15.3.)

Table 15.3. Files used in Load.

File	Description	Type of File
Control file	Contains the specifications of the load	Input
Data file	Contains the data to be loaded into the Oracle database	Input
Log file	Logs the successes or failures of the Loading process	Output
Bad file	Contains records that were rejected by Load or by the Oracle RDBMS	Output
Discard file	Contains records that were rejected by the WHERE clause as specified in the control file	Output

Instance Manager

Instance Manager allows the user to perform the following tasks:

• Start up and shut down the database
• View and edit the initialization parameters
• Monitor and manage user sessions
• Manage problem transactions

Click the database (see Figure 15.14) to show the current status of the database. The Status tab shows information pertaining to the current database. The Startup and Shutdown tabs allow the user to start up or shut down the databases with proper parameters.

Click the Initialization parameters to show all parameters for the database. This will allow the user to edit the dynamic parameters for the current instance. Changes to other non-dynamic parameters will not be implemented until the database is restarted. Double-click an initialization parameter to change it.

Page 358

Figure 15.14.
Instance Manager.

Schema Manager

Schema Manager allows the user to create and edit all objects that can belong to a schema. (See Figure 15.15.)

Figure 15.15.
Schema Manager.

Security Manager

Security Manager is used to administer users, roles, and profiles. (See Figure 15.16.) Table 15.3 lists the tasks that may be performed in each area.

Page 359

Table 15.3. Tasks in Security Manager.

Area	Tasks
Users	Create/drop users Grant/revoke privileges Change user passwords Change default and temporary tablespaces Change tablespace quotas
Roles	Create/drop roles Grant/revoke privileges Change authentication
Profiles	Create/drop profiles Alter profile parameters Assign profile to users

Figure 15.16.
Security Manager.

Software Manager

Software Manager is a tool designed to help administer software releases over the network. It has the capability to add or delete products, packages, and files from registered clients . These tasks can be run immediately or scheduled to run at a later point in time (like over the weekend ). This automation of software installation and replication can save enormous amounts of time. Software Manager typically controls releases of Oracle software. However, Product Import allows it to also manage third-party products. (See Figure 15.17.)

Previous Table of Contents Next