kingsql中如何使用BBED修改Oracle數據文件頭推進SCN

145次閱讀

沒有評論

共計 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