Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching

Oracle Engineered System


当前位置: 首页 » 技术文章 » AODU

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

AT Oracle Database Utility,Release 1.1.0 on Sun Jun 12 14:45:24 2016
Copyright (c) 2014, 2015, Robin.Han.  All rights reserved.
http://ohsdba.cn
E-Mail:375349564@qq.com
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>


11g Redo/Archive log信息
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>




关键词:aodu 

相关文章

aodu(At Oracle Database Utility)之optim
aodu(At Oracle Database Utility)之asm(二)
aodu(At Oracle Database Utility)之asm(一)
aodu(At Oracle Database Utility)之rac(二)
aodu(At Oracle Database Utility)之rac(一)
aodu(At Oracle Database Utility)之ora600
aodu(At Oracle Database Utility)之asmdisk
aodu(At Oracle Database Utility)之unwrap
aodu(At Oracle Database Utility)之rdba
aodu(At Oracle Database Utility)之drux
aodu(At Oracle Database Utility)之time
aodu(At Oracle Database Utility)之odlog
Top