惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
L
LINUX DO - 最新话题
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
Forbes - Security
Forbes - Security
博客园 - 司徒正美
Hugging Face - Blog
Hugging Face - Blog
W
WeLiveSecurity
Jina AI
Jina AI
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
N
News and Events Feed by Topic
V
V2EX
Stack Overflow Blog
Stack Overflow Blog
Engineering at Meta
Engineering at Meta
PCI Perspectives
PCI Perspectives
Martin Fowler
Martin Fowler
T
The Exploit Database - CXSecurity.com
F
Full Disclosure
WordPress大学
WordPress大学
S
Security Affairs
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
S
SegmentFault 最新的问题
P
Privacy International News Feed
IT之家
IT之家
M
MIT News - Artificial intelligence
G
GRAHAM CLULEY
Hacker News: Ask HN
Hacker News: Ask HN
D
DataBreaches.Net
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
Google Online Security Blog
Google Online Security Blog
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
C
Check Point Blog
美团技术团队
Security Latest
Security Latest
Cyberwarzone
Cyberwarzone
N
News and Events Feed by Topic
MyScale Blog
MyScale Blog
H
Help Net Security
宝玉的分享
宝玉的分享
The Hacker News
The Hacker News
The Last Watchdog
The Last Watchdog
The Cloudflare Blog
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
爱范儿
爱范儿
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
I
Intezer
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
AI
AI
I
InfoQ
N
News | PayPal Newsroom
TaoSecurity Blog
TaoSecurity Blog

博客园 - 惜分飞

使用deepseek进行Oracle恢复,引起重大故障---惜分飞 硬件故障后数据文件大小不对故障处理—Oracle碎片扫描恢复 1.5T MySQL数据库完美恢复---惜分飞 asm dd 10M导致system文件部分坏块修复---惜分飞 一次断电引起的Oracle故障恢复-ora-600 2662故障---惜分飞 Oracle故障第一现场被恢复混乱的数据库恢复--惜分飞 OraScan (Oracle碎片扫描工具)使用说明 imp导入dmp报IMP-00098: INTERNAL ERROR: impgst2故障处理 记录一次win删除数据文件完美恢复案例 国产信创库fio破坏主备库以及备份故障处理--惜分飞 .wman扩展名勒索mysql数据库恢复 Oracle数据库被勒索加密一键open工具–OraFHR rose双机引起文件系统损坏导致数据库异常故障处理---惜分飞 ORA-704 ORA-604 ORA-1578故障处理 csc(0x0006.d75a14f4) higher than block scn(0x0000.00000000)--故障处理--obet ORA-600 kcratr_nab_less_than_odr和ORA-600 4193故障处理---惜分飞 aix环境10g由于控制器异常导致ORA-600 4000故障处理---惜分飞 不当恢复truncate数据导致数据库不能open处理 在生产环境错误执行dd命令破坏asm磁盘故障恢复---惜分飞 Patch_SCN快速解决ORA-600 2663故障 obet实现对数据文件坏块检测功能(obet dbv) sql server 事务日志备份异常恢复案例---惜分飞 linux异常磁盘lvm恢复---惜分飞 win平台挂起Oracle数据库启动进程 expdp dmp 导出不完整导入ORA-39059 ORA-39246 故障抢救数据 mysql drop database 无有效备份恢复思路 mysql drop database 无法备份恢复思路
obet快速修改scn/resetlogs恢复数据库(缺少归档,ORA-00308)
惜分飞 · 2026-01-09 · via 博客园 - 惜分飞

然后相关人员上来进行了一系列操作,包括但不限于offline文件,create datafile 44,recover datafile,还尝试做resetlogs,使用备份控制文件还原等等.我接手该故障的时候状态
resetlog
44号文件状态是12月1日的,而且resetlogs信息也不对.通过和客户沟通,确认是他们在没有备份44号文件的前提下直接执行了类似alter database create datafile 44的命令,但是在应用了写归档之后,发现提示有归档不存在

基于这种情况(故障数据文件直接被覆盖,归档又出现了多天的连续断档,而且没有有效备份),只能先打开数据库,然后根据情况导出数据,然后导入到新库中.这里我直接使用obet来修改resetlogs和checkpoint 信息,实现数据库快速打开

OBET> help

OBET (Oracle Block Editor Tool) commands:

  open <config_file>    - Load file list from config file (format: <num> <path>)

  info                  - Show loaded file list (from open command)

  set filename <path>   - Set target file path (required)

  set file <num>        - Set filename using loaded file number (from open list)

  set blocksize <size>  - Set block size (2048,4096,[8192],16384,32768)

  set block <num>       - Set block number (starts from 0, default: 1)

  set offset <offset>   - Set offset within block (< blocksize, default: 0)

  set count <bytes>     - Set number of bytes to read (default: 32)

  set mode edit/browse  - Enable edit/browse mode

  d/dump [options]      - Display data (options: block X, offset Y, count N)

  m/modify <hex> [opts] - Modify data with hex (opts: block X, offset Y)

  undo                  - Undo last modification

  sum [block X]         - Calculate checksum for block (default: current block)

  sum apply [block X]   - Apply checksum: write calculated value to block

  tailchk [block X]     - Calculate tailchk for block (default: current block)

  tailchk apply [block X] - Apply tailchk: write calculated value to block

  repair [block X]      - Repair bad block (fix seq_kcbh, tailchk, checksum)

  copy data <src> to <dest>  - Copy data between files

    <src> format: file,block,offset,count (e.g., 1,1,10,64)

    <dest> format: file[,block][,offset] (e.g., 3 or 3,1 or 3,1,128)

  copy block file

  copy chkscn file n to file m         - Copy datafile header checkpoint SCN info

  copy resetlogscn file n to file m    - Copy datafile header resetlogs info

  backup [file n] [block m] - Backup data block (optional file and block parameters)

  corrupt [block X]     - Mark block as corrupted (default: current block)

  show                  - Display current settings (filename, blocksize, block, offset, count, mode)

  license               - Show/manage software license (registration code required)

  version               - Show software version and developer information

  p/print <param>       - Print Oracle structure,Use the 'p/print' command to see details

  undo                  - Undo the last copy chkscn or copy resetlogscn operation

  spool <file>          - Start logging to file (spool off to stop)

  help                  - Show this help message

  quit/exit             - Exit OBET

OBET> open 1.txt                

Loaded 2 files from config file '1.txt'.

OBET> info

Loaded files (2 total):

----------------------------------------

Number  Path

----------------------------------------

     /data/app/oracle/oradata/orcl/system01.dbf

    44  /data/app/oracle/oradata/orcl/xff26.dbf

----------------------------------------

OBET> set file 44

filename set to: /data/app/oracle/oradata/orcl/xff26.dbf (file

OBET> d

File: /data/app/oracle/oradata/orcl/xff26.dbf

Block: 1                Offsets:     0 to    31

--------------------------------------------------------------------------------

0xifenfei000 0BA20000 0100000B 00000000 00000104 B05F0000 00000000 0004200B 65583D61

<32 bytes read>

OBET> backup file 44 block 1

Created backup directory: backup_blk

Successfully backed up block 1 from file

OBET> copy resetlogscn file 1 to file 44

Error: Edit mode not enabled. Use 'set mode edit' first.

OBET> set mode edit    

mode set to: edit

OBET> copy resetlogscn file 1 to file 44

Confirm Modify resetlogscn:

Source: file

Target: file

Proceed? (Y/YES to confirm): y

Successfully copied resetlog SCN information from file

OBET> copy chkscn file 1 to file 44

Confirm Modify chkscn:

Source: file

Target: file

Proceed? (Y/YES to confirm): y

Successfully copied checkpoint SCN information from file

OBET> tailchk

Check tailchk for File /data/app/oracle/oradata/orcl/xff26.dbf, Block 1:

current = 0x010B0000, required = 0x010B0000

OBET> sum

Check value for File /data/app/oracle/oradata/orcl/xff26.dbf, Block 1:

current = 0xB05F, required = 0x6DA3

OBET> sum apply

Confirm applying checksum:

File: /data/app/oracle/oradata/orcl/xff26.dbf

Block: 1

Offset in block: 16 (file offset: 0x0xifenfei010)

Original value: 0xB05F

New value:      0x6DA3

Confirm? (Y/YES to proceed): y

Verification successful: Stored checksum matches calculated value (0x6DA3).

Checksum applied successfully.

后续根据情况选择导出表,对于导出报错的表再进行二次处理.