oracle数据库备份与恢复之完全攻略（Complete walkthrough of backup and recovery of Oracle databases）.docVIP

oracle数据库备份与恢复之完全攻略（Complete walkthrough of backup and recovery of Oracle databases） Export / import (Export/Import) The data can be extracted from the database by using Export, and the extracted data can be sent back to the Oracle database by using Import. 1, simply export data (Export) and import data (Import) Oracle supports three types of output: (1) table mode (T mode), which exports the data of the specified table. (2) user mode (U), which exports all the objects and data of the specified user. (3) the base mode (Full mode), all objects in the database are derived out. The process of data import (Import) is the reverse process of data export (Export). The data files are imported into the database and exported to the data files. 2, incremental export / import Incremental export is a common data backup method that can only be implemented across the database and must be exported as SYSTEM. The system does not require answering any questions during such exports. Export file name defaults to export.dmp. If you dont want your output file to be named export.dmp, you must indicate the name of the file you want to use on the command line. The incremental export consists of three types: (1) complete incremental export (Complete), that is, backup three databases, such as exp, system/manager, inctype=complete, file=040731.dmp. (2) incremental type increments the data that has been changed after the last backup, such as exp, system/manager, inctype=incremental, file=040731.dmp. (3) cumulative incremental export, the cumulative type of export is the change in the database since the last fully exported. For example: exp, system/manager, inctype=cumulative, file=040731.dmp. The database administrator can schedule a backup schedule that will be done reasonably and efficiently in three different ways of exporting data. For example, the database can be blocked tasks can do the following arrangements: Monday: full backup (A) Tuesday: incremental export (B) Wednesday: incremental