Oracle Data Backup is implemented through OMS

The following article mainly discusses how to use OMS to implement specific Oracle data backup operations. In fact, it is very easy to use OMS to implement Oracle data backup, if you have browsed the following articles, you will feel that it is really easy to use the correct operation method.

In Oracle9i, you can easily export data as a file or import data from a file. The Oracle Management server Oraclemanagement server (oms) can be easily implemented. There are many instructions to explain throughout the operation process, 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.

When you log on to the Enterprise Manager Console, two options are available: Start and log on to the OracleManagement Server independently. 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 Oracleuniversal 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 Oracleuniversal installer, choose to install Oracle9i management and integration? Oraclemanagement 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 Oraclemanagement 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 OMS for Oracle Data Backup. For example, you must create 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.

The above content is an introduction to how to use OMS to implement Oracle data backup. I hope you will gain some benefits.