aodu(At Oracle Database Utility)之odlog

odlog是Oracle Database Log的缩写，主要用于查看redo/archive日志信息，包括数据库名字，数据库的id，大小，SCN信息和时间信息，还能验证文件的完整性，目前支持小端(Windows,Linux)的日志文件，数据库版本支持10g，11g，12c。其实控制文件，数据文件，tempfile，日志文件中都有数据库的名字和id信息，也只有这样才能保证所有我文件来自同一数据库。

用法为：odlog <文件名字>

12c Redo/Archive log信息

[oracle@db1 ~]$ ./aodu

AODU> odlog /oradata/cdb2/redo01.log

        Filename: /oradata/cdb2/redo01.log
        Blocksize: 512
        Blocks: 102400
        File Size: 52428800
        DBid: 661380815
        DBname: CDB2
        Thread#: 0001
        Seq#: 0000000004
        Scn Start#: 0x0000001870b8 = 1601720
        Scn  Stop#: 0xffffffffffff = -1
        Start Time: 2016-06-12 13:37:53
        Stop  Time: 1988-01-01 00:00:00
        Scn Changes: 281474975108935
        Archived/redo file is OK!
AODU> odlog /oradata/cdb2/redo02.log

        Filename: /oradata/cdb2/redo02.log
        Blocksize: 512
        Blocks: 102400
        File Size: 52428800
        DBid: 661380815
        DBname: CDB2
        Thread#: 0001
        Seq#: 0000000002
        Scn Start#: 0x0000001854fe = 1594622
        Scn  Stop#: 0x0000001855e5 = 1594853
        Start Time: 2016-06-12 13:36:25
        Stop  Time: 2016-06-12 13:36:32
        Scn Changes: 231
        Archived/redo file is OK!
AODU> odlog /oradata/cdb2/redo03.log

        Filename: /oradata/cdb2/redo03.log
        Blocksize: 512
        Blocks: 102400
        File Size: 52428800
        DBid: 661380815
        DBname: CDB2
        Thread#: 0001
        Seq#: 0000000003
        Scn Start#: 0x0000001855e5 = 1594853
        Scn  Stop#: 0x0000001870b8 = 1601720
        Start Time: 2016-06-12 13:36:32
        Stop  Time: 2016-06-12 13:37:53
        Scn Changes: 6867
        Archived/redo file is OK!
AODU> odlog /oradata/arch/1_7_914333775.dbf

        Filename: /oradata/arch/1_7_914333775.dbf
        Blocksize: 512
        Blocks: 36
        File Size: 18432
        DBid: 661380815
        DBname: CDB2
        Thread#: 0001
        Seq#: 0000000007
        Scn Start#: 0x00000022b291 = 2273937
        Scn  Stop#: 0x00000022b2a9 = 2273961
        Start Time: 2016-06-12 14:54:39
        Stop  Time: 2016-06-12 14:55:03
        Scn Changes: 24
        Archived/redo file is OK!
AODU>

AODU> odlog /oradata/upgr/redo01.log

        Filename: /oradata/upgr/redo01.log
        Blocksize: 512
        Blocks: 102400
        File Size: 52428800
        DBid: 42941116
        DBname: UPGR
        Thread#: 0001
        Seq#: 0000000010
        Scn Start#: 0x000000106888 = 1075336
        Scn  Stop#: 0x00000022a377 = 2270071
        Start Time: 2016-06-12 11:41:39
        Stop  Time: 2016-06-12 14:59:19
        Scn Changes: 1194735
        Archived/redo file is OK!
AODU> odlog /oradata/upgr/redo02.log

        Filename: /oradata/upgr/redo02.log
        Blocksize: 512
        Blocks: 102400
        File Size: 52428800
        DBid: 42941116
        DBname: UPGR
        Thread#: 0001
        Seq#: 0000000011
        Scn Start#: 0x00000022a377 = 2270071
        Scn  Stop#: 0x00000022a388 = 2270088
        Start Time: 2016-06-12 14:59:19
        Stop  Time: 2016-06-12 14:59:53
        Scn Changes: 17
        Archived/redo file is OK!
AODU> odlog /oradata/upgr/redo03.log

        Filename: /oradata/upgr/redo03.log
        Blocksize: 512
        Blocks: 102400
        File Size: 52428800
        DBid: 42941116
        DBname: UPGR
        Thread#: 0001
        Seq#: 0000000012
        Scn Start#: 0x00000022a388 = 2270088
        Scn  Stop#: 0xffffffffffff = -1
        Start Time: 2016-06-12 14:59:53
        Stop  Time: 1988-01-01 00:00:00
        Scn Changes: 281474974440567
        Archived/redo file is OK!
AODU> odlog /oradata/upgr/arch/1_10_906113981.dbf

        Filename: /oradata/upgr/arch/1_10_906113981.dbf
        Blocksize: 512
        Blocks: 41239
        File Size: 21114368
        DBid: 42941116
        DBname: UPGR
        Thread#: 0001
        Seq#: 0000000010
        Scn Start#: 0x000000106888 = 1075336
        Scn  Stop#: 0x00000022a377 = 2270071
        Start Time: 2016-06-12 11:41:39
        Stop  Time: 2016-06-12 14:59:19
        Scn Changes: 1194735
        Archived/redo file is OK!
AODU>