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 to:
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 databaseis 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 should 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 reduced from 26 hours to 13 hours.
------------------------------------------------------------------------------
分享到:
相关推荐
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 ...
1 Oracle Database 11g Backup and Recovery Architecture Tour . . . . . . . . . . . . . . 3 2 Introduction to the RMAN Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 ...
oracle 9i rman
rman backup and restore.
RMAN学习测试整理1 20121219 by Apollo 一、 Oracle数据库的备份分为物理备份和逻辑备份。今天测试整理下物理备份Rman,也就是oracle的恢复管理器(Recovery Manager)。 毕竟逻辑备份是不能实现时间点恢复的,所以...
【12c】12c RMAN新特性之通过网络远程恢复数据库(RESTORE_Recover from Service) new_ITPUB博客.mhtml
oracle rman深入学习研究的文章,很不错的
STEP Platform And Software Support 1 All Red Hat ...to utilize the STEP DB Server Toolbox, which includes scripts for e.g., Oracle RMAN backup and restore and Oracle Datapump export / import, etc.
Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the ...
自用oracle12.2.0.1控制台,绿色、便携。 注意:需要vc运行库:vcr2013-x64
Recovery Manager(RMAN)是一种用于备份(backup)、还原(restore)和恢复(recover) 数据库的Oracle 工具。RMAN只能用于ORACLE8或更高的版本中。它能够备份整个数据 库或数据库部件,如表空间、数据文件、控制文件、...
restore database until time "to_date('2019-08-19 08:49:00','yyyy-mm-dd hh24:mi:ss')"; recover database until time "to_date('2019-08-19 08:49:00','yyyy-mm-dd hh24:mi:ss')"; alter database open ...
RMAN的简要使用参考 Recovery Manager(RMAN)是一种用于备份(backup)、还原(restore)和恢复(recover)数据库的 Oracle 工具...
15:33:19: [restore_table] Trying to restore data to SYS.TRUNTAB1$$2 15:33:20: [restore_table] Expected Records in this round: 411 15:33:20: [restore_table] 411 records recovered 此处省略N行输出.....
rman是一种用于集备份(backup)、还原(restore)和恢复(recover)数据库于一体的Oracle 工具,支持命令行及图形界面操作 能够备份整个数据库、表空间、数据文件、控制文件、归档文件以及Spfile参数文件。 支持增量...
Oracle-使用RMAN-将-DB-从10g-直接-Restore-到11g-示例
注:①恢复的前提是已经做好备份②完全恢复数据库是数据库遇到故障,在恢复时候没有丢失任何已经提交事物数据的恢复不完全恢复...RMAN>restore database;RMAN>recover database;RMAn>sql ‘alter database open’;2
oracle 11.2.0.4异机还原升级到12c,然后再从non-pdb转成pdb整理详细文档。
# ora webplan 4019453623/1 2 using sql_id along with child number instead of hash value # ora webplan aca4xvmz0rzup/3 1 - hash_to_sqlid <sql_id> : get the sql_id of the cursor given its hash value...
rman 的真个恢复过程可以分成还原(restore) 和恢复(recover) restore一个是指物理上的还原或者拷贝 recover一个是指数据库一致性的恢复