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磁盘组上,需要在不停机或者尽量短的停机时间完成存储迁移。
3126 0
|
Oracle 关系型数据库 数据库
使用RMAN在ASM和文件系统之间拷贝数据
        这篇文章简单讨论如何利用RMAN工具中的backup as copy、copy、convert命令在ASM和文件系统之间拷贝数据。一.从ASM拷贝数据到文件系统。
1307 0
|
Oracle 关系型数据库 数据库
使用RMAN将RAC+ASM复制到单实例+ASM上
本次试验将部署到ASM上的双节点RAC复制到单实例的ASM上。该试验也是出自于一个项目的需求,在虚拟机上演练操作特此记录。之前已经做过多次RMAN复制数据库,这次试验的特点是从RAC复制到单实例。
979 0
|
Oracle 关系型数据库 数据库
11.2.0.3 ASM实例出现ORA-4031错误导致数据库归档失败
环境:平台:RedHat EnterPrise 5.8 X86_X64 数据库:Oracle EnterPrise 11.2.0.3 集群软件:Oracle grid 11.2.0.3 故障现象:数据库出现了归档失败,其中有一个节点的实例出现HANG死的状况。
1044 0
|
2月前
|
Oracle 关系型数据库
oracle asm 磁盘显示offline
oracle asm 磁盘显示offline
30 2
|
2月前
|
存储 Oracle 关系型数据库
【数据库数据恢复】Oracle数据库ASM磁盘组掉线的数据恢复案例
oracle数据库ASM磁盘组掉线,ASM实例不能挂载。数据库管理员尝试修复数据库,但是没有成功。
【数据库数据恢复】Oracle数据库ASM磁盘组掉线的数据恢复案例

相关实验场景

更多