Oracle Data Backup Using oms

In oracle 9i, you can easily export data as files or import data from files. The oracle management server (oms) can be easily implemented. There are many instructions to explain throughout the operation, but there are not many complete guidance materials. There are many so-called masters on major forums. The answer to this topic is often that the experts do not use oms, so use exp/impl. If you insist on asking, he will probably tell you, but I don't know. If there is a document that can guide them how to do it, most people will download and save it out of the air and study it slowly. For those who think they are masters, they only send two words: contempt.

When you log on to the Enterprise Manager Console, two options are available: independently starting and logging on to the Oracle Management Server. The former allows us to perform some common management work, such as managing accounts and database objects. Only the latter can provide us with the backup function. However, before logging on to oms, you must first install the oms service.

Start oracle universal installer, check the installed products, and expand oracle main directory-oraHome92. If oracle9i management and integration is not available, it means you have not installed oracle. The installation method is as follows:

In the list of available products of oracle universal installer, choose to install oracle 9i management and integration? Oracle management server.

After the installation is complete, you need to configure a management database and start: Configuration and Migration tools? Enterprise Manager Configuration Assistant. In the configuration operation, select to configure the local oracle management server? Create a new database file? Typical. The system will create a database named oemrep to save the management information. You need to specify the password of the sys and system accounts.

After the installation is complete, start the manage server Service. In windows, you can directly start it in the background service. Its name is OracleOraHome92ManagementServer. Make sure that other oracle services that are automatically started are also started.

Then you can log on to the Enterprise Manaer Console. The account sysman password is oem_temp. After the first login, the system will ask you to enter a new sysman password. If the "Incorrect Identity Authentication" prompt appears during login, make sure that the account you are using is sysman. If the account is correct, the error always appears, delete the database you just created and recreate it.

If you are using windows, before backing up data, you must first create an operating system user dedicated to oracle backup, such as creating the user oracle_back, which belongs to the Administrator group and ora_dba group. Then you need to assign a batch processing 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 and add the oracle_back user just created under this permission.

Go back to the Enterprise Manager Console and open the configuration? Preference? First, find your machine name in the target name, and set its target type to node. Enter oracle_back and its password in the following ID card. Find the name of the database you want to back up. The target type is database. Enter the dba account in the ID card. OK. Now you can back up data. Right-click a table and choose data management? Export, you can see this task in the job.