TORBA—Define the Log RBA to Use

The TORBA keyword specifies the log RBA to which the tablespace is to be recovered.
cafrdb2
The TORBA keyword specifies the log RBA to which the tablespace is recovered. Use TORBA to make a partial recovery. A good point for partial recovery is the RBA of a quiesce point.
Review the following considerations:
  • Use TORBA with care. Data resulting from a partial recovery might be inconsistent.
  • TORBA is not supported with REBUILD INDEX.
  • If you specify TORBA when recovering a NOT LOGGED tablespace, specify a recoverable point.
  • TORBA is a statement level operand that can be applied to every object (DATABASE, TABLESPACE, and INDEXSPACE) in the RECOVER statement.
This keyword has the following format:
TORBA {X'
byte-string
'|LAST-RBA|LAST-QUIESCE}
  • X'
    byte
    -
    string
    '
    Specifies the log RBA to use. Enter this value as a hexadecimal number preceded by an X and enclosed in single quotes ('). If the RBA of a log record is
    byte-string
    or greater, that record is not used in the recovery.
  • LAST-RBA
    Recovers to the last copy or quiesce point. SYSIBM.SYSCOPY is scanned to determine the correct RBA. If the most recent image copy before the specified point is not available, fallback logic takes place. Fallback logic finds the prior image copy and applies log records until the specified point is reached. If a valid image copy is not found, log records defining the object are applied until the specified point has been reached.
    You can enter the LAST-RBA value only when a single database object is specified for the RECOVER statement. To specify LAST-RBA value for multiple objects (when a common copy or quiesce point was previously established), specify MULTI-OBJECT-TORBA(YES) in
    hlq
    .CDBAPARM(PFR). You must guarantee that all objects in the RECOVER statement have a common copy or quiesce point. 
  • LAST-QUIESCE
    Recovers to the last quiesce point. SYSIBM.SYSCOPY is scanned to determine the correct RBA. If no quiesce point is found, the RBA of the most recent image copy is used to determine the correct RBA. If the most recent image copy before the specified point is not available, fallback logic takes place. Fallback logic finds the prior image copy and applies log records until the specified point is reached. If a valid image copy is not found, log records defining the object are applied until the specified point has been reached.
Example: Recover Multiple Tablespaces to the Same RBA
To recover multiple tablespaces to RBA x'040488888888', specify either of the following syntax:
RECOVER TABLESPACE
dbname1
.
tsname1
TABLESPACE
dbname2
.
tsname2
TABLESPACE
dbname3
.
tsname3
TORBA x'040488888888' RECOVER TABLESPACE
dbname1
.
tsname1
TORBA x'040488888888' TABLESPACE
dbname2
.
tsname2
TABLESPACE
dbname3
.
tsname3
Example: Recover Multiple Indexspaces to the Same RBA
To recover multiple indexspaces to RBA x'090988888888', specify either of the following syntax:
RECOVER INDEXSPACE
dbname1
.
ixspname1
INDEXSPACE
dbname2
.
ixspname2
INDEXSPACE
dbname3
.
ixspname3
TORBA x'090988888888' RECOVER INDEXSPACE
dbname1
.
ixspname1
TORBA x'090988888888' INDEXSPACE
dbname2
.
ixspname2
INDEXSPACE
dbname3
.
ixspname3
Example: Recover Various Objects to the Same RBA
To recover multiple tablespaces and all tablespaces in a database (dbname4) to RBA x'040488888888', specify the following syntax.
You cannot include INDEXSPACE in the same statement as TABLESPACE or DATABASE.
RECOVER TABLESPACE
dbname1
.
tsname1
TABLESPACE
dbname2
.
tsname2
TABLESPACE
dbname3
.
tsname3
DATABASE
dbname4
TORBA x'040488888888'