[20170411]bbed計算redo檢查和.txt

[20170411]bbed計算redo檢查和.txt

--前一陣子做測試，需要一個電腦做異或的操作，連結http://blog.itpub.net/267265/viewspace-2134945/

--正好前幾天開會遇到熟人，談起我寫的腳本很實用。我說不支援管道操作不是很好，對方講支援，他自己就是這樣用的。

$ cat ~/bin/xor.sh

#! /bin/bash

# just play , calc xor!!

s='0'

for i in $(cat $1| tr 'a-f' 'A-F')

do

    #echo "obase=16;ibase=16; xor($s,$i)"

    echo $i

    [ $i != '0000' ] &&  s=$(echo "obase=16;ibase=16; xor($s,$i)" | bc -l ~/bc/logic.bc)

done

echo -e "\nxor result: $s \n"

--//我再仔細看才明白如果不存在$1,就通過輸入來接收數值。也就是執行執行輸入參數也可以。

$ xor.sh

5 7

5

7

xor result: 2

$ echo 5 7 | xor.sh

--//實際上bbed也可以，自己測試看看。

1.環境：

SCOTT@book> @ &r/ver1

PORT_STRING                    VERSION        BANNER

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

x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SCOTT@book> alter system dump logfile '/u01/app/oracle/archivelog/book/1_821_896605872.dbf' validate;

System altered.

DUMP OF REDO FROM FILE '/u01/app/oracle/archivelog/book/1_821_896605872.dbf'

Opcodes *.*

RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff

SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff

Times: creation thru eternity

VALIDATE ONLY

FILE HEADER:

    Compatibility Vsn = 186647552=0xb200400

    Db ID=1337401710=0x4fb7216e, Db Name='BOOK'

    Activation ID=1337448558=0x4fb7d86e

    Control Seq=39112=0x98c8, File size=102400=0x19000

    File Number=1, Blksiz=512, File Type=2 LOG

descrip:"Thread 0001, Seq# 0000000821, SCN 0x00031764db63-0x00031764fb91"

thread: 1 nab: 0x39cf seq: 0x00000335 hws: 0x2 eot: 0 dis: 0

resetlogs count: 0x35711eb0 scn: 0x0000.000e2006 (925702)

prev resetlogs count: 0x3121c97a scn: 0x0000.00000001 (1)

Low  scn: 0x0003.1764db63 (13277387619) 04/11/2017 08:13:52

Next scn: 0x0003.1764fb91 (13277395857) 04/11/2017 10:02:32

Enabled scn: 0x0000.000e2006 (925702) 11/24/2015 09:11:12

Thread closed scn: 0x0003.1764db63 (13277387619) 04/11/2017 08:13:52

Disk cksum: 0x46d3 Calc cksum: 0x46d3

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Terminal recovery stop scn: 0x0000.00000000

Terminal recovery  01/01/1988 00:00:00

Most recent redo scn: 0x0000.00000000

Largest LWN: 1930 blocks

End-of-redo stream : No

Unprotected mode

Miscellaneous flags: 0x800021

Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000

Zero blocks: 8

Format ID is 2

redo log key is ae927dbdcfa81f95689f9787f274818

redo log key flag is 5

Enabled redo threads: 1

END OF REDO DUMP

2.通過bbed觀察看看：

BBED> set filename '/u01/app/oracle/archivelog/book/1_821_896605872.dbf'

        FILENAME        /u01/app/oracle/archivelog/book/1_821_896605872.dbf

BBED> show all

        FILE#           0

        BLOCK#          1

        OFFSET          0

        DBA             0x00000000 (0 0,1)

        BIFILE          bifile.bbd

        LISTFILE        /home/oracle/bbed/filelist.txt

        BLOCKSIZE       512

        MODE            Edit

        EDIT            Unrecoverable

        IBASE           Dec

        OBASE           Dec

        WIDTH           160

        COUNT           64

        LOGFILE         log.bbd

        SPOOL           Yes

--//blocksize=512，設定也正常。

BBED> set block 1

BBED> sum

Check value for File 0, Block 1:

current = 0x0000, required = 0x0000

--//很明顯不适合block=1的計算，因為線上日志(或者歸檔日志)的檔案頭檢查和位于偏移14，15位元組。

BBED> dump

File: /u01/app/oracle/archivelog/book/1_821_896605872.dbf (0)

Block: 1                                                    Offsets:    0 to   63                                               Dba:0x00000000

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

01220000 01000000 35030000 0080d346 00000000 0004200b 6e21b74f 424f4f4b 00000000 c8980000 00900100 00020000 01000200 6ed8b74f 00000000 00000000

<64 bytes per line>

--//偏移14，15 = d346 ,颠倒過來就是46d3.

BBED> set block 2

        BLOCK#          2

Check value for File 0, Block 2:

current = 0x0060, required = 0x0060

Block: 2                                                    Offsets:    0 to   63                                               Dba:0x00000000

01220000 02000000 35030000 1080431a 60000000 04020300 63db6417 01000000 8402ac58 c26f5917 00000100 01000000 01000000 0a000000 63db6417 03005917

--//第2塊就OK了。

--//另外bbed許多指令無效的，因為結構對不上，oracle當作資料塊讀取。僅僅dump之類的指令有效。

--//換一句話如果拿bbed來算，需要将偏移14，15位元組清0，在計算看看呢？

$ bvi -s 512 -b 512 1_821_896605872.dbf

--//将偏移14，15位元組清0.

$ dd if=1_821_896605872.dbf count=1 bs=512 skip=1 2>/dev/null | xxd -c 16 | cut -c10-50 | xor.sh

...

0000

xor result: D346

--//但是很奇怪bbed計算還是0，不知道為什麼？

01220000 01000000 35030000 00800000 00000000 0004200b 6e21b74f 424f4f4b 00000000 c8980000 00900100 00020000 01000200 6ed8b74f 00000000 00000000

--//oracle真奇怪，不知道問題在那裡????修改回來。

3.在修改Miscellaneous flags: 0x800021看看：

Miscellaneous flags: 0x800021 => 0x800000.

--//使用bvi修改

current = 0x0000, required = 0x0021

--//這次計算又對了。當然這個不是檢查和。

$ echo d346 2100 0000 | xor.sh

D346

2100

xor result: F246

--//修改偏移14，15=F246.

--//驗證

Disk cksum: 0x46f2 Calc cksum: 0x46f2

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Miscellaneous flags: 0x800000

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--//這樣oracle認為是線上日志，不是歸檔檔案，無法删除檔案，僅僅能從控制檔案剔除。

RMAN> delete archivelog sequence 821 ;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=112 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=123 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=134 device type=DISK

List of Archived Log Copies for database with db_unique_name BOOK

=====================================================================

Key     Thrd Seq     S Low Time

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

1487    1    821     A 2017-04-11 08:13:52

        Name: /u01/app/oracle/archivelog/book/1_821_896605872.dbf

Do you really want to delete the above objects (enter YES or NO)? yes

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-03009: failure of delete command on ORA_DISK_1 channel at 04/11/2017 10:53:59

ORA-19656: cannot backup, copy, or delete online log /u01/app/oracle/archivelog/book/1_821_896605872.dbf

RMAN> delete force archivelog sequence 821  ;

released channel: ORA_DISK_1

released channel: ORA_DISK_2

released channel: ORA_DISK_3

deleted archived log

archived log file name=/u01/app/oracle/archivelog/book/1_821_896605872.dbf RECID=1487 STAMP=941018552

Deleted 1 objects

$ ls -l /u01/app/oracle/archivelog/book/1_821_896605872.dbf

-rw-r----- 1 oracle oinstall 7577088 2017-04-11 10:50:41 /u01/app/oracle/archivelog/book/1_821_896605872.dbf

--//僅僅重複了連結http://blog.itpub.net/267265/viewspace-2135379/的測試。

--//oracle可能出于安全的考慮,實際上并沒有删除這個檔案.畢竟它認為這個檔案是線上日志檔案^_^.

--//感覺還是我的腳本簡單一些。塊1的檢查和計算還是存在問題。