Oracle RMAN vs. Export?

本文探讨了Oracle数据库中RMAN与Export两种备份方式的区别。RMAN作为物理备份工具,适用于完整、一致性的备份需求,并支持块级媒介恢复。而Export则是一种逻辑备份工具,更适合特定表的备份与恢复,但速度较慢且不支持归档日志模式。

http://www.dba-oracle.com/t_rman_export_expdp.htm

Question:  I've been using data pump (the export utility) to backup my database, but I wonder if I should be using RMAN instead.  They both do backups, so what's the advantages of each?

Answer:  Yes, RMAN and export both backup tables, and they both support flashback database, but there are some important differences:

  • Data Pump Export (expdp) - The export utility is a "logical" backup, usually done by specifying specific tables.  If you fail to do a "consistent" export, or if you fail to include related tables and use RESTRICTED and CONSISTENT mode (with referential integrity constraints), you may not be able to recover properly.  Export is often used as a supplement to RMAN, usually for the restore of specific tables.
  • Recovery manager (rman) - RMAN is designed for backup and recovery, a extension of the Enterprise Backup Utility (EBU).  RMAN takes full, physical, consistent backups of your database files..
Advantages & disadvantages of Export:
  • Free, and easy to use
  • Very slow, compared to RMAN (examines every data block)
  • Easy restore of a specific table
  • Does not require ARCHIVELOG mode
Advantages & disadvantages of RMAN:
  • RMAN has block-level media recovery
  • Has a catalog for backup tracking and a report utility
  • Fast - If you dedicate a backup device for each production disk, you can backup terabytes in the time it takes to backup any single disk.
  • Does hot or cold backups
  • Backups and restores can be done in parallel
  • Allows incremental backups (block change tracking)
  • Interfaces with media management systems (TMS)

转载于:https://www.cnblogs.com/yanlixin/archive/2011/08/31/2160284.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值