基于catalog 的RMAN 备份与恢复

connectedtotargetdatabase:ORCL(DBID=1263182651)
connectedtorecoverycatalogdatabase
--创建全局删除废弃备份的脚本
RMAN>createglobal script. global_del_obso comment'A script. for obsolete backup and delete it'{
基于catale Backup & Recover
基于catalog 的RMAN 备份与恢复
分类：RMAN 备份恢复2010-12-13 13:37276人阅读评论(0)收藏举报
--=================================
catalog方式的RMAN备份与恢复只不过是将备份恢复信息数据放在catalog目录内，普通的rman方式则是存放在控制文件中
catalog方式可以存储常用或特定的备份与恢复的脚本
有关catalog方式RMAN存储脚本请参考：基于catalog创建RMAN存储脚本
2>comment' A script. for archivelog and delete it '
3>{
4> allocate channel ch1 devicetypedisk;
5> sql " alter system archive log current";
2>allocate channel ch1 devicetypedisk;
3>sql " alter database datafile 4 offline ";
--创建全局0级增量备份脚本
RMAN>createglobal script. global_inc0
2>comment' A script. for backup database using incremental level 0'
3>{
IDNAME
---------- ---------------
1 Robinson
也可以使用下面的恢复方式来完成恢复
RMAN>run{
startingfullresyncofrecoverycatalog
fullresync complete
created global script. global_del_obso
--创建全局归档日志的备份脚本
RMAN>createglobal script. global_arch
9> format='/u01/bk/rmbk/arch_%d_%U'
10> tag='Archbk';
11> release channel ch1;
12>}
created global script. global_arch
7> setlimit channel ch1 kbytes=2048000;
8> backupascompressed backupset incrementallevel0database
9> format='/u01/bk/rmbk/inc0_%d_%U'
global_del_obso
A script.forobsoletebackupanddeleteit
global_inc0
A script.forbackupdatabaseusing incrementallevel0
b.restore
c.recover
d.alterdatafile n online;|altertablespace tbs_name online
--删除非系统表空间users的数据文件(数据库位于open状态)
10> tag='Inc0';
11> release channel ch1;
12> executeglobal script. global_arch;
13>}
created global script. global_inc0
[oracle@oradb orcl]$ pwd
/u01/oracle/oradata/orcl
[oracle@oradb orcl]$ rm users01.dbf
lion@ORCL>select*fromtb2;
RMAN>list backupset summary;
RMAN>list backupset;
RMAN>listbackupofcontrolfile;
RMAN>listbackupofarchivelogall;
RMAN>listbackupofdatabase;
RMAN>listbackupofdatafile n;
二、恢复操作
1.非系统表空间的恢复步骤
a.alterdatafile n offline immediate;|altertablespace tbs_name offline immediate;
--删除以前的备份
RMAN>deletenoprompt backupset;
--备份前验证归档日志是否存在
RMAN>crosscheck archivelogall;
--删除无效的归档日志信息
6> setlimit channel ch1 readrate=10240;
7> setlimit channel ch1 kbytes=2048000;
8> backupascompressed backupset archivelogalldeleteinput
4> executeglobal script. global_del_obso;
5> allocate channel ch1 devicetypedisk;
6> setlimit channel ch1 readrate=10240;
RMAN>deletenoprompt expired archivelogall;
--使用0级增量备份数据库
RMAN>run{executeglobal script. global_inc0;}
--查看刚刚完成的备份情况
select*fromtb2
*
ERROR at line 1:
ORA-01116:errorinopeningdatabasefile4
ORA-01110:datafile4:'/u01/oracle/oradata/orcl/users01.dbf'
Description
-----------------------------------------------------------------------
global_arch
A script.forarchiveloganddeleteit
2>allocate channel ch1 devicetypedisk;
3>sql " alter tablespace users offline immediate ";
4>restoretablespace users;
一、基于catalog来备份数据库(目标数据库orcl，恢复目录数据库asmdb)
首先基于catalog创建备份脚本
--连接到RMAN
[oracle@oradb ~]$ rman target sys/redhat@orclcatalogrman/rman@asmdb
--基于catalog的RMAN备份与恢复
--=================================
RMAN的备份与恢复存储仓库的数据通常存放于控制文件或恢复目录中，本文主要讲述基于catalog的备份与恢复。
关于catalog的创建请参考：RMAN catalog的创建和使用
--列出已经创建的全局脚本
RMAN>list global script. names;
ListofStored ScriptsinRecoveryCatalog
Global Scripts

--启用控制文件的自动备份功能
RMAN>configure controlfile autobackupon;
RMAN>configure controlfile autobackup formatfordevicetypediskto'/u01/bk/rmbk/auto_ctl_%d_%f';
ORA-27041:unabletoopenfile
Linux Error:2:Nosuchfileordirectory
Additional information:3
RMAN>run{
2>allocate channel ch1 devicetypedisk;
3>deleteobsolete recovery windowof7 days;
4>release channel ch1;
5>}
new incarnationofdatabaseregisteredinrecoverycatalog