【RMAN】RAC数据恢复至单机环境

RAC数据恢复至单机环境一、概括随着越来越多的RAC环境，将RAC数据迁移至单机环境下的需求也随之增加，怎样才能更有效的迁移呢，方法有许多逻辑迁移（exp/expdp）、RMAN、DG、goldengate等，我们可根据自身环境及需求选择相应的迁移方式，下面简单介绍一下使用RMAN将RAC数据迁移至单机环境中的步骤。
二、模拟环境：整套RAC环境无故宕机，暂无法恢复，我们将之前备份的数据进行恢复
将最近一次全备份文件上传至目标环境，并查看文件信息[Oracle@oradb1 backup]$ pwd/oracle/backup[oracle@oradb1 backup]$ ls -lrt总计 264312-rw-r----- 1 oracle oinstall 132608 02-17 13:24 arch_0lp0ro84-rw-r----- 1 oracle oinstall 19456 02-17 13:24 arch_0ip0ro4u-rw-r----- 1 oracle oinstall 1114112 02-17 13:24 full_0kp0ro7v_1_1-rw-r----- 1 oracle oinstall 269107200 02-17 13:24 full_0jp0ro50_1_
通过上述我们可以看到，归档文件有两个，由于是测试环境，数据量及备份信息较简单，数据文件也是两个，由此得知文件full_0kp0ro7v_1_1存放参数文件和控制文件。
设置环境变量
[oracle@oradb1 ~]$ vi ~/.bash_profile修改参数为：export ORACLE_SID=racdb1
恢复spfile文件
[oracle@oradb1 backup]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Mon Feb 17 11:37:45 2014Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database （not started）RMAN> startup force nomount;startup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file "/oracle/db_1/dbs/initracdb1.ora"starting Oracle instance without parameter file for retrieval of spfileOracle instance startedTotal System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 281019272 bytesDatabase Buffers 780140544 bytesRedo Buffers 5517312 bytesRMAN> restore spfile from "/oracle/backup/full_0kp0ro7v_1_1";Starting restore at 17-FEB-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=19 device type=DISKchannel ORA_DISK_1: restoring spfile from AUTOBACKUP /oracle/backup/full_0kp0ro7v_1_1channel ORA_DISK_1: SPFILE restore from AUTOBACKUP completeFinished restore at 17-FEB-14RMAN> restore spfile from "/oracle/backup/full_0kp0ro7v_1_1";Starting restore at 17-FEB-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=19 device type=DISKchannel ORA_DISK_1: restoring spfile from AUTOBACKUP /oracle/backup/full_0kp0ro7v_1_1channel ORA_DISK_1: SPFILE restore from AUTOBACKUP completeFinished restore at 17-FEB-14登录到数据库，生成pfile文件，并编辑，删除与集群即节点2相关参数，修改控制文件及其他目录路径，并根据需求创建相应目录（如闪回区、oracle基础目录）--------------------------------------------------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htmLinux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm--------------------------------------------------------------------------------
idle> create pfile from spfile;File created.
创建spfile，并重启实例

idle> create spfile from pfile;File created.idle> show parameter pfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile stringidle> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile stringidle> shutdown abortORACLE instance shut down.idle> startup nomountORACLE instance started.Total System Global Area 534462464 bytesFixed Size 2254952 bytesVariable Size 213911448 bytesDatabase Buffers 314572800 bytesRedo Buffers 3723264 bytesidle> show parameter pfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /oracle/db_1/dbs/spfileracdb1. Ora
恢复控制文件，并启动数据库到mount模式

[oracle@oradb1 oracle]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Mon Feb 17 12:45:58 2014Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: RACDB （not mounted）RMAN> restore controlfile from "/oracle/backup/full_0bp0rlcu_1_1";Starting restore at 17-FEB-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=19 device type=DISKchannel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:15output file name=/oracle/oradata/racdb/current.273.839446247output file name=/oracle/oradata/racdb/current.274.839446249Finished restore at 17-FEB-14RMAN> sql "alter database mount";sql statement: alter database mountreleased channel: ORA_DISK_1更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-07/104228p2.htm

Oracle性能优化有时就这么简单_indexOracle查看用户权限相关资讯 rac RMAN RAC

RAC本地数据文件迁移至ASM的方法-- （05月23日）
浅谈RAC中的负载均衡（09/06/2015 21:49:33）
Oracle 11gR2 RAC实时应用集群（01/05/2015 09:17:03）

RAC之间消息传输流量控制（12/26/2015 15:52:38）
Oracle 11.2.0.4 RAC日志记录的时（01/29/2015 08:46:34）
基于Workstation8、CentOS6.5实现（01/04/2015 15:42:35）

本文评论查看全部评论（0）