`
hunxiejun
  • 浏览: 1137646 次
文章分类
社区版块
存档分类
最新评论

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

 
阅读更多

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


Modified 19-OCT-2010Type BULLETINStatus PUBLISHED

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

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

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

Blog http://blog.csdn.net/tianlesoftware

网上资源: http://tianlesoftware.download.csdn.net

相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群:62697716(); DBA2 群:62697977()

DBA3 群:62697850 DBA 超级群:63306533;

聊天 群:40132017

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

分享到:
评论

相关推荐

    Oracle.RMAN.11g.Backup.and.Recovery.2010(Oracle RMAN 11g 备份和恢复)

    Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate ...

    WDF构架下开发USB

    How to Configure a USB I/O Target 8 UMDF Example: Configure a USB I/O Target 8 KMDF Example: Configure a USB I/O Target 11 How to Send an I/O Request to a USB I/O Target 15 UMDF Example: Send a ...

    Administering VMware Site Recovery Manager 4.0.pdf

    Chapter 1: Introduction ....................................................................................... 7 Charitable Donation ....................................................................

    Prentice.Hall.Performance.Tuning.for.Linux.Servers

    and benchmarking Interpret performance data to analyze your Linux server's real-world behavior Optimize Linux system schedulers, memory, I/O, file systems, and networking Tune web, file, database, ...

    How to Configure User Status in mySAP SRM.pdf

    How to Configure User Status in mySAP SRM.pdf

    Swift.High.Performance.1785282204

    These will improve your code efficiency, enable you to analyse Swift code, and enhance performance. Next, the importance of building solid applications using multithreading concurrency and multi-core...

    HBase.High.Performance.Cookbook.epub

    Exciting projects that will teach you how complex data can be exploited to gain maximum insights About This Book Architect a good HBase cluster for a very large distributed system Get to grips with ...

    UE(官方下载)

    A question we often see is "I have a lot of blank lines in my file and I don't want to go through and manually delete them. Is there an easier way to do this?" The answer is: yes! Configure FTP Set up...

    How to configure ODBC DSN in Client to access DB2 for Windows.

    This article introduces how to configure ODBC DSN in Client to access remote DB2 for windows in detail. Then I give a sample how to access remote DB2 database with ODBC by DB Query Analyzer ...

    Learning Redis

    By working with real world scenarios pertaining to using Redis, you will discover sharding and indexing techniques, along with how to improve scalability and performance through persistent strategies...

    (053第4章)rman backup configure.pdf1

    (053第4章)rman backup configure1.查看所有rman 备份参数RMAN> show all;using target database

    Hana PA200 教材

    Unit 6: Backup and Recovery ........................................ 155 Concept of Backup and Recovery .................................157 Data Area Backup .............................................

    Oracle.Application.Express.Administration.For.DBAs.and.Developers.epub

    The book is also useful to administrators responsible for installation and upgrade, backup and recovery, and the ongoing monitoring of the APEX engine and the applications built upon it. Table of ...

    JBoss AS 5 Performance Tuning.pdf

    JBoss AS 5 Performance Tuning will teach you how to deliver fast applications on the JBoss Application Server and Apache Tomcat, giving you a decisive competitive advantage over your competitors. ...

    两天成为Oracle_DBA(PDF版)

    describes how to configure additional databases, and how to upgrade and older version of a database to the current version. Chapter 3, "Getting Started with Oracle Enterprise Manager" This chapter ...

    PostgreSQL.for.Data.Architects.1783288604

    Use indexes and rewrite queries to improve performance Install and use PostgreSQL extensions Learn how to leverage the command-line client (psql) In Detail PostgreSQL is an incredibly flexible and ...

    Wrox.Professional.Website.Performance.2013

    Explains how to configure front-end performance related to the web browser and how to speed up communication between server and browser Topics include MySQL tuning, NoSQL alternatives, CSS, JavaScript...

    KBA_180523214236_2__PMIC__PMI632_How_to_configure_.pdf

    KBA_180523214236_2__PMIC__PMI632_How_to_configure_.pdf

    Debugging with GDB --2007年

    2.1.3 Redirecting WDB input and output to a file . . . . . 2.2 Quitting GDB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.3 Shell commands . . . . . . . . . . . ....

Global site tag (gtag.js) - Google Analytics