RMAN恢复归档但是归档放到ASM中,ASM已经挂掉的情况

简介: RMAN恢复归档但是归档放到ASM中,ASM已经挂掉的情况   RMAN> recover database;Starting recover at 21-SEP-13using channel ORA_DISK_1starting media reco...
RMAN恢复归档但是归档放到ASM中,ASM已经挂掉的情况
 
RMAN> recover database;

Starting recover at 21-SEP-13
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=118
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1
ORA-19504: failed to create file "+ARCH"
ORA-17502: ksfdcre:4 Failed to create file +ARCH
ORA-15001: diskgroup "ARCH" does not exist or is not mounted
ORA-15001: diskgroup "ARCH" does not exist or is not mounted

failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/21/2013 15:15:28
RMAN-20506: no backup of archived log found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 118 and starting SCN of 2282135 found to 

如下:

 

RMAN> run {
2> set archivelog destination to '/home/oracle/';
3> recover database;}

executing command: SET ARCHIVELOG DESTINATION

Starting recover at 21-SEP-13
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle/
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=118
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1
channel ORA_DISK_1: piece handle=/oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1 tag=TAG20130921T143110
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/home/oracle/1_118_823620769.dbf thread=1 sequence=118
channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle/
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=119
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=120
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=121
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=122
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=123
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=124
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=125
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=126
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/product/11.2.0/dbs/06okdn6b_1_1
channel ORA_DISK_1: piece handle=/oracle/app/oracle/product/11.2.0/dbs/06okdn6b_1_1 tag=TAG20130921T143346
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=/home/oracle/1_119_823620769.dbf thread=1 sequence=119
archived log file name=/home/oracle/1_120_823620769.dbf thread=1 sequence=120
archived log file name=/home/oracle/1_121_823620769.dbf thread=1 sequence=121
archived log file name=/home/oracle/1_122_823620769.dbf thread=1 sequence=122
archived log file name=/home/oracle/1_123_823620769.dbf thread=1 sequence=123
archived log file name=/home/oracle/1_124_823620769.dbf thread=1 sequence=124
archived log file name=/home/oracle/1_125_823620769.dbf thread=1 sequence=125
archived log file name=/home/oracle/1_126_823620769.dbf thread=1 sequence=126

 

记录一下

相关文章
|
SQL 存储 Oracle
Oracle 11g R2 RAC with ASM存储迁移--Rman copy&ASM REBALANCE
by acdante Oracle 11g R2 RAC with ASM存储迁移                                            -----Rman copy&ASM REBALANCE     环境介绍 VMware版本:VMware12pro 主机操作系统:RHEL6.5_64 共享存储使用VMWARE创建共享磁盘文件 数据库版本:Oracle11gR2 11.2.0.4.0_RAC   Oracle数据库文件部署在ASM磁盘组上,需要在不停机或者尽量短的停机时间完成存储迁移。
3272 0
|
Oracle 关系型数据库 数据库
使用RMAN在ASM和文件系统之间拷贝数据
        这篇文章简单讨论如何利用RMAN工具中的backup as copy、copy、convert命令在ASM和文件系统之间拷贝数据。一.从ASM拷贝数据到文件系统。
1375 0
|
Oracle 关系型数据库 数据库
使用RMAN将RAC+ASM复制到单实例+ASM上
本次试验将部署到ASM上的双节点RAC复制到单实例的ASM上。该试验也是出自于一个项目的需求,在虚拟机上演练操作特此记录。之前已经做过多次RMAN复制数据库,这次试验的特点是从RAC复制到单实例。
1017 0
|
关系型数据库 Oracle
RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]
  RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]   修改时间 22-JUN-2011     类型 HOWTO     状态 MODE...
1241 0
|
Oracle 关系型数据库
How to Manually Determining and Resolving Archive Gaps in ASM (Copy archivelog in ASM using RMAN) [I
How to Manually Determining and Resolving Archive Gaps in ASM (Copy archivelog in ASM using RMAN) [ID 1271114.
1008 0
|
SQL Oracle 关系型数据库
使用RMAN迁移文件系统数据库到ASM
--================================== -- 使用RMAN迁移文件系统数据库到ASM --==================================       在实际的工作过程中,由于ASM磁盘管理的便利性,因此很多时候需要将文件系统的数据库迁移到ASM,本文演示了如何将文件系统数据库迁移到ASM实例。
1223 0

相关实验场景

更多