Oracle data Backup via OMS

In Oracle 9i, data can be easily exported to a file or imported from a file. With Oracle's Management Server (Oracle Management Server,oms) can be easily implemented, there are many places to explain the entire operation, but the complete guidance is not much. Many of the major forums on the so-called master, the answer to the topic is often, Master is not OMS, with Exp/impl Bar. If you insist on asking, he will probably tell you, in fact, I do not know. If a document can be a fool's guide to how they do it, most people will be ecstatic and indifferent to the download to save, go back to slowly study. For such a person who thinks the master, only send them two words: despise.

When you log on using the Enterprise Manager console, there are two options: Start and Log on to Oracle Management Server independently. The former allows us to perform some common administrative tasks, such as managing accounts, database objects, and so on, only the latter can provide us with the function of backup. However, before landing in OMS, you must first install the OMS service.

Start Oracle Universal Installer, view installed products, expand the Oracle home directory--orahome92, if there is no oracle9i management and integration, you are not installed. The installation method is:

In the list of available products for Oracle Universal installer, select Install Oracle 9i Management and integration?oracle Management Server.

After the installation is complete, you need to configure a management database to start: Configuration and Migration tools? Enterprise Manager Configuration Assistant. Select the Configure local Oracle Management Server in the configuration operation to create a new database profile typical. The system will create a database called Oemrep that holds management information, where you need to specify the password for the SYS and system accounts.

After the installation is complete, start the Manage Server service, under Windows you can go to the background service to start directly, its name is Oracleorahome92managementserver. Also, make sure that other Oracle services that are automatically started are also started.

Then you can use the Enterprise Manaer console login, account sysman password oem_temp. The system will require you to enter a new Sysman password the first time you log in. If in the landing when the "identity is not correct" hint, please confirm that you use the login account is Sysman, if the account is correct but always appear this error, please delete just set up the database, rebuild one.

If you are using Windows, before backing up your data, you first need to build an operating system user that is dedicated to Oracle backups, such as setting up user oracle_back, belonging to the Administrator group and the ORA_DBA group. You then need to assign a batch permission to the user in the local policy. The method is:

Control Panel-Administrative Tools-Local security policy-local policy-User rights assignment-log on as a batch job, under which to add the Oracle_back user just created.

Back to Enterprise Manager Console, open the configuration? Preferred identification, locate your machine name in the target name, and its target type as a node, enter oracle_back and its password in the following ID. Then find the name of the database you want to back up, its target type is the database, and enter the DBA account in the ID. Ok, now you can back up the data. Right-click in any table and choose Data Management? Export, you can see this task in the assignment.