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 ~]$ echo db_name=orcl $ORACLE_HOME/dbs/initorcl.ora [oracle@orcl ~]$ export ORACLE_SID=orcl [oracle@orcl ~]$ rman target / Recovery Manager: Release .0 - Production on Tue Sep 6 16:18:19 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database (not started) RMAN set dbid 1287906064; //指