ITPub博客

首页 > 数据库 > Oracle > RMAN 增量备份 的 对象测试

RMAN 增量备份 的 对象测试

原创 Oracle 作者:幕南风 时间:2014-07-03 13:52:34 0 删除 编辑

       在练习 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


       竟然成功!!答案错了??!!
       
       未必、、、
       
       因为答案是基于业务规则而非语义语法
       
       对归档日志进行增量备份那就应了那句谚语--脱裤子放屁哈
       
       生活中、很多事情的对错是基于"人情世故"的、
       原本你的做法完全正确、但你没有按照"潜规则行事"、那么你就错了、
       所以、不要太在意对错、因为那原本就没有定义、
       
       

<!-- Baidu Button BEGIN -->

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

上一篇: 【Oracle Log file 恢复】 已归档、非当前的 Redo LogFile 损坏
下一篇: 【人在运维囧途_04】 逃离故障的十条运维工作经验总结
请登录后发表评论 登录
全部评论
腾讯数据库工程师

注册时间:2012-05-10

最新文章