oracle备份还原（oracle备份还原）.docVIP

oracle备份还原（oracle备份还原） --------------------------------------- Export / import (export/import) ---- export can extract data from the database, and use import to send the extracted data back to the Oracle database. ---- 1. simply export data (export) and import data (import) The 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 whole library mode (full mode) exports all objects in the database. The process of data exporting (import) is the reverse process of data import (export), and their data flow is different. ---- 2. incremental export / import - incremental export is a common data backup method that can only be implemented on the entire 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) ---- backup the entire database, for example: System/manager inctype=complete file=990702.dmp - $exp - (2) incremental incremental export Data that changes after backing up the last backup. Such as: System/manager inctype=incremental file=990702.dmp - $exp ---- (3) cumulative type incremental export (cumulative) The cumulative type of export is only a change in the database since the last fully exported. Such as: System/manager inctype=cumulative file=990702.dmp - $exp -- database administrators can schedule a backup schedule that can be done reasonably and efficiently in three different ways of exporting data. For example, the backup task of the database can be arranged as follows: - Monday: fully exported (a) - Tuesday: incremental export (b) - Wednesday: incremental export (c) - Thursday: incremen