RMAN备份异机恢复.docVIP

Rman备份异机恢复指南 2011-09-06 17:26:29 标签：rman 休闲 异机恢复 职场 incremental 版权声明：原创作品，谢绝转载！否则将追究法律责任。 环境介绍：操作系统版本：RHEL5.4? 32位 ORALCE版本：? 32位ORACLE_SID：? orcl源服务器和目的服务器的操作系统，oracle版本均一致 源服务器：0目的服务器：0，只需要安装oracle软件即可，不需要建库操作 一：在源服务器上使用rman备份数据库，包括数据文件，归档日志文件和控制文件，参数文件的备份 [oracle@orcl?~]$?mkdir?/u01/backup ? [oracle@orcl?~]$?rman?target?/ ? Recovery?Manager:?Release?.0?-?Production?on?Tue?Sep?6?16:04:53?2011 ? Copyright?(c)?1982,?2005,?Oracle.??All?rights?reserved. ? connected?to?target?database:?ORCL?(DBID=1287906064) ? ? RMAN?run?{? ? 2?allocate?channel?c1?device?type?disk; ? 3?backup?incremental?level?0?? ? 4?format?/u01/backup/db_full_%U.bkp?? ? 5?tag?2011-09-06-FULL ? 6?database?plus?archivelog; ? 7?release?channel?c1; ? 8?} ? RMAN?backup?current?controlfile?format?/u01/backup/controbak; ? RMAN?backup?spfile?format?/u01/backup/spfilbak;? 二：在目的服务器上复制备份数据，并准备好相关的目录 [oracle@orcl?~]$?mkdir?/u01/backup ? [oracle@orcl?~]$?scp?-rp?0:/u01/backup/*?/u01/backup/ ? oracle@0s?password:? ? controbak???????????????????????????100%?6944KB???1.7MB/s???00:04???? ? db_full_0fmlsmdt_1_1.bkp??????????????????????100%???97MB???4.4MB/s???00:22???? ? db_full_0gmlsme5_1_1.bkp??????????????????????100%??593MB???9.1MB/s???01:05???? ? db_full_0hmlsmg7_1_1.bkp??????????????????????100%?6656?????6.5KB/s???00:00?? ? spfilbak????????????????????????????100%???96KB??96.0KB/s???00:00? ? ? [oracle@orcl?~]$?mkdir?-p?/u01/app/oracle/admin/orcl/{adump,bdump,cdump,dpdump,udump,pfile} ? [oracle@orcl?~]$?mkdir?-p?/u01/app/oracle/oradata/orcl ? [oracle@orcl?~]$?mkdir?-p?/u01/app/oracle/flash_recover_area/ORCL? [oracle@orcl?~]$?mkdir?-p?/u01/app/oracle/admin/my7g/{adump,bdump,cdump,dpdump,udump,pfile} [oracle@orcl?~]$?mkdir?-p?/u02/oradata/my7g [oracle@orcl?~]$?mkdir?-p?/u01/app/oracle/flash_recover_area/ORCL Mkdir –p /u02/arch/my7g 三：在目的服务器上进行恢复 [oracle@orcl?~]$?echo?db_name=orcl??$ORACLE_HOME/dbs/initorcl.ora ? [oracle@orcl?~]$?export?ORACLE_SID=orcl? [oracle