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 explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate ...
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 ...
Chapter 1: Introduction ....................................................................................... 7 Charitable Donation ....................................................................
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
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...
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 ...
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...
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 ...
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 configure1.查看所有rman 备份参数RMAN> show all;using target database
Unit 6: Backup and Recovery ........................................ 155 Concept of Backup and Recovery .................................157 Data Area Backup .............................................
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 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. ...
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 ...
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 ...
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
2.1.3 Redirecting WDB input and output to a file . . . . . 2.2 Quitting GDB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.3 Shell commands . . . . . . . . . . . ....