RMAN恢復歸檔但是歸檔放到ASM中,ASM已經掛掉的情況

gaopengtttt發表於2013-10-18
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章