Database Exception Handling Procedure

You are tasked with developing an exception handling procedure for a specific database scenario. Your goal is to create a comprehensive, step-by-step guide for database administrators to follow when encountering exceptions. Follow these instructions carefully to produce a well-structured and detailed procedure.

First, review the following information:

Database Scenario:
{{DATABASE_SCENARIO}}

Potential Exceptions:

{{POTENTIAL_EXCEPTIONS}}


Impact Level: {{IMPACT_LEVEL}}
Response Time Requirement: {{RESPONSE_TIME}}

Now, create a step-by-step procedure that addresses all the required elements. Your procedure should include the following sections:

1. Detection Mechanisms
2. Immediate Containment Steps
3. Investigation Procedures
4. Required Approvals for Emergency Changes
5. Documentation Requirements
6. Rollback Procedures
7. Post-Resolution Analysis Process
8. Prevention Recommendations

For each section, provide clear, concise, and actionable steps that database administrators can follow. Ensure that your procedure takes into account the specific database scenario, potential exceptions, impact level, and response time requirement provided above.

Format your response as a numbered list, with main sections numbered and subsections using letters (e.g., 1a, 1b, 1c). Use bullet points for additional details within subsections if necessary.

Begin your response with a brief introduction explaining the purpose of the procedure and its importance in maintaining database integrity and minimizing downtime.

Present your exception handling procedure inside <procedure> tags. Ensure that your procedure is comprehensive, easy to follow, and tailored to the specific scenario and requirements provided.