December 2002
Intermediate to advanced
928 pages
85h 29m
English
BLOCKRECOVER
BLOCKRECOVER [DEVICE TYPEdeviceSpecifier[,deviceSpecifier]...]blockSpec[blockSpec]... [blockOption[blockOption]...];blockSpec:= { DATAFILEdatafileSpecBLOCKinteger[,integer...] | TABLESPACEtablespace_nameDBAinteger[,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.
Specifies the block(s) that require recovery.
Specifies the data block address of a block to recover.
Recovers blocks that are listed in the dictionary views V$COPY_CORRUPTION and V$BACKUP_CORRUPTION.
Specifies that restoration should be from either a backup set or a datafile copy.
Specifies the backup set that needs to be restored and from which you want to perform block-level recovery.
Specifies that backup sets created before a given time are to be restored
Common keywords and clauses: datafileSpec, deviceSpecifier, tablespace_name, tag_name, until.