DBA168

ORA-00600: internal error code, arguments: [4000], [10], [], [], [], [], [], []
Current SQL statement for this session:
select ctime, mtime, stime from obj$ where obj# = :1
—– Call Stack Trace —–
calling call entry argument values in hex
locati[......]

继续阅读

—-相关据细节结构可以多参考dsi 401

BBED> map /v block 32
File: /u01/test/block_test.dbf (10)
Block: 32 Dba:0×02800020
————————————————————
KT[......]

继续阅读

EVENT PROGRAM SESS_SQL_HASH USERNAME CLIENT LOGON_TIME
————————– ———————————– ——̵[......]

继续阅读

java.sql.SQLException: ORA-01115: IO error reading block from file 56 (block # 21192) ORA-01110: data file 56: ‘/dev/ra_gdbh02′ ORA-27091: skgfqio: unable to queue I/O ORA-27072: skgfdisp: I/O error IBM AIX RISC System/6000 Error: 5: I/O error
error reading block from file 56 (block # 21[......]

继续阅读

ora-27047

360032.1

BBED> set block 0
BLOCK# 0

BBED> dump /v
File: /oracle/oradata/gg.dbf (11)
Block: 0 Offsets: 0 to 511 Dba:0x02c00000
——————————————————-
[......]

继续阅读

SQL> create table xh.t1 (a int) tablespace ggate;

Table created.

SQL> insert into xh.t1 values (1);

1 row created.

SQL> SQL> commit;

Commit complete.

SQL> select a ,file#, block# from (select dbms_rowid.rowid_relative_fno(rowid) file#
2 ,dbms_rowid.rowid_block_number(rowid) bloc[......]

继续阅读

SQL> alter database datafile 11 online;
alter database datafile 11 online
*
ERROR at line 1:
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: ‘/oracle/oradata/gg.dbf’
ORA-01200: actual file size of 15 is smaller than correct size of 64000 blocks

file head[......]

继续阅读

SQL> create table asd (a int not null);
create table asd (a int not null)
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 49, file 1, block 27167 (2)

自己生成一个trace文件

*** 2012-02-26 17:32:32.574
*** SERVICE NAME:(SYS$USERS) 2012-02-26 17:3[......]

继续阅读

recovering deleted/damaged data

copy的最简单用法

SQL> conn xh/a123
Connected.

SQL> create table tr (a int) tablespace users;

Table created.

SQL> insert into tr values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from tr;

A
———-
1

SQL>[......]

继续阅读

一些基本测试

测试,头尾,校验失败问题
************* !!! For Oracle Internal Use only !!! ***************

BBED> show all
FILE# 10
BLOCK# 1
OFFSET 0
DBA 0×02800001 (41943041 10,1)
FILENAME /u01/test/block_test.dbf
BIF[......]

继续阅读