Shulou(Shulou.com)06/01 Report--

RMAN is a backup based on physical structure and a backup based on data blocks. It supports recovery operations with online redolog and archive redolog. It is a backup and recovery tool recommended by Oracle.

DataDump (IMP/EXP, IMPDP/EXPDP) is an import and export tool based on logical structure, and it is an import and export tool based on data objects (such as tables, stored procedures, etc.). It is not supported to be used with online redolog and archive redolog. If it is used for backup and recovery, it can only be restored to the point in time of export. It is a data movement tool recommended by Oracle, which can be exported from one library and then imported to another.

Expdp and impdp commands are recommended for data migration, rather than exp and imp commands.

Expdp and impdp are server-side programs that call Oracle server internal packages and can only be used on the server side of the Oracle server.

Exp and imp can be used on both the Oracle server side and the client side, but the execution efficiency is slower than expdp and impdp.

Strategy:

General database backup strategy recommends using RMAN for backup every day and Data EXP for export backup every few days, so that if data files and other physical structures fail, you can use RMAN+Redolog to restore. If you just restore a table, you can import it directly with Data IMP to improve efficiency.

Exp- logical backup, only backup data and object creation statements, restore need to first establish a database, and then rebuild objects, import data.

Rman- physical backup, you can back up data from the file level, restore the data files, and restore the data at the same time.

Exp focuses on data

Rman focuses on files

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.