Oracle RMAN备份结果类型及备份片大小

备份类型、备份片大小

备份集、映像备份、压缩备份

默认：备份集

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

tag 给备份取别名，加一个标签

RMAN> backup datafile 4  tag='backupset';

查看

RMAN> list backup of datafile 4 ;     #看备份集

或者 

RMAN> list backup tag='BACKUPSET';

List of Backup Sets

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

5       Full    3.98M      DISK        00:00:02     31-AUG-17

        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: BACKUPSET

        Piece Name: +FRA/orcl/backupset/2017_08_31/nnndf0_mbackupset_0.263.848260059

  List of Datafiles in backup set 5

  File LV Type Ckp SCN    Ckp Time  Name

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

  4       Full 1195103    31-AUG-17 +DATA/orcl/datafile/users.259.848188223

1

改为映像备份

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COPY;

RMAN> backup datafile 4  tag='copy';

RMAN>  list backup of datafile 4 ;    #没有结果

RMAN>  list copy  tag='COPY';

或者

RMAN>  list copy of datafile 4 ;

specification does not match any control file copy in the repository

specification does not match any archived log in the repository List of Datafile Copies

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

Key     File S Completion Time Ckp SCN    Ckp Time

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

2       4    A 31-AUG-17       3758614    31-AUG-17

        Name: +FRA/orcl/datafile/users.264.853094395

        Tag: COPY

2

改为压缩备份集

先查出没压缩的备份集的大小

RMAN> list backup of datafile 4 ; 结果备份集

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

8       Full    51.13M  没压缩的大小    DISK        00:00:08     16-JUL-14

        BP Key: 8   Status: AVAILABLE  Compressed: NO 没有  Tag: BACKUPSET

        Piece Name: +FRA/orcl/backupset/2017_08_31/nnndf0_backupset_0.263.853094301

  List of Datafiles in backup set 8

  File LV Type Ckp SCN    Ckp Time  Name

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

  4     Full 3758449    31-AUG-17 +DATA/orcl/datafile/users.259.853023133

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO compressed backupset;

执行备份命令

backup datafile 4 tag='icompreed';

RMAN> list backup tag='icompreed';

List of Backup Sets

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

9       Full    8.23M  压缩后的大小    DISK        00:00:04     16-JUL-14

        BP Key: 9   Status: AVAILABLE  Compressed: YES 是压缩 Tag: ICOMPREED

        Piece Name: +FRA/orcl/backupset/2017_08_31/nnndf0_icompreed_0.265.853094573

  List of Datafiles in backup set 9

  File LV Type Ckp SCN    Ckp Time  Name

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

  4     Full 3758841    31-AUG-17 +DATA/orcl/datafile/users.259.853023133

还原为默认配置

CONFIGURE DEVICE TYPE DISK clear;

可以在备份的时候指定用备份类型：

backup as backupset datafile 4 ;    #备份集

backup as copy datafile 4 fromat '/u01/app/oracle/backup/4copy' ;    #映像备份

backup as compressed backupset datafile 4 ;    #压缩备份集

3

单个备份文件的最大大小

各种操作系统能识别保存最大文件大小。

规定每个备份文件不能超过3G，假如备份可能有10G，就得生成4个备份片。

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 3G;

例：设置备份片大小为2M，对数据文件4做备份

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2M;

在备份的时候如果分片， 最好打个标签：

RMAN> backup as backupset datafile 4 tag='max'; 

Starting backup at 31-AUG-17

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=56 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00004 name=+DATA/orcl/datafile/users.259.822001327

channel ORA_DISK_1: starting piece 1 at 31-AUG-17

channel ORA_DISK_1: finished piece 1 at 31-AUG-17

piece handle=+FRA/orcl/backupset/2017_08_31/nnndf0_max_0.266.822024825 tag=MAX comment=NONE

channel ORA_DISK_1: starting piece 2 at 31-AUG-17

channel ORA_DISK_1: finished piece 2 at 31-AUG-17

piece handle=+FRA/orcl/backupset/2017_08_31/nnndf0_max_0.267.822024825 tag=MAX comment=NONE

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

Finished backup at 31-AUG-17

RMAN> list backup tag='MAX';

List of Backup Sets

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

8       Full    3.30M      DISK        00:00:02     31-AUG-17

  List of Datafiles in backup set 8

  File LV Type Ckp SCN    Ckp Time  Name

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

  4       Full 1092192    31-AUG-17 +DATA/orcl/datafile/users.259.822001327

  Backup Set Copy #1 of backup set 8

  Device Type Elapsed Time Completion Time Compressed Tag

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

  DISK        00:00:02     31-AUG-17       NO         MAX

    List of Backup Pieces for backup set 8 Copy #1

    BP Key  Pc# Status      Piece Name

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

    8       1   AVAILABLE   +FRA/orcl/backupset/2017_08_31/nnndf0_max_0.266.822024825

    9       2   AVAILABLE   +FRA/orcl/backupset/2017_08_31/nnndf0_max_0.267.822024825