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