Backup And Recovery User's Guide-RMAN备份概念-增量备份-累积增量备份-练习

--对表空间users进行0级增量备份

RMAN> backup incremental level 0 tablespace users;

 

Starting backup at 2013-08-14 03:11:02

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental level 0 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00008 name=/oradata/users02.dbf

input datafile file number=00004 name=/oradata/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2013-08-14 03:11:02

channel ORA_DISK_1: finished piece 1 at 2013-08-14 03:11:03

piece handle=/pooldisk02/backup03/0roh88u6_1_1 tag=TAG20130814T031102 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2013-08-14 03:11:04

 

Starting Control File and SPFILE Autobackup at 2013-08-14 03:11:04

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823403464_90pgwrgd_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2013-08-14 03:11:07

 

RMAN> list backup;

 

 

List of Backup Sets

===================

 

 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   

------- ---- -- ---------- ----------- ------------ -------------------

23      Incr 0  5.23M      DISK        00:00:01     2013-08-14 03:11:03

        BP Key: 23   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T031102

        Piece Name: /pooldisk02/backup03/0roh88u6_1_1

  List of Datafiles in backup set 23

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  4    0  Incr 2637187    2013-08-14 03:11:02 /oradata/users01.dbf

  8    0  Incr 2637187    2013-08-14 03:11:02 /oradata/users02.dbf

 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   

------- ---- -- ---------- ----------- ------------ -------------------

24      Full    9.67M      DISK        00:00:01     2013-08-14 03:11:05

        BP Key: 24   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T031104

        Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823403464_90pgwrgd_.bkp

  SPFILE Included: Modification time: 2013-08-13 17:17:52

  SPFILE db_unique_name: TESTDB11

  Control File Included: Ckp SCN: 2637193      Ckp time: 2013-08-14 03:11:04

 

--users表空间 进行一个level 2的差异增量备份

RMAN> backup incremental level 2 tablespace users;

 

Starting backup at 2013-08-14 03:12:48

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental level 2 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00008 name=/oradata/users02.dbf

input datafile file number=00004 name=/oradata/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2013-08-14 03:12:48

channel ORA_DISK_1: finished piece 1 at 2013-08-14 03:12:49

piece handle=/pooldisk02/backup03/0toh891g_1_1 tag=TAG20130814T031248 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2013-08-14 03:12:49

 

Starting Control File and SPFILE Autobackup at 2013-08-14 03:12:49

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823403569_90ph023y_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2013-08-14 03:12:52

 

RMAN> list backup of tablespace users;

 

 

List of Backup Sets

===================

 

 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   

------- ---- -- ---------- ----------- ------------ -------------------

23      Incr 0  5.23M      DISK        00:00:01     2013-08-14 03:11:03

        BP Key: 23   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T031102

        Piece Name: /pooldisk02/backup03/0roh88u6_1_1

  List of Datafiles in backup set 23

  File LV Type Ckp SCN    Ckp Time

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

转载于:http://blog.itpub.net/17013648/viewspace-1084159/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值