2007年11月6日

10g備份跟還原相關(3/3)

Setting Duration and Throttling Option
1、copy database in 10 hours with minimum impact
RMAN>backup as copy duration 10:00 minimized load database;
2、back up tablespace in 4 hours
RMAN>backup duration 4:00 filesperset 1 tablespace users;
3、back up as  many files as possible in 4 hours
RMAN>backup duration 4:00 partial filesperset 1 database;

duration <hrs>:<mins> [partial] [minimize {time|load}]
partial:假如在指定時間內沒有完成備份將不會發生錯誤訊習。如沒有指定的話,將會停止rman執行跟顯示錯誤訊習
minimize time:儘可能的在指定的時間內完成備份的動作
minimize load:儘可能的不影響正常的運作之下完成備份的動作



summary
  • use the flash recovery area to simplify file managemenet for all recovery-related files
  • apply incremental backups to data file image copies to speed up recovery time
  • iuse the block change tracking file to create faster incremental backups
  • use incremental backups to refresh a clone database
  • use compressed backup sets to save storage space

overview
  • setting up a flash recvoery area and managing space
  • enabling block change tracking
  • using the Oracle-suggested strategy for backups
  • using optimized incremental backups
  • recovering with incrementally updated backups
  • performing RMAN channel failover


Posted by my_work at 樂多Roodo! │23:19 │回應(0)引用(0)DB
樂多分類:網路/3C 共同主題:Oracle 工具:編輯本文
Ads by Roodo! 

引用URL

http://cgi.blog.roodo.com/trackback/4431769