Archive for 8月 14th, 2005

dump数据库内部结构

Bright Posted on 2005-8-14 13:00 | Views(526) | Comments (0) | Category: Oracle | Tags: dump, oracle

1、分析数据文件块，转储数据文件n的块m
alter system dump datafile n block m
2、分析日志文件
alter system dump logfile logfilename;
3、分析控制文件的内容
alter session set events ‘immediate trace name CONTROLF level 10′
4、分析所有数据文件头
alter session set events ‘immediate trace name FILE_HDRS level 10′

Page 1 of 11

搜索本站

站点日历

订阅本站

订阅到Google Reader

订阅到鲜果

订阅到抓虾

订阅到有道

文章分类

English (4)
商务智能 (7)
存储 (1)
小米 (19)
操作系统 (15)
- Unix|Linux (12)
- Windows (3)
数据库 (96)
- MS SQL (21)
- Mysql (2)
- Oracle (73)
网络 (5)
随笔 (63)

最新日志

热点文章

expdp常见用法 (6,598)
IMP-00010: 不是有效的导出文件，标题验证失败 (5,351)
ORA-12500: TNS: 监听程序无法启动专用服务器进程 (4,093)
ORA-01102: cannot mount database in EXCLUSIVE mode (3,827)
一则ora-03113错误的解决 (3,789)
Checking monitor:must be configured to display at least 256 colors (3,497)
ORA-12545:Connect failed because target host or object does not exist (3,431)
CRS无法启动的解决过程 (3,015)
ORA-02019: connection description for remote database not found (2,682)
ORA-12535: TNS: 操作超时 (2,366)
【ZT】Oracle分布式事务故障处理 (2,281)
ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (2,257)
ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (2,209)
苏州圆融时代广场 (2,012)
WARNING: inbound connection timed out (ORA-3136) (2,008)
Oracle CRS log (1,998)
Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (1,989)
ORA-12528: TNS:listener: all appropriate instances are blocking new connections (1,954)
Oracle RAC升级问题记录 (1,741)
主键约束引起ORA-02429错误 (1,646)

日志存档

常用标签