ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN恢复归档但是归档放到ASM中,ASM已经挂掉的情况

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

原创 Linux操作系统 作者:gaopengtttt 时间:2013-10-18 16:59:23 0 删除 编辑
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

 

记录一下

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-774621/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 外键加索引问题
请登录后发表评论 登录
全部评论
wxh gp_22389860 <<深入理解MySQL主从原理专栏>> 发布 可加WX了解

注册时间:2008-10-13

  • 博文量
    681
  • 访问量
    2936564