【Oracle人生哲理】RMAN增量备份与人生的道理
在练习 RMAN Incremental Backup 时、参照 OCP TK 042 :
显然、基于答案、archive log 不在列位、偶撞了南墙也想测试呀
[plain]
RMAN> backup incremental level 0 archivelog all;
Starting backup at 30-MAR-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=2 stamp=811463043
channel ORA_DISK_1: starting piece 1 at 30-MAR-13
channel ORA_DISK_1: finished piece 1 at 30-MAR-13
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_03_30/o1_mf_annnn_TAG20130330T222403_8ofxd54r_.bkp tag=TAG20130330T222403 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-MAR-13
RMAN> backup incremental level 1 archivelog all;
Starting backup at 30-MAR-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=2 stamp=811463043
input archive log thread=1 sequence=5 recid=3 stamp=811463081
channel ORA_DISK_1: starting piece 1 at 30-MAR-13
channel ORA_DISK_1: finished piece 1 at 30-MAR-13
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_03_30/o1_mf_annnn_TAG20130330T222442_8ofxfccb_.bkp tag=TAG20130330T222442 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-MAR-13
竟然成功！！答案错了？？！！
未必、、、
因为答案是基于业务规则而非语义语法
对归档日志进行增量备份那就应了那句谚语--脱裤子放易做图哈
生活中、很多事情的对错是基于"人情世故"的、
原本你的做法完全正确、但你没有按照"潜规则行事"、那么你就错了、
所以、不要太在意对错、因为那原本就没有定义、
走过、路过的朋友、不知你们的感受是什么？如果可以、是否能写下来、记录这一时想法
