`
sjk2013
  • 浏览: 2177115 次
文章分类
社区版块
存档分类
最新评论

RMAN 增量备份 的 对象测试

 
阅读更多

在练习 RMAN Incremental Backup 时、参照 OCP TK 042 :


对于 RMAN 增量备份的对象、官网摘入如下:

You can make incremental backups of databases, individual tablespaces or datafiles.

显然、基于96 题的答案、archive log 不在列位、偶撞了南墙也想测试呀


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


竟然成功!!答案错了??!!

未必、、、

因为答案是基于业务规则而非语义语法

对归档日志进行增量备份那就应了那句谚语--脱裤子放屁哈

生活中、很多事情的对错是基于"人情世故"的、
原本你的做法完全正确、但你没有按照"潜规则行事"、那么你就错了、
所以、不要太在意对错、因为那原本就没有定义、


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics