下面的语句是在没有全备(也就是增量备份的0级备份)的情况下执行,考虑下,会出现什么结果
先简单说下增量备份,增量备份是根据块变化来的(如果启用块跟踪的话: v$block_change_tracking)分为两种,一种是差异增量备份,每次增量备份是根据上一次增量备份的基础上进行备份,另一种是累计增量备份,是在全备的基础上进行增量备份。 附:启用块跟踪: alter database enable block change tracking;
下面贴出没有增量备份0级备份的情况进行1级增量备份输出情况
点击(此处)折叠或打开
- run {
- allocate channel t1 type disk;
- allocate channel t2 type disk;
- sql 'alter system archive log current';
- sql 'alter system archive log current';
- backup incremental level 1 cumulative filesperset 10 format '/backup/rman/test_incr_%T_%s_%p' database
- include current controlfile spfile plus archivelog delete all input;
- release channel t1;
- release channel t2;
- }
先简单说下增量备份,增量备份是根据块变化来的(如果启用块跟踪的话: v$block_change_tracking)分为两种,一种是差异增量备份,每次增量备份是根据上一次增量备份的基础上进行备份,另一种是累计增量备份,是在全备的基础上进行增量备份。 附:启用块跟踪: alter database enable block change tracking;
下面贴出没有增量备份0级备份的情况进行1级增量备份输出情况
点击(此处)折叠或打开
- ……………………
-
- allocated channel: t2
- channel t2: SID=22 device type=DISK
-
- sql statement: alter system archive log current
-
- sql statement: alter system archive log current
-
-
- Starting backup at 08-JUN-17
- current log archived
- channel t1: starting archived log backup set
- channel t1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=1 RECID=1 STAMP=946129604
- channel t1: starting piece 1 at 08-JUN-17
- channel t2: starting archived log backup set
- channel t2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=2 RECID=2 STAMP=946129614
- input archived log thread=1 sequence=3 RECID=3 STAMP=946130655
- input archived log thread=1 sequence=4 RECID=4 STAMP=946130703
- input archived log thread=1 sequence=5 RECID=5 STAMP=946130801
- channel t2: starting piece 1 at 08-JUN-17
- channel t2: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_2_1 tag=TAG20170608T140646 comment=NONE
- channel t2: backup set complete, elapsed time: 00:00:01
- channel t2: deleting archived log(s)
- archived log file name=/backup/archivelog/1_2_946047723.dbf RECID=2 STAMP=946129614
- archived log file name=/backup/archivelog/1_3_946047723.dbf RECID=3 STAMP=946130655
- archived log file name=/backup/archivelog/1_4_946047723.dbf RECID=4 STAMP=946130703
- archived log file name=/backup/archivelog/1_5_946047723.dbf RECID=5 STAMP=946130801
- channel t2: starting archived log backup set
- channel t2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=6 RECID=6 STAMP
-
- ………………………………
- channel t1: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_1_1 tag=TAG20170608T140646 comment=NONE
- channel t1: backup set complete, elapsed time: 00:00:05
- channel t1: deleting archived log(s)
- archived log file name=/backup/archivelog/1_1_946047723.dbf RECID=1 STAMP=946129604
- Finished backup at 08-JUN-17
-
- Starting backup at 08-JUN-17
- no parent backup or copy of datafile 5 found ---没有0级备份,下面开始0级备份
- no parent backup or copy of datafile 4 found
- no parent backup or copy of datafile 2 found
- no parent backup or copy of datafile 1 found
- no parent backup or copy of datafile 3 found
- channel t1: starting incremental level 0 datafile backup set
- channel t1: specifying datafile(s) in backup set
- input datafile file number=00005 name=/oracle/app/oracle/oradata/mytestdb/example01.dbf
- input datafile file number=00004 name=/oracle/app/oracle/oradata/mytestdb/users01.dbf
- input datafile file number=00002 name=/oracle/app/oracle/oradata/mytestdb/sysaux01.dbf
- channel t1: starting piece 1 at 08-JUN-17
- channel t2: starting incremental level 0 datafile backup set
- channel t2: specifying datafile(s) in backup set
- input datafile file number=00001 name=/oracle/app/oracle/oradata/mytestdb/system01.dbf
- input datafile file number=00003 name=/oracle/app/oracle/oradata/mytestdb/undotbs01.dbf
- channel t2: starting piece 1 at 08-JUN-17
- channel t1: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_4_1 tag=TAG20170608T140651 comment=NONE
- channel t1: backup set complete, elapsed time: 00:00:15
- channel t1: starting incremental level 1 datafile backup set
- channel t1: specifying datafile(s) in backup set
- channel t2: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_5_1 tag=TAG20170608T140651 comment=NONE
- channel t2: backup set complete, elapsed time: 00:00:15
- channel t2: starting incremental level 1 datafile backup set
- channel t2: specifying datafile(s) in backup set
- including current SPFILE in backup set
- channel t2: starting piece 1 at 08-JUN-17
- including current control file in backup set
- channel t1: starting piece 1 at 08-JUN-17
- channel t2: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_7_1 tag=TAG20170608T140651 comment=NONE
- channel t2: backup set complete, elapsed time: 00:00:01
- channel t2: starting incremental level 1 datafile backup set
- channel t2: specifying datafile(s) in backup set
- including current SPFILE in backup set
- channel t2: starting piece 1 at 08-JUN-17
- channel t1: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_6_1 tag=TAG20170608T140651 comment=NONE
- channel t1: backup set complete, elapsed time: 00:00:00
- channel t2: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_8_1 tag=TAG20170608T140651 comment=NONE
- channel t2: backup set complete, elapsed time: 00:00:01
- Finished backup at 08-JUN-17
-
- Starting backup at 08-JUN-17
- current log archived
- channel t1: starting archived log backup set
- channel t1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=8 RECID=8 STAMP=946130829
- channel t1: starting piece 1 at 08-JUN-17
- channel t1: finished piece 1 at 08-JUN-17
- piece handle=/backup/rman/test_incr_20170608_9_1 tag=TAG20170608T140709 comment=NONE
- channel t1: backup set complete, elapsed time: 00:00:01
- channel t1: deleting archived log(s)
- archived log file name=/backup/archivelog/1_8_946047723.dbf RECID=8 STAMP=946130829
- Finished backup at 08-JUN-17
-
- released channel: t1
-
- released channel: t2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29487349/viewspace-2140442/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29487349/viewspace-2140442/