rman multisection backup试验之二

最新推荐文章于 2023-12-23 11:47:01 发布
msdnchina
最新推荐文章于 2023-12-23 11:47:01 发布
阅读量2k
点赞数
CC 4.0 BY-SA版权
文章标签： rman multisection ba
本文链接：https://blog.youkuaiyun.com/msdnchina/article/details/43915415
Oracle DB 专栏收录该内容
772 篇文章
订阅专栏
2个通道中使用section size进行备份。
[oracle@rhel63single ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Feb 19 01:07:28 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST (DBID=2106028980)

RMAN> RUN
2> {
3>   ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/u02/disk1/%U';
4>   ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/u02/disk2/%U';
5>   backup section size 300m datafile 1;
6> } 

released channel: ORA_DISK_1
allocated channel: disk1
channel disk1: SID=133 device type=DISK

allocated channel: disk2
channel disk2: SID=70 device type=DISK

Starting backup at 19-FEB-15
channel disk1: starting full datafile backup set
channel disk1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf---->system01.dbf
backing up blocks 1 through 38400-------------------------------------------------->注意此处
channel disk1: starting piece 1 at 19-FEB-15
channel disk2: starting full datafile backup set
channel disk2: specifying datafile(s) in backup set
including current control file in backup set--------------------------------------->控制文件的备份
channel disk2: starting piece 1 at 19-FEB-15
channel disk2: finished piece 1 at 19-FEB-15
piece handle=/u02/disk2/0bpvkm86_1_1 tag=TAG20150219T024005 comment=NONE----------->控制文件的备份生成完毕（从下面的list backup of controlfile看出来的）,不过仅仅根据上面的输出log来判断，还真判断不出来是控制文件的备份。
channel disk2: backup set complete, elapsed time: 00:00:07
channel disk2: starting full datafile backup set
channel disk2: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf
backing up blocks 38401 through 76800---------------------------------------------->注意此处，以下简称第一个section
channel disk2: starting piece 2 at 19-FEB-15
channel disk1: finished piece 1 at 19-FEB-15
piece handle=/u02/disk1/0apvkm85_1_1 tag=TAG20150219T024005 comment=NONE----------->第一个section的backuppiece 生成完毕
channel disk1: backup set complete, elapsed time: 00:00:29
channel disk1: starting full datafile backup set
channel disk1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf
backing up blocks 76801 through 102400---------------------------------------------->注意此处，以下简称第二个section
channel disk1: starting piece 3 at 19-FEB-15
channel disk2: finished piece 2 at 19-FEB-15
piece handle=/u02/disk2/0apvkm85_2_1 tag=TAG20150219T024005 comment=NONE----------->第二个section的backuppiece 生成完毕
channel disk2: backup set complete, elapsed time: 00:00:47
channel disk2: starting full datafile backup set
channel disk2: specifying datafile(s) in backup set
including current SPFILE in backup set
channel disk2: starting piece 1 at 19-FEB-15
channel disk1: finished piece 3 at 19-FEB-15
piece handle=/u02/disk1/0apvkm85_3_1 tag=TAG20150219T024005 comment=NONE----------->第三个section的backuppiece 生成完毕
channel disk1: backup set complete, elapsed time: 00:00:35
channel disk2: finished piece 1 at 19-FEB-15
piece handle=/u02/disk2/0epvkmak_1_1 tag=TAG20150219T024005 comment=NONE-----------> spfile的备份（从下面的list backup of spfile看出来的）
channel disk2: backup set complete, elapsed time: 00:00:01
Finished backup at 19-FEB-15
released channel: disk1
released channel: disk2

RMAN> list backup of spfile;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    9.36M      DISK        00:00:04     19-FEB-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20150219T011148
        Piece Name: /u02/09pvkh4o_1_1
  SPFILE Included: Modification time: 19-FEB-15
  SPFILE db_unique_name: TEST

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    80.00K     DISK        00:00:01     19-FEB-15      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20150219T024005
        Piece Name: /u02/disk2/0epvkmak_1_1
  SPFILE Included: Modification time: 19-FEB-15
  SPFILE db_unique_name: TEST

RMAN> list backup of controlfile;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    9.36M      DISK        00:00:04     19-FEB-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20150219T011148
        Piece Name: /u02/09pvkh4o_1_1
  Control File Included: Ckp SCN: 3198153      Ckp time: 19-FEB-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    9.33M      DISK        00:00:06     19-FEB-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150219T024005
        Piece Name: /u02/disk2/0bpvkm86_1_1
  Control File Included: Ckp SCN: 3201429      Ckp time: 19-FEB-15

RMAN> 


RMAN> list backup of datafile 1;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    703.80M    DISK        00:00:59     19-FEB-15      
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 3198130    19-FEB-15 /u01/app/oracle/oradata/test/system01.dbf

  Backup Set Copy #1 of backup set 1
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:59     19-FEB-15       NO         TAG20150219T011148

    List of Backup Pieces for backup set 1 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    1       1   AVAILABLE   /u02/06pvkh2l_1_1
    2       2   AVAILABLE   /u02/06pvkh2l_2_1
    3       3   AVAILABLE   /u02/06pvkh2l_3_1

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    703.77M    DISK        00:01:19     19-FEB-15      
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 3201428    19-FEB-15 /u01/app/oracle/oradata/test/system01.dbf

  Backup Set Copy #1 of backup set 4
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:19     19-FEB-15       NO         TAG20150219T024005

    List of Backup Pieces for backup set 4 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    6       1   AVAILABLE   /u02/disk1/0apvkm85_1_1
    7       2   AVAILABLE   /u02/disk2/0apvkm85_2_1
    8       3   AVAILABLE   /u02/disk1/0apvkm85_3_1

RMAN>