rman catalog 脚本.docx

RMAN catalog自动备份脚本的创建使用，如果你还不了解catalog如何创建可以参考RMAN catalog的创建和基本使用创建删除过期备份的全局脚本[oracle@catalog?~]$?rman?catalog?cataloguser/cataloguser?target?sys/oracle@zhong??Recovery?Manager:?Release?10.2.0.1.0?-?Production?on?Wed?Mar?28?08:53:27?2012????Copyright?(c)?1982,?2005,?Oracle.?All?rights?reserved.????connected?to?target?database:?ZHONG?(DBID=1447686871)??connected?to?recovery?catalog?database????RMAN?replace?global?script?global_del?comment?delete?obsolete?backup?{??2?allocate?channel?c1?device?type?disk;??3?delete?obsolete?recovery?window?of?15?days;??4?release?channel?c1;??5?}????replaced?global?script?global_del????RMAN??备份当前的控制文件RMAN?replace?global?script?global_bkctl?comment?backup?current?controlfile{??2?allocate?channel?c1?device?type?disk;??3?backup?as?compressed?backupset??4?format=/orabackup/backupctl.ctl?tag=bkctl??5?channel=c1??6?current?controlfile?reuse;??7?release?channel?c1;??8?}??replaced?global?script?global_bkctl????RMAN??备份归档日志，限制channel读取速度为10M，最大备份片4GRMAN?replace?global?script?global_arch?comment?backup?archivelog?as?delete?input{??2?allocate?channel?c1?device?type?disk;??3?sql?alter?system?archive?log?current;??4?set?limit?channel?c1?readrate=10240;??5?set?limit?channel?c1?kbytes=4096000;??6?backup?as?compressed?backupset??7?format=/orabackup/arch_%d_%U?tag=bkarch??8?channel=c1??9?archivelog?all?delete?input;??10?release?channel?c1;??11?}??replaced?global?script?global_arch????RMAN??0级增量备份RMAN?replace?global?script?global_inc0?comment?backup?database?as?incremental?level?0{??2?execute?global?script?global_del;??3?allocate?channel?c1?device?type?disk;??4?set?limit?channel?c1?readrate=10240;??5?set?limit?channel?c1?kbytes=4096000;??6?backup?as?compressed?backupset??7?incremental?level=0??8?format=/orabackup/inc0_%d_%U?tag=inc0??9?channel=c1??10?database;??11?release?channel?c1;??12?execute?global?script?global_arch;??13?execute?global?script?global_bkctl;??14?}??replaced?global?script?global_inc0????RMAN??1级增量备份RMAN?replace?global?script?global_in