RMAN Restore database slow/How to Improve RMAN restore performance [ID 467694.1]

Source: Internet
Author: User

RMAN Restore database slow/How to Improve RMAN restore performance [ID 467694.1]

 

Modified10-jun-2010TypeHowtoStatusModerated

 

In this document
Goal
Solution

Platforms: 1-914cu;

This document is being delivered to you via Oracle Support's rapid visibility (RAV) process and therefore has not been subject to an independent technical review.

Applies:

Oracle Server-Enterprise Edition-version: 10.1.0.2 to 10.2.0.4-release: 10.1 to 10.2
Information in this document applies to any platform.

Goal

RMAN Restore database is slow. Backup to tape takes 13 hours and the restore takes over 26hrs.

Solution

Things to check/configure when RMAN restore from tape is slow:

+ The number of channels to be allocated shoshould be equal to the number of physical tape drives.

+ Set parallelmediarestore off and run the restore:

Example:
RMAN> set parallelmediarestore off;
RMAN> run {
Allocate channel to tape...
.
.
Restore database;
Recover database;
}

+ If large pool is not configured then configure the large pool size and enable the backup_tape_io_slaves:
Large_pool_size = 100 m
Backup_tape_io_slaves = true

By setting the above parameters the restore time when CED from 26 hours to 13 hours.

 

 

 

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

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

Online Resources: http://tianlesoftware.download.csdn.net

Video: http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

Dba1 group: 62697716 (full); dba2 group: 62697977 (full)

Dba3 group: 62697850 super DBA group: 63306533;

Chat group: 40132017

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.