Focus On Oracle

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

Oracle Engineered System


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

What Is AODU

关于AODU

AODU(At Oracle Database Utility),即Oracle数据库工具,也是为Lazy DBA开发的工具。她对Oracle的结构做了些解析,并增加了常用知识点的整合。能够使你对Oracle的认识更加清晰,也能够帮助你查看工作中遇到的难题。下面有目前已具备的功能。数据恢复功能,ASMCMD功能,从dmp文件抽取数据功能,BBED功能在完善中。


下载地址

http://ohsdba.cn/tools/aodu.zip,欢迎下载使用和反馈。


AODU目前具备的功能

1.对oracle数据库的结构做了一些解析

   scn,rdba,time,drux,time

2.对数据库redo/archived log头部信息的解析

   odlog

3.对数据库dmp文件的基本识别和解析

   dmpinfo

4.asm磁盘的识别

   asmdisk

5.oracle诊断工具oradebug的用法,ora600的基本查询

   oradebug,ora600

6.oracle数据库优化的脚本及诊断方法

   optim

7.oracle ASM,RAC的常用基本和诊断方法

   asm,rac

8.oracle unwrap加密的包,过程,函数

   unwrap

9.正在完善的功能

   bbed,asmcmd,dul,unpump

AODU> help

Available Commands:
      help      - Display this help
       dul      - oracle data unload,currently under developing
    unpump      - extract data from dmp files,currently under developing
    asmcmd      - asmcmd utility,currently under developing
      bbed      - bbed utility,currently under developing
      exit      - Exits
   asmdisk      - Check asm disks(e.g. asmdisk \\.\g:)
    unwrap      - Unwrap PL/SQL,e.g. unwrap prvtstat.plb prvtstat.sql
   dmpinfo      - Get dmpfile(exp/expdp) info,e.g. dmpinfo ohsdba.dmp
       asm      - ASM utility,internal use only
       rac      - RAC utility,internal use only
     optim      - Optimizer utility,internal use only
    ora600      - ORA-600 searching
  oradebug      - Oradebug utility,oradebug usage all
      host      - Enter OS terminal
     rowid      - Decode rowid,e.g. rowid AAAAECAABAAAAgiAAA
       scn      - Decode scn,e.g. scn 0x0000.00233d44
      rdba      - Convert RDBA into rfile# and block#,e.g. rdba 0x004062ff
      time      - Convert the number to checkpoint time,e.g. time 123456789
      drux      - Decode rba/xid/uba,e.g. drux rba 0x000024.000011bd.0010
     odlog      - Get archived/redo logfile info. odlog <filename>
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