关于Block Media Recovery
来源:互联网 发布:阿里云 怎么注销 编辑:程序博客网 时间:2024/05/16 14:56
文档地址:http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmconc2.htm#i1008221
Block Media Recovery with RMAN
Although datafile media recovery is the principal formof recovery, you can also use the RMANBLOCKRECOVER
command to performblock media recovery. Block mediarecovery recovers an individual corrupt datablock or set ofdatablocks within a datafile. In cases when a small number ofblocks require media recovery, you can selectively restore andrecover damaged blocks rather than whole datafiles.
Block media recovery provides several advantages over datafilemedia recovery. For example, block media recovery
Lowers the Mean Time to Recovery (MTTR) because onlyblocks needing recovery are restored and only necessary corruptblocks undergo recovery. Block media recovery minimizes redoapplication time and avoids I/O overhead during recovery.
Allows affected datafiles to remain online during recovery ofthe blocks. Without block-level recovery, if even a single block iscorrupt, then you must restore a backup of the entire datafile andapply all redo generated for that file after the backup wascreated.
Note these restrictions of block media recovery:
You can only perform block media recovery with RMAN. No SQL*Plusrecovery interface is available.
You can only perform complete recovery of individual blocks. Inother words, you cannot stop recovery before all redo has beenapplied to the block.
You can only recover blocks marked media corrupt. The
V$DATABASE_BLOCK_CORRUPTION
view indicates whichblocks in a file were marked corrupt since the most recentBACKUP
orBACKUP
...
VALIDATE
command was run against the file.You must have a full RMAN backup. Incremental backupsare not used by block media recovery. Proxy backups are also notused by block media recovery. Only full backups and archived logfiles are used.
Block media recovery is able to restore blocks from parentincarnation backups and recover the corrupted blocks through a
RESETLOGS
.Blocks that are marked media corrupt are not accessible to usersuntil recovery is complete. Any attempt to use a block undergoingmedia recovery results in an error message indicating that theblock is media corrupt.
Using BACKUP... VALIDATE
Using the RMAN BACKUP... VALIDATE command causes RMAN to readall of the specified database files that would be input for aspecific backup task, without actually producing any backups asoutput. For example, BACKUP DATABASE VALIDATE causes RMAN to readall files that would be backed up in backing up the entire databaseand ensure that they are intact and not corrupted. All of the datablocks in the input files are validated, exactly as they are when areal backup takes place. This process can provide a usefulintegrity check for your database.
- 关于Block Media Recovery
- BMR(Block Media Recovery)
- block media recovery
- Block media recovery BMR OCP-043
- 12c pdb下的 ABMR测试 Automatic Block Media Recovery by Active Data Guard
- media&instance-recovery
- Crash Recovery 和 Media Recovery 的区别
- Crash Recovery 和 Media Recovery 的区别
- Oracle instance & media recovery structure
- 关于@media
- 数据库修复【block corruption recovery】
- HDFS Block Recovery过程简述
- the different between crash recovery and media recovery
- ORA-01113: file 2 needs media recovery
- ORA-01113: file 7 needs media recovery
- ORA-01113: file 7 needs media recovery
- ORA-01113: file 1 needs media recovery
- Namenode做block Recovery过程详细剖析
- 关于程序包:DBMS_RESOURCE_MANAGE…
- About Opening with the RESETLOGS Option
- Oracle工具——DBVERIFY
- rman备份出现ORA-19625
- TSPITR 基于表空间时间点恢复
- 关于Block Media Recovery
- oracle 重做日志组的三种状态:current,active,inactive
- 索引组织表中的MAPPING TABLE
- 索引组织表与簇---来自互联网
- 关于视图:V$OBJECT_USAGE
- 关于重构索引--index rebuild的OCP 题
- oracle 10g中ASM概念以及管理---转置互联网
- Managing Alias Names for ASM Filenames
- DB_CREATE_ONLINE_LOG_DEST_n