alter database backup controlfile to trace

mitian1106 · 发表于 2011-2-20 20:27

alter database backup controlfile to trace

如何定位在udump下那个trace文件.

ftc007 · 发表于 2011-2-20 20:57

你可以指定一个特定的文件名例如。。。to trace as '路径/文件名'

jasoname · 发表于 2011-2-20 21:02

你看时间。肯定是最新生成的文件啊

feil85 · 发表于 2011-2-20 22:02

SELECT a.VALUE
   || b.symbol
   || c.instance_name
   || '_ora_'
   || d.spid
   || '.trc' trace_file
  FROM (SELECT VALUE
      FROM v$parameter
      WHERE NAME = 'user_dump_dest') a,
   (SELECT SUBSTR (VALUE, -6, 1) symbol
      FROM v$parameter
      WHERE NAME = 'user_dump_dest') b,
   (SELECT instance_name
      FROM v$instance) c,
   (SELECT spid
      FROM v$session s, v$process p, v$mystat m
      WHERE s.paddr = p.addr AND s.SID = m.SID AND m.statistic# = 0) d
/

小比例尺 · 发表于 2011-2-20 23:21

ls -ltr udump

Ilovesports · 发表于 2011-2-21 08:47

2,4楼的回复都可以满足楼主的疑问!

mitian1106 · 发表于 2011-2-21 18:36

原帖由 feil85 于 2011-2-20 22:02 发表
SELECT a.VALUE
   || b.symbol
   || c.instance_name
   || '_ora_'
   || d.spid
   || '.trc' trace_file
  FROM (SELECT VALUE
      FROM v$parameter
      WHERE NAME = 'user_dump_dest') a,
   (SELECT SUBSTR (VALUE, -6, 1) symbol
      FROM v$parameter
      WHERE NAME = 'user_dump_dest') b,
   (SELECT instance_name
      FROM v$instance) c,
   (SELECT spid
      FROM v$session s, v$process p, v$mystat m
      WHERE s.paddr = p.addr AND s.SID = m.SID AND m.statistic# = 0) d
/

这个满足了我的好奇心

jasoname · 发表于 2011-2-21 20:18

不要好奇，我试了下还真是这样

[备份恢复] alter database backup controlfile to trace