How to Configure RMAN I/O Block Size to Improve Backup and Recovery Performance [ID 107213.1]

本文提供了一种解决方案,用于调整RMAN I/O块大小以提高备份和恢复性能。对于大型数据库,适当调整块大小可以显著提升性能。

How to Configure RMAN I/O Block Size to Improve Backup and Recovery Performance [ID 107213.1]


Modified19-OCT-2010TypeBULLETINStatusPUBLISHED

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

This article describes a solution that was used to resolve this

issue for another Oracle customer. As it relates to a third-party

product, Oracle does not guarantee that this resolution will work

for all customers using this or any other third-party product. The

appropriate third-party vendor should be contacted if there are any

questions or problems relating to this resolution or these errors.

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

PURPOSE

This document is to show how to configure rman i/o block size to improve

backup/recover performance.

SCOPE & APPLICATION

This is intended for all RMAN users.

How to configure RMAN I/O block size to improve backup/recover performance:

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

The I/O block size is the 'unit' RMAN reads and writes to the tape device.

Larger block size can improve backup/recover performance, especially

if the the database is large.

The default I/O block size is operating system and third party backup software

dependent, but can be changed from within RMAN. Use the allocate channel step:

ALLOCATE CHANNEL t1 TYPE 'sbt_tape' PARMS ="BLKSIZE=4194304"

This will allocate a channel for backup/recover with I/O block size 4M.

I/O block size can also be specified from EBU: use parameter tape_io_size in

backup/recover script.

References:

===========

Oracle8i Backup and Recovery Guide

Search Words:

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

BLKSIZE RMAN TAPE_IO_SIZE

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



评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值