ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN提高备份速度

RMAN提高备份速度

原创 Linux操作系统 作者:oracle_db 时间:2012-04-21 17:24:31 0 删除 编辑
RMAN提供了一个参数来控制并发,并发可用来加速备份速度


RMAN> configure device type disk parallelism 3 backup type to backupset;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3

RMAN> backup database format '/backup/rmanbackup/p3_%U';

Starting backup at 21-APR-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=142 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=135 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/oradata/dbtest/system01.dbf
input datafile fno=00004 name=/u01/oradata/dbtest/users01.dbf
channel ORA_DISK_1: starting piece 1 at 21-APR-12
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=/u01/oradata/dbtest/sysaux01.dbf
input datafile fno=00007 name=/u01/oradata/dbtest/wenchuan01.dbf
input datafile fno=00008 name=/u01/oradata/dbtest/wenchuan2.dbf
channel ORA_DISK_2: starting piece 1 at 21-APR-12
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00005 name=/u01/oradata/dbtest/example01.dbf
input datafile fno=00002 name=/u01/oradata/dbtest/undotbs01.dbf
input datafile fno=00006 name=/u01/oradata/dbtest/paul01.dbf
channel ORA_DISK_3: starting piece 1 at 21-APR-12
channel ORA_DISK_1: finished piece 1 at 21-APR-12
piece handle=/backup/rmanbackup/p3_0un90fdf_1_1 tag=TAG20120421T172150 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 21-APR-12
channel ORA_DISK_1: finished piece 1 at 21-APR-12
piece handle=/backup/rmanbackup/p3_11n90fej_1_1 tag=TAG20120421T172150 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_3: finished piece 1 at 21-APR-12
piece handle=/backup/rmanbackup/p3_10n90fdf_1_1 tag=TAG20120421T172150 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:40
channel ORA_DISK_2: finished piece 1 at 21-APR-12
piece handle=/backup/rmanbackup/p3_0vn90fdf_1_1 tag=TAG20120421T172150 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:15
Finished backup at 21-APR-12

RMAN>               

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

请登录后发表评论 登录
全部评论

注册时间:2008-11-13

  • 博文量
    158
  • 访问量
    313940