ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DUMP locally managed temporary tablespace

DUMP locally managed temporary tablespace

原创 Linux操作系统 作者:admincy 时间:2019-06-04 20:45:05 0 删除 编辑
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 DUMP locally managed temporary tablespace

 

Note234724.1 How do I dump the datafile of locally managed temporary tablespace

 

alter system dump tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CHENY\TEMP01.DBF' block 1

 

dump 信息如下:

 

*** SERVICE NAME:(SYS$USERS) 2009-01-20 14:31:49.169

*** SESSION ID:(138.5) 2009-01-20 14:31:49.169

Memory Notification: Library Cache Object loaded into SGA

Heap size 2249K exceeds notification threshold (2048K)

LIBRARY OBJECT HANDLE: handle=6c853778 mutex=6C85382C(0)

name=XDB.XDbD/PLZ01TcHgNAgAIIegtw==

hash=e0f82b0c545a707da230a62675d34c80 timestamp=08-30-2005 14:28:09

namespace=XDBS flags=KGHP/TIM/SML/[02000000]

kkkk-dddd-llll=0000-0000-0000 lock=S pin=S latch#=2 hpc=0002 hlc=0002

lwt=6C8537D4[6C8537D4,6C8537D4] ltm=6C8537DC[6C8537DC,6C8537DC]

pwt=6C8537B8[6C8537B8,6C8537B8] ptm=6C8537C0[6C8537C0,6C8537C0]

ref=6C8537F4[6C8537F4,6C8537F4] lnd=6C853800[6C853800,6C853800]

  LIBRARY OBJECT: bject=6a1cc854

  type=XDBS flags=EXS/LOC[0005] pflags=[0000] status=VALD load=X

  DATA BLOCKS:

  data#     heap  pointer    status pins change whr alloc(K)  size(K)

  ----- -------- -------- --------- ---- ------ --- -------- --------

      0 6c9ce2ec 6a1cc910 I/P/A/-/-    0 NONE   00      0.34     0.00

      1 6a1cc94c 6a1538b4 I/P/A/-/-    1 NONE   00   2249.43  2269.51

 

 

 

不能使用alter system dump datafile ,否则会出现如下的错误:

 

 

alter system dump datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CHENY\TEMP01.DBF' block 1

ERROR at line 1:

   ORA-01205: not a data file - type number in header is 6

 

 

 

 

 

 

 

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30821/viewspace-541529/,如需转载,请注明出处,否则将追究法律责任。

上一篇: dump redo log
下一篇: dump 的几种方法
请登录后发表评论 登录
全部评论

注册时间:2018-09-17

  • 博文量
    18
  • 访问量
    13571