Core technical points of Oracle backup and recovery

1. Select "Enterprise Manager Configuration Assistant" in "Configuration and Migration Tools ";

Create "archive database ":

(1) Configure local OMS;

(2) create a new archive database;

(3)★We recommend that you use the "Custom" method (no need to create a new database );

(4) "Where is the archive database stored? ": We recommend that you select" in other existing databases ";

(5) log on to the database as a DBA. Enter the SID of Oracle for "service;★[6688 e-commerce website www.6688.cc]

2. Run "Enterprise Manager Console" and select "log on to OMS ";

Administrator: sysman (default)★

Port: oem_temp (default)★

ManagementServer: localhost or host name

★Note: Before logon, make sure that the OracleOraHome90ManagementServer service is started. After Successful Logon, change the password immediately;

3. After successfully logging on to OMS, use the "Search wizard" to search for nodes to display node items such as databases;

★Note: before searching, make sure that the racleOraHome90Agent service is started;

Enter the machine name or localhost for the node name to be searched;

4. Click the database node in the OEM and log on using system/manager;

5. Select "Preferences" from the "configuration" menu, and configure "preferred authentication ";

(1) Select the node (machine name or localhost) found in step 1 );

(2) Username: OS username (currently my username is administrator)★

Command: OS logon Password

★Note: you must go to "Control Panel"-> "Local Security Settings"-> "Local Policy"-> "User Privilege assignment"-> "Log on as a batch operation"

You can add an OS login name to the project to export or import data.

[Export and import data after completing the configuration in the preceding five steps]

★Note: The preceding configurations allow normal data export and import operations;

If you select "backup" or "recovery operation" in Database "Backup management ",

Sys/change_on_install should be used to log on to the database server as sysdba,

At the same time, the database login user with "preferred authentication" is: sys/change_on_install/sysdba;

Otherwise, the backup and recovery operations cannot be performed.

Bytes --------------------------------------------------------------------------------------------

Use command line to import/export data

Bytes --------------------------------------------------------------------------------------------

1. Run CMD and use the EXP command to export data. (Note: The exported data file is located in the path indicated by the current command line)

2. Use IMP to import data;

If Scott cannot import data (the system user is prompted to have insufficient permissions), log on to the "Enterprise Manager Console" by using the system user ",

Grant the Scott user the DBA role.

★Note: when running the imp command, the user name and password are prompted to be the target user of the data to be imported;