skills.rest
oceanbase
oceanbaseOFFICIAL
Explore all skills by this author →
Website𝕏@OceanBaseDBGitHub

backup-archive-restore-troubleshooting

Diagnose OceanBase backup, archive, and restore failures with structured phases.

161|40|Updated Nov 22, 2022
Search Tags:#troubleshooting#restore#backup#checkpoint#archive#oceanbase#storage-permission
One-click install
npx skills add https://github.com/oceanbase/obdiag --skill backup-archive-restore-troubleshooting
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backup-archive-restore-troubleshooting
Source: https://github.com/oceanbase/obdiag/tree/main/plugins/agent/skills/backup-archive-restore-troubleshooting
Command: npx skills add https://github.com/oceanbase/obdiag --skill backup-archive-restore-troubleshooting

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps identify and resolve issues encountered during backup, archiving, and physical or logical restoration in OceanBase environments. It guides through checkpoints like NFS permissions, object storage access, and restore windows to minimize downtime.

Core Features & Use Cases

  • Structured, multi-phase troubleshooting for backup/archiving/restore failures across LS leaders, object storage, and restore sources.
  • Phase-based guidance for common failures: archiving checkpoint stalls, object storage permissions, physical restore 4018, and restore-source validation.
  • Use Case: When a cluster fails to archive logs due to NFS permission errors, apply this SOP to diagnose and implement fixes without impacting production.

Quick Start

Follow the SOP phases to identify the failing stage and implement the recommended fixes.

Frequently Asked Questions about backup-archive-restore-troubleshooting

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot OceanBase backup and restore failures?▼

To troubleshoot OceanBase backup and restore failures, apply structured, phase-based guidance to identify the failing stage across LS leaders, object storage, and restore sources, then implement defined remediation steps to minimize downtime.

Why does my OceanBase cluster fail to archive logs due to NFS permission errors?▼

OceanBase log archiving fails with NFS permission errors when storage checkpoints stall; applying this troubleshooting SOP helps diagnose and implement fixes for NFS paths and permissions without impacting production.

What is the best way to validate restore sources in OceanBase physical restore 4018?▼

Validating restore sources in OceanBase physical restore 4018 involves following phase-based guidance to check ob_admin read points and confirm restore source availability across clusters and tenants.

Does this OceanBase backup troubleshooting process support object storage like OSS and COS?▼

Yes, the OceanBase backup troubleshooting process supports diagnosing object storage access and permissions for OSS and COS paths, applying structured remediation steps to resolve storage-related failures.

How do I resolve archiving checkpoint stalls in OceanBase environments?▼

Resolving archiving checkpoint stalls in OceanBase environments requires applying phase-based troubleshooting to diagnose LS leader issues and validate archival checkpoints, implementing defined remediation actions to restore archiving operations.

Related Skills

Explore More Data & Analytics Skills→
partme-aipartme-ai
610

cloud-tencent-cos

Manage Tencent Cloud COS buckets, objects, and access control.

Official
Intermediate
buiminhduc23011buiminhduc23011

awf-rollback

Diagnose deployment failures and restore code to a stable state.

Community
Intermediate
stayconnectquickstayconnectquick

canary

Monitor live applications for console errors, performance regressions, and page failures.

Community
Advanced
Percona-LabPercona-Lab
1

pbm-recipes

Back up and restore MongoDB clusters with Percona Backup for MongoDB.

Official
Advanced