Focus On Oracle

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

Oracle Engineered System


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

aodu(At Oracle Database Utility)之rdba

rdba即为relative data block address,是指文件的相当地址。有4个字节表示,其中前10个bit表示相对文件编号,所以文件的最大编号为1024;后面22bit表示块的编号,所以块的最大编号为4194304,以默认8k的块计算,最大的文件为32G,以32k的块计算,最大的文件为128G。bigfile表空间只要一个数据文件,他的相对文件编号为1024,这个值是固定的,32bit全部表示块的编号,所以bigfile 8k的块,数据文件最大大小为32T,32k的块,数据文件最大大小为128T。


AODU> rdba 0x004062ff

        rdba   : 0x004062ff=4219647 (dba=1,25343)
        rfile# : 1
        block# : 25343
        Dump Block : alter system dump datafile 1 block 25343;
AODU>



SQL> create bigfile tablespace big datafile '/oradata/cdb1/big.dbf' size 20m;

Tablespace created.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oradata/cdb1/system01.dbf
/oradata/cdb1/sysaux01.dbf
/oradata/cdb1/undotbs01.dbf
/oradata/cdb1/pdbseed/system01.dbf
/oradata/cdb1/users01.dbf
/oradata/cdb1/pdbseed/sysaux01.dbf
/oradata/cdb1/pdb11/system01.dbf
/oradata/cdb1/pdb11/sysaux01.dbf
/oradata/cdb1/pdb11/pdb11_users01.dbf
/oradata/cdb1/pdb12/system01.dbf
/oradata/cdb1/pdb12/sysaux01.dbf


NAME
--------------------------------------------------------------------------------
/oradata/cdb1/pdb12/pdb12_users01.dbf
/oradata/cdb1/big.dbf
13 rows selected.
SQL> oradebug setmypid
Statement processed.
SQL> alter system dump datafile '/oradata/cdb1/big.dbf' block min 1 block max 20;

System altered.

SQL> oradebug tracefile_name
/u01/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_ora_3054.trc
SQL> 


bigfile表空间编辑编号为固定值1024,4个字节全部表示块的编号


buffer tsn: 6 rdba: 0x00000002 (1024/2)
scn: 0x0.0 seq: 0x01 flg: 0x05 tail: 0x00000001
frmt: 0x02 chkval: 0xa702 type: 0x00=unknown
Encrypted block <6, 3> content will not be dumped. Dumping header only.
buffer tsn: 6 rdba: 0x00000003 (1024/3)
scn: 0x0.0 seq: 0x01 flg: 0x05 tail: 0x00000001
frmt: 0x02 chkval: 0xa703 type: 0x00=unknown
Encrypted block <6, 4> content will not be dumped. Dumping header only.
buffer tsn: 6 rdba: 0x00000004 (1024/4)
scn: 0x0.0 seq: 0x01 flg: 0x05 tail: 0x00000001
frmt: 0x02 chkval: 0xa704 type: 0x00=unknown
Encrypted block <6, 5> content will not be dumped. Dumping header only.
buffer tsn: 6 rdba: 0x00000005 (1024/5)
scn: 0x0.0 seq: 0x01 flg: 0x05 tail: 0x00000001
frmt: 0x02 chkval: 0xa705 type: 0x00=unknown
Encrypted block <6, 6> content will not be dumped. Dumping header only.
buffer tsn: 6 rdba: 0x00000006 (1024/6)



关键词: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
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com