Name
BLOCKRECOVER
Synopsis
BLOCKRECOVER [DEVICE TYPEdeviceSpecifier
[,deviceSpecifier
]...]blockSpec
[blockSpec
]... [blockOption
[blockOption
]...];blockSpec
:= { DATAFILEdatafileSpec
BLOCKinteger
[,integer
...] | TABLESPACEtablespace_name
DBAinteger
[,integer
...] | CORRUPTION LIST }blockOption
:= { FROM { BACKUPSET | DATAFILECOPY } | FROM TAG [=] [']tag_name
['] | RESTOREuntil
}
Allows for a fine-grained level of recovery by specifying a small list of corrupt blocks rather than an entire datafile. This option is available only for Oracle9i.
Keywords
- BLOCK integer
Specifies the block(s) that require recovery.
- DBA
Specifies the data block address of a block to recover.
- CORRUPTION LIST
Recovers blocks that are listed in the dictionary views V$COPY_CORRUPTION and V$BACKUP_CORRUPTION.
- FROM
Specifies that restoration should be from either 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 until
Specifies that backup sets created before a given time are to be restored
Common keywords and clauses: datafileSpec, deviceSpecifier, tablespace_name, tag_name, until.
Get Oracle in a Nutshell 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.