oracle并行更慢,为什么RMAN启用并行备份反而速度比常规备份更慢呢?_棘树的博客-程序员ITS301

技术标签: oracle并行更慢  

数据库版本 9.2.0.4 os rehat as 4.0

RMAN> configure device type disk clear;

old RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;

RMAN configuration parameters are successfully reset to default value

released channel: ORA_DISK_1

released channel: ORA_DISK_2

released channel: ORA_DISK_3

RMAN> backup database;

Starting backup at 2008-02-04 14:28:07

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=159 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/oracle/oradata/linux/system01.dbf

input datafile fno=00002 name=/u01/oracle/oradata/linux/undotbs01.dbf

input datafile fno=00003 name=/u01/oracle/oradata/linux/sysaux01.dbf

input datafile fno=00004 name=/u01/oracle/oradata/linux/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2008-02-04 14:28:07

channel ORA_DISK_1: finished piece 1 at 2008-02-04 14:28:43

piece handle=/u01/oracle/backup/full_LINUX_53_1_645805687 tag=TAG20080204T142807 comment=NONE

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 2008-02-04 14:28:46

channel ORA_DISK_1: finished piece 1 at 2008-02-04 14:28:47

piece handle=/u01/oracle/backup/full_LINUX_54_1_645805723 tag=TAG20080204T142807 comment=NONE

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

Finished backup at 2008-02-04 14:28:47

RMAN> show all;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

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

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/u01/oracle/backup/full_%d_%s_%p_%t';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/product/10.2/dbs/snapcf_linux.f'; # default

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

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

RMAN> backup

2> (datafile 1)

3> (datafile 2,3)

4> (datafile 4);

Starting backup at 2008-02-04 14:32:01

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=159 devtype=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: sid=141 devtype=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: sid=140 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/oracle/oradata/linux/system01.dbf

channel ORA_DISK_1: starting piece 1 at 2008-02-04 14:32:01

channel ORA_DISK_2: starting full datafile backupset

channel ORA_DISK_2: specifying datafile(s) in backupset

input datafile fno=00002 name=/u01/oracle/oradata/linux/undotbs01.dbf

channel ORA_DISK_2: starting piece 1 at 2008-02-04 14:32:02

channel ORA_DISK_3: starting full datafile backupset

channel ORA_DISK_3: specifying datafile(s) in backupset

input datafile fno=00003 name=/u01/oracle/oradata/linux/sysaux01.dbf

channel ORA_DISK_3: starting piece 1 at 2008-02-04 14:32:02

channel ORA_DISK_1: finished piece 1 at 2008-02-04 14:32:38

piece handle=/u01/oracle/backup/full_LINUX_55_1_645805921 tag=TAG20080204T143201 comment=NONE

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00004 name=/u01/oracle/oradata/linux/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2008-02-04 14:32:38

channel ORA_DISK_2: finished piece 1 at 2008-02-04 14:32:38

piece handle=/u01/oracle/backup/full_LINUX_56_1_645805922 tag=TAG20080204T143201 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:00:36

channel ORA_DISK_2: starting full datafile backupset

channel ORA_DISK_2: specifying datafile(s) in backupset

including current control file in backupset

channel ORA_DISK_2: starting piece 1 at 2008-02-04 14:32:41

channel ORA_DISK_3: finished piece 1 at 2008-02-04 14:32:41

piece handle=/u01/oracle/backup/full_LINUX_57_1_645805922 tag=TAG20080204T143201 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:00:39

channel ORA_DISK_3: starting full datafile backupset

channel ORA_DISK_3: specifying datafile(s) in backupset

channel ORA_DISK_1: finished piece 1 at 2008-02-04 14:32:41

piece handle=/u01/oracle/backup/full_LINUX_58_1_645805958 tag=TAG20080204T143201 comment=NONE

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

channel ORA_DISK_2: finished piece 1 at 2008-02-04 14:32:43

piece handle=/u01/oracle/backup/full_LINUX_59_1_645805958 tag=TAG20080204T143201 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:00:05

including current SPFILE in backupset

channel ORA_DISK_3: starting piece 1 at 2008-02-04 14:32:43

channel ORA_DISK_3: finished piece 1 at 2008-02-04 14:32:44

piece handle=/u01/oracle/backup/full_LINUX_60_1_645805961 tag=TAG20080204T143201 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:00:03

Finished backup at 2008-02-04 14:32:44

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/weixin_33946999/article/details/116478446

智能推荐

error while loading shared libraries: xxx.so.x"错误的原因和解决办法_七分熟的博客-程序员ITS301

error while loading shared libraries: xxx.so.x"错误的原因和解决办法 2012-06-28 10:05:06分类: LINUX一般我们在Linux下执行某些外部程序的时候可能会提示找不到共享库的错误, 比如:tmux: error while loading shared librarie

python中实现输入指定日期,判断输入日期这一天是星期几_英楠的uu的博客-程序员ITS301_python输入日期代码

代码实现思路:1.自定义函数,用来实现switch/case语句2.使用python内置函数来获取指定日期是星期几输入指定日期,计算这一天是星期几代码实现如下:from datetime import datetime#利用num_to_string函数返回中文“星期几”def num_to_string(num): numbers={ 0:"星期日", 1:"星期一", 2:"星期二", 3:"星期三",

Timer实现指定整点时间触发、指定间隔触发_赵保军的博客-程序员ITS301_timer 整点

需求:每分钟循环一次,必须在00秒触发!两个Timer实现:timer用来计算距离第一个00秒 的差值 timer只触发一次 autoreset=false;timer用来60秒一循环namespace ConsoleApplication1{ class Program { private static System.Timers.T

thinkphp3.2 mysql_ThinkPHP3.2 扩展_金属铬的博客-程序员ITS301

之前写到TP3.1的行为扩展是tag();在TP3.2中引入了另一种说法—:钩子。 我们来看一下TP3.2中的钩子这个东西: 一:文件流程: 1:/index.php - require './ThinkPHP/ThinkPHP.php'; 2:/ThinkPHP/ThinkPHP.php—- require CORE_PATH.'Think'.EXT; Think\Think:之前写到TP3.1...

golang 运行go的gin框架_一只勤奋的代码狗的博客-程序员ITS301_go1.14 gin

首先安装go环境,官网下载,可以下载最新版,也可以选择稳定版本golang1.14安装完毕之后安装golang2020.1.4百度网盘地址链接:https://pan.baidu.com/s/1Wo_fSQEDVxp5KimNfKfnBg提取码:dxid创建一个项目文件夹D:\goworkspace然后下面分别创建bin、pkg、src三个文件夹其中,bin存放编译后的可执行文件;pkg存放编译后的包文件;src存放项目源文件。一般,bin和pkg目录可以不创建,go命令会自动创建(..

随便推点

composer Failed to decode response: zlib_decode(): data error 问题解决_瓜而不皮的博客-程序员ITS301

首先用 composer diagnose 命令诊断下问题然后他告诉我Checking composer version: WARNINGYou are not running the latest stable version, run `composer self-update` to update (1.7.2 => 1.9.0)所以,我执行了下 composer s...

JDK新特性-----注解@ (@Override、@Deprecated、@SuppressWarings)_sophia__yu的博客-程序员ITS301

注解—@Override 准确覆写为什么会有@Override?如果子类Student需要覆写父类Object的toString方法: class Student{ public String tostring() //希望覆写toString,但是并没有报错 { return "学生好好学习"; }}public class Annota...

cp -f 失效, alias_同叔练级之路的博客-程序员ITS301

如果系统设置了alias cp=‘cp -i’,用到cp时发现目录覆盖总有提示,找了半天,终于找到:可以采用以下方法:unalias cp; cp src dest/bin/cp src dest‘cp’ src dest\cp src dest 指定本次cp命令不使用alias (比较常用)一般设置 alias 的地方在/etc/bashrc...

scp命令的使用之指定对端端口_风去沙来的博客-程序员ITS301_scp 指定端口

/*********************************************************************Author : SamsonDate : 12/01/2021Test platform:Debian GNU/Linux 9*******************************************************************/scp也是使用的基于openssh的数据传输,ssh一般默认都是使用的22端口号,但有

[转]Aptana Studio 3配置Python开发环境图文教程_weixin_30668887的博客-程序员ITS301

转载URL:http://www.cr173.com/html/49260_1.html一、安装Aptana Studio 3安装完运行时建议将相关默认工作目录设定在英文的某个目录下。避免可能出现的不兼容问题(部分功能不可用或工作异常)二、安装Pydev1.安装Pydev提供了两种方法:下载Zip文件进行本地安装的方法和联机更新获取新功能的方法。我使用的是后者。这种方法可以随时保持...

魔域mysql下载,帮我看看 这句SQL语句,比较无语_黄业文的博客-程序员ITS301

帮我看看这句SQL语句,比较无语0这是sql代码:CREATE TABLE IF NOT EXISTS $table[lysx_votesms_xm] (`xs_id` int(8) NOT NULL AUTO_INCREMENT,`xs_name` varchar(255) ,`xs_num` int(10),`xs_pic`varchar(255),`xs_count` int(10),`x...

推荐文章

热门文章

相关标签