When a system or a large number of objects are interrupted, it may become a strain on Business Continuity Manager and managed system resources. To allow adequate time to analyze and correct any issues on the Teradata systems, temporarily disable automatic recovery. When the issues are resolved, re-enable automatic recovery.
- At bcmadmin, run the following command:
CONFIG LIST KEY RECOVERYINTERVAL;
Business Continuity Manager returns the sequencer system information, including the default recovery interval of 300 seconds and a custom recovery interval if applicable. For example:Sequencer System Defaults ------------------------- RecoveryInterval: 300 Sequencer User Set Values ------------------------- RecoveryInterval: 600
In this example, Business Continuity Manager is using a custom recovery interval of 600 seconds.
When you initiate recovery, Business Continuity Manager sets the custom recovery interval back to the default.
- If you are using a custom recovery interval, make a note of the value so you can reset the value after recovery.
- At bcmadmin, run the following command to disable automatic recovery:
CONFIG UPDATE SEQUENCER RecoveryInterval 0 REASON 'Disabled Automatic Recovery for incident _______';
- At bcmadmin, run the following command to confirm a recovery is not in progress:
SYSTEM RECOVERY STATUS;
- At bcmadmin, run the following command to make sure no objects on the system are being restored:
STATUS;
- At bcmadmin, run the following command to determine the cause of the mass interrupt event, then fix the errors:
SESSION LIST INTERRUPTED;
If you cannot fix the issues, contact Teradata Services for assistance before proceeding with the recovery. - At bcmadmin, run the following command to start recovery for the specified system:
SYSTEM RECOVER <systemId>; - At bcmadmin, run the following command periodically to check recovery status:
SYSTEM RECOVERY STATUS;
When recovery is complete, Business Continuity Manager returns the status recovery not in progress. - At bcmadmin, run the following command after recovery is complete to check for new interrupts:
SESSION LIST INTERRUPTED;
- Do one of the following:
Recovery Status Action No new interrupts - At bcmadmin, run one of the following commands to restore automatic recovery:
- If you are using a custom recovery interval:
CONFIG UPDATE SEQUENCER RECOVERYINTERVAL <recovery interval>;This restores automatic recovery to the custom recovery interval specified.
- If you are using the default recovery interval:
CONFIG RESET SEQUENCER SEQUENCER RECOVERYINTERVAL;
This restores automatic recovery to the default recovery interval of 300 seconds.
- If you are using a custom recovery interval:
New errors - Fix the issues, then repeat the recovery process.If you cannot fix the issues, contact Teradata Services for assistance before proceeding with another recovery attempt.
- At bcmadmin, run one of the following commands to restore automatic recovery: