kingsql中如何使用BBED修改Oracle数据文件头推进SCN

76次阅读

没有评论

共计 12409 个字符，预计需要花费 32 分钟才能阅读完成。

这篇文章将为大家详细讲解有关 kingsql 中如何使用 BBED 修改 Oracle 数据文件头推进 SCN，丸趣 TV 小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。

请看报大错：

SQL startup;

ORACLE instance started.

Total System Global Area 1603411968 bytes

Fixed Size 2228784 bytes

Variable Size 989859280 bytes

Database Buffers 603979776 bytes

Redo Buffers 7344128 bytes

Database mounted.

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: /u01/app/oracle/oradata/oggdb2/system01.dbf

SQL alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: /u01/app/oracle/oradata/oggdb2/system01.dbf

现在开始修复数据吧！

SQL select name,checkpoint_change# from v$datafile;

NAME CHECKPOINT_CHANGE#

———————————————————— ——————

/u01/app/oracle/oradata/oggdb2/system01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/sysaux01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/undotbs01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/users01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/example01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/gguser.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/p2pdata01.dbf 2147548266

7 rows selected.

SQL select name,checkpoint_change# from v$datafile_header;

NAME CHECKPOINT_CHANGE#

———————————————————— ——————

/u01/app/oracle/oradata/oggdb2/system01.dbf 2147546874

/u01/app/oracle/oradata/oggdb2/sysaux01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/undotbs01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/users01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/example01.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/gguser.dbf 2147548266

/u01/app/oracle/oradata/oggdb2/p2pdata01.dbf 2147548266

修复过程：

1. 修改旧数据文件头 scn 的值

BBED dump offset 484

File: /u01/app/oracle/oradata/oggdb2/system01.dbf (1)

Block: 1 Offsets: 484 to 983 Dba:0x00400001

————————————————————————

8e4a0180 00000000 243e333b 01000000 94000000 02000000 10000000 02000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

0d000d00 0d000100 00000000 00000000 00000000 02004000 32270f00 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 02ace702 c1770dd9 007b503c cfdee590 34000000

00000000 00000000 00000000 00012997 2a000000 38020000 00000000 c08c5ef2

05fe25a5 9d6b999e 14265f03 1ef30600 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

BBED m /x 654f0180 offset 484

File: /u01/app/oracle/oradata/oggdb2/system01.dbf (1)

Block: 1 Offsets: 484 to 983 Dba:0x00400001

————————————————————————

654f0180 00000000 243e333b 01000000 94000000 02000000 10000000 02000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

0d000d00 0d000100 00000000 00000000 00000000 02004000 32270f00 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 02ace702 c1770dd9 007b503c cfdee590 34000000

00000000 00000000 00000000 00012997 2a000000 38020000 00000000 c08c5ef2

05fe25a5 9d6b999e 14265f03 1ef30600 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

2. 查看并修正数据文件头 chckpoint_time 的值

本文固定链接
http://blog.itpub.net/28389881/viewspace-2221607/

BBED dump offset 492

File: /u01/app/oracle/oradata/oggdb2/system01.dbf (1)

Block: 1 Offsets: 492 to 991 Dba:0x00400001

————————————————————————

243e333b 01000000 94000000 02000000 10000000 02000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 0d000d00 0d000100

00000000 00000000 00000000 02004000 32270f00 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 02ace702 c1770dd9 007b503c cfdee590 34000000 00000000 00000000

00000000 00012997 2a000000 38020000 00000000 c08c5ef2 05fe25a5 9d6b999e

14265f03 1ef30600 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

BBED m /x be42333b offset 492

File: /u01/app/oracle/oradata/oggdb2/system01.dbf (1)

Block: 1 Offsets: 492 to 991 Dba:0x00400001

————————————————————————

be42333b 01000000 94000000 02000000 10000000 02000000 00000000 00000000