基于catalog 的rman 备份与恢复.doc

基于 catalog 的 RMAN 备份与恢复基于 catalog 的 RMAN 备份与恢复个人分类: Oracle Backup & Recover 基于 catalog 的 RMAN 备份与恢复分类: RMAN 备份恢复 2010-12-13 13:37276 人阅读评论(0) 收藏举报--================================= -- 基于 catalog 的 RMAN 备份与恢复--================================= RMA N 的备份与恢复存储仓库的数据通常存放于控制文件或恢复目录中,本文主要讲述基于 catalog 的备份与恢复。关于 catalog 的创建请参考: RMAN catalog 的创建和使用 catalo g 方式的 RMA N 备份与恢复只不过是将备份恢复信息数据放在 catalog 目录内,普通的 rman 方式则是存放在控制文件中 catalog 方式可以存储常用或特定的备份与恢复的脚本有关 catalo g方式 RMA N 存储脚本请参考:基于 catalo g创建 RMA N 存储脚本一、基于 catalog 来备份数据库( 目标数据库 orcl , 恢复目录数据库 asmdb) 首先基于 catalog 创建备份脚本-- 连接到 RMAN [******@oradb ~]$ rman target sys/******@orclcatalogrman/******@asmdb connectedtotargetdatabase:ORCL(DBID=1263182651) connectedtorecoverycatalogdatabase -- 创建全局删除废弃备份的脚本 RMAN>createglobal script. ment'A script. for obsolete backup and delete it'{ 2>allocate channel ch1 devicetypedisk; 3>deleteobsolete recovery windowof7 days; 4>release channel ch1; 5>} new incarnationofdatabaseregisteredinrecoverycatalog startingfullresyncofrecoverycatalog plete created global script. global_del_obso -- 创建全局归档日志的备份脚本 RMAN>createglobal script. global_arch ment' A script. for archivelog and delete it' 3>{ 4> allocate channel ch1 devicetypedisk; 5> sql " alter system archive log current"; 6> setlimit channel ch1 readrate=10240; 7> setlimit channel ch1 kbytes=2048000; 8> pressed backupset archivelogalldeleteinput 9> format='/u01/bk/rmbk/arch_%d_%U' 10> tag='Archbk'; 11> release channel ch1; 12>} created global script. global_arch -- 创建全局 0 级增量备份脚本 RMAN>createglobal script. global_inc0 ment' A script. for backup database using incremental level 0' 3>{ 4> executeglobal script. global_del_obso; 5> allocate channel ch1 devicetypedisk; 6> setlimit channel ch1 readrate=10240; 7> setlimit channel ch1 kbytes=2048000; 8> pressed backupset incrementallevel0database 9> format='/u01/bk/rmbk/inc0_%d_%U' 10> tag='Inc0'; 11> release channel ch1; 12> executeglobal script. global_arch; 13>} created global script. global_inc0 -- 列出已经创建的全局脚本