This command initiates a process of partial rollforward recovery.
When SETUPRECOVERY
PARTIAL is used, a temporary DBEnvironment is created for the rollforward
recovery process.
Example of Partial Recovery |
 |
From the group and account containing the DBECon file and the
SYSTEM DBEFileSet, use the SQLUtil DETACHFILE command to detach
all DBEFiles that will be acted upon by the partial roll forward
recovery process.
Move to a new group in the same account, which does not contain any
DBECon file or SYSTEM DBEFileSet, to carry out the remainder of the
partial rollforward recovery process.
>> setuprecovery partial
DBEnvironment Name: tmpdbe
Maintenance Word: MaintenanceWord
Enter File to Restore or Carriage Return to Finish: OrderDF1.OtherGroup
Enter File to Restore or Carriage Return to Finish: OrderXF1.OtherGroup
Enter File to Restore or Carriage Return to Finish:
Setup Recovery (y/n): y
Recovery Has Been Setup.
Next Log Sequence Number is 2.
>> restorelog
DBEnvironment Name: tmpdbe
Maintenance Word: MaintenanceWord
Input Device: TAPE
Local (y/n) (opt): y
Rename ptslogA1 Log File To: lsn002
Restore the Log File (y/n)?y
Log File 'lsn002' was Restored.
>> recoverlog
DBEnvironment Name: tmpdbe
Maintenance Word: MaintenanceWord
Next Log File To Recover: lsn002
Recover Log File (y/n)?y
Log File Recovered.
Next Possible Log Sequence Number is 3.
|
Repeat the restorelog/recoverlog sequence until all log files have been
applied up to the time of the failure.
>> endrecovery
DBEnvironment Name: tmpdbe
Maintenance Word: MaintenanceWord
End Recovery (y/n)?y
Recovery Has Terminated.
|
Remove the log files that remain after the partial recovery process from
the group which contained the temporary DBEnvironment.
Return to the group which contains the original DBEnvironment
and use the SQLUtil ATTACHFILE command to attach all DBEFiles that
were detached prior to the partial rollforward recovery process.