|
连续做了5,6A 2个实验,产生了2个化身,分别是3号,4号
做6b的时候 ,用的备份是很早之前的,在2号化身上
1,restore database 执行成功无报错
2,recover database 报错,日志断点在14号
3,recover database until sequence 14 thread 1; 执行成功无报错,日志从2号化身上的日志,一直滚到4号化身的14号日志为止
4,alter database open resetlogs; 没有报错,成功生成一个新的化身
查询ftp上的结果为:
A
----
1
这样实验算是成功的,对不对?
这个时候发现recover的时候日志跑的太多,从2号化身开始跑起
我想做一个level 0备份,这样以后,如果在做一次6B实验,recover的时候是不是可以少跑一些日志?
但是备份的时候报错,说是少了14号日志,为什么会这样?怎么办?
RMAN> backup tag '0630incr0' incremental level 0 database plus archivelog delete all input;
Starting backup at 2016-06-30:17:30:01
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/30/2016 17:30:02
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file +FRA/orcl/archivelog/2016_06_30/thread_1_seq_14.458.915900383
ORA-17503: ksfdopn:2 Failed to open file +FRA/orcl/archivelog/2016_06_30/thread_1_seq_14.458.915900383
ORA-15012: ASM file '+FRA/orcl/archivelog/2016_06_30/thread_1_seq_14.458.915900383' does not exist
|
|