Oracle database backup and recovery

Oracle databases have three standard backup methods: Export/Import EXP/IMP), hot backup, and cold backup. Exporting spare parts is a logical backup, while cold backup and hot backup are physical backup.

1. Export/Import)

The Export can be used to extract data from the database, and the Import can be used to send the extracted data back to the Oracle database.

1. Simple Export of data Export) and Import of data)

Oracle supports three types of output:

(1) Table mode T), which exports the data of the specified table.
2) User Mode U) to export all objects and data of the specified user.
(3) Full database mode). All objects in the databases database are exported.

Data Import) is the inverse process of data Export. The data files are imported into the database and the database data is exported to the data file respectively.

2. incremental Export/Import

Incremental export is a common data backup method. It can only be implemented for the entire database and must be exported as a SYSTEM. During this export, the system does not require any answers. The default export file name is export. dmp. If you do not want your output file to be named export. dmp, you must specify the file name to use in the command line.

Incremental export includes three types:

1). "full" incremental export Complete)
Three databases are backed up, for example:
Exp system/manager inctype = complete file = 040731.dmp
2) incremental Export
Back up the data changed after the last backup, for example:
Exp system/manager inctype = incremental file = 040731.dmp
3) "accumulative" incremental Export
The accumulative export mode is used to export the changed information in the database after the last "full" export. For example:
Exp system/manager inctype = cumulative file = 040731.dmp
The database administrator can schedule a backup schedule and export data in three different ways.
For example, you can make the following arrangements for database blocking tasks:

Monday: Full backup)
Tuesday: Incremental Export B)
Wednesday: Incremental export C)
Thursday: Incremental export D)
Friday: accumulative export E)
Saturday: Incremental export F)
Sunday: Incremental export G)