单实例ASM备份集在另一台普通文件管理机器恢复.doc

环境: OS:Red Hat Linux As 5 原库:(ASM) 目的库:(普通文件) ? 在ASM管理的数据库上使用RMAN备份集,将该备份集COPY到另一台机器上(普通文件),然后做恢复,过程步骤如下. ? ---------------------------原库上操作------------------------------- 1.在原库上备份run{? allocate channel c1 device type disk;? allocate channel c2 device type disk;? allocate channel c3 device type disk;? allocate channel c4 device type disk;? backup database format /backup/rman_bak/full_%u_%T.bak;? backup spfile format /backup/rman_bak/spfile_%u_%T.bak;? backup current controlfile format /backup/rman_bak/ctl_%u_%T.bak;? sql alter system archive log current;? backup archivelog all delete input format /backup/rman_bak/arc_%u_%T.bak;? release channel c1;? release channel c2;? release channel c3;? release channel c4;} ? 2.tar备份集并传送到目的库[oracle@hxl oracl]$tar -cvf backup.tar ./backup ? 3.查看原库的dbid(恢复的时候需要指定dbid)SQL select dbid from v$database; ????? DBID----------1839869098 ? 4.查看原库的相应目录(以便目的库也创建相应的目录)[oracle@hxl oracl]cd /u01/app/oracle/admin/oracl[oracle@hxl oracl]$ lsadump? dpdump? pfile ? -------------------目的库上操作---------------------------------- 1.修改目的机器上得oracle用户的环境变量,保持跟原机器一致export PS1=[`hostname`:$LOGIN:$PWD]$export EDITOR=viexport ORACLE_SID=oracl01export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/libexport PATH=$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/X11R6/bin:/bin:/sbinexport NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS ? 2.安装oracle软件具体步骤省略 ? 3.创建相应目录mkdir -p /u01/app/oracle/admin/oracl/{adump,dpdump,pfile} ? 4.解压缩tar文件[oracle@test ftp]$tar -xvf rman.tar ? 5.创建密码文件orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapworacl01.ora password=myoracle 密码文件的命名格式为orapw+SID ? 6.恢复参数文件[oracle@test dbs]$ rman target /Recovery Manager: Release .0 - Production on Fri Sep 28 05:39:42 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates.? All rights reserved.connected to target database (not started) RMAN set dbid 1839869098;executing command: SET DBID RMA