Oracle Development Unleashed (3rd Edition)
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:
|
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.)