Name

BLOCKRECOVER (Oracle9i only)

Synopsis

This command allows for a fine-grained level of recovery by specifying a small list of corrupt blocks rather than an entire datafile.

Syntax

BLOCKRECOVER 
[DEVICE TYPE deviceSpecifier [, deviceSpecifier]...] 
blockSpec [blockSpec]... [blockOption [blockOption]...];

blockSpec := 
{ DATAFILE datafileSpec BLOCK integer [, integer ...] 
| TABLESPACE tablespace_name DBA integer [, integer ...] 
| CORRUPTION LIST
}

blockOption :=
{ FROM { BACKUPSET | DATAFILECOPY }
| FROM TAG [=] [']tag_name[']
| RESTORE untilClause
}

Keywords

BLOCK integer

Specifies the block(s) that requires recovery

DBA

Specifies the data block address of a block to recover

CORRUPTION LIST

Recovers those blocks that are listed in the dictionary views V$COPY_CORRUPTION and V$BACKUP_CORRUPTION

FROM

Specifies that restoration should be either from a backup set or a datafile copy

FROM TAG tag_name

Specifies the backup set that needs to be restored, and from which you want to perform block level recovery

RESTORE untilClause

Specifies that backup sets created before a given time are to be restored

Get Oracle RMAN Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial