首页 > Linux操作系统 > Linux操作系统 > 当用EXP(带direct=y参数)导出一个带坏块的数据库时,不会报警!!!


原创 Linux操作系统 作者:lfree 时间:2006-01-09 00:00:00 0 删除 编辑

Exp导出可以检测physical corruption 和logical corruption
1. Export only reads:
- user data below the high water mark;
- parts of the data dictionary, while looking up information concerning
the objects being exported.

2. Only a Conventional path export is able to detect logical corrupt blocks.
When using a Direct path export , the data is read from disk directly
into the export session's program global area (PGA): the rows are
transferred directly to the Export session's private buffer. This means
that the SQL command-processing layer (evaluation buffer) is bypassed,
because the data is already in the format that Export expects.
Therefore, do not specify the export parameter DIRECT=Y but use DIRECT=N
which is also the default value for the DIRECT parameter.

3. Export does not detect all corruptions:
- does not detect disk corruptions above the high water mark;
- does not detect corruptions in indexes, or in free or temporary extents;
- does not detect all corruptions in the data dictionary (the export
utility does not read all of the data dictionary, so there could still
be undetected corruptions in the SYSTEM tablespace).



来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: dump命令
请登录后发表评论 登录
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。


  • 博文量
  • 访问量