zhh9126/backup-platform/oracle-backup

Claude Code and agent skill by zhh9126/backup-platform

Trust tier 2
  • community
LLM review pending
Source check pending

Checking that the SKILL.md file is still in the repository.

Oracle 数据库备份与恢复技能。支持逻辑备份(expdp/exp Data Pump)和物理备份(RMAN 全量+增量), 以及归档日志备份和 RMAN PITR 时间点恢复。当用户需要对 Oracle 进行备份恢复或归档日志管理时, 应使用此技能。信创核心库(adapter_tier=core_self)自研实现。

Install

npx vskill@latest install zhh9126/backup-platform/oracle-backup

SKILL.md

Oracle 备份技能

概述

此技能封装了 Oracle 数据库的完整备份与恢复能力,包括 Data Pump 逻辑导出和 RMAN 物理备份。

备份引擎: OracleEngine (adapter_tier: core_self)

支持的能力

能力说明
逻辑备份-服务端expdp (Data Pump),文件存 DATA_PUMP_DIR
逻辑备份-客户端exp,传统导出,文件存本地
物理全量备份RMAN BACKUP DATABASE
物理增量备份RMAN BACKUP INCREMENTAL LEVEL 0/1 DATABASE
归档日志备份archivelog_backup() — RMAN BACKUP ARCHIVELOG ALL DELETE INPUT
PITR 恢复rman_pitr(target_time) — RMAN SET UNTIL TIME + RESTORE + RECOVER + ALTER DATABASE OPEN RESETLOGS
逻辑增量exp INCTYPE=INCREMENTAL/CUMULATIVE

备份类型(BackupType)

  • FULL — expdp 全量导出
  • SNAPSHOT — expdp 一致性导出
  • INCREMENTAL — exp 增量(INCTYPE=INCREMENTAL)或 RMAN INCREMENTAL
  • DIFFERENTIAL — exp 累积(INCTYPE=CUMULATIVE)

备份模式(BackupMode)

  • LOGICAL — expdp / exp 导出
  • PHYSICAL — RMAN 备份

API 端点

方法端点说明
POST/tasks创建备份任务(db_type=oracle)
GET/tasks查询任务列表
POST/tasks/<id>/run执行任务
POST/restore执行恢复
GET/records?db_type=oracle查询备份记录
GET/plugins?category=oracle查看 Oracle 相关插件

插件依赖

  • oracle-rman-client — Oracle RMAN 客户端工具

使用示例

RMAN 物理全量备份
db_type=oracle, backup_mode=PHYSICAL, backup_type=FULL
expdp 逻辑导出

需要确保 Oracle 服务端 DATA_PUMP_DIR 可写,导出文件路径以 server-side: 前缀区分。

PITR 恢复流程
  1. 确保归档日志完备(先执行 archivelog_backup())
  2. 执行 rman_pitr('2024-01-15 10:30:00') 恢复到指定时间点
  3. 数据库以 RESETLOGS 模式打开
安全

密码明文写入连接串 user/pw@//host:port/service(Oracle 客户端惯例)。

Security

  • Security scanPassed, 100 of 100Pattern checks on the skill's files.
  • Model reviewNot runA model review is scheduled for the next rescan.

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

7-day trend score
0

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/zhh9126/backup-platform/oracle-backup/badge)](https://verified-skill.com/skills/zhh9126/backup-platform/oracle-backup)

Something wrong with this skill or its page? Tell us.