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

發布時間：2021-11-09 10:57:01 來源：億速云閱讀：160 作者：小新欄目：關系型數據庫

這篇文章將為大家詳細講解有關kingsql中如何使用BBED修改Oracle數據文件頭推進SCN，小編覺得挺實用的，因此分享給大家做個參考，希望大家閱讀完這篇文章后可以有所收獲。

請看報大錯：

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