31 lines
1021 B
SQL
31 lines
1021 B
SQL
-- EXPERIMENTAL! USE AT YOUR OWN RISK!
|
|
--
|
|
-- simple asm dump utility
|
|
-- use full database file name (with +datagroup name) as only parameter
|
|
-- nb! doesnt necessarily work properly on multidisk diskgroups with fine
|
|
-- grained striping. created for 2-disk diskgroup. doesnt probably work
|
|
-- ok on 2+ disk diskgroups.
|
|
--
|
|
-- tanel poder - nov 2005 [ http://www.tanelpoder.com ]
|
|
|
|
set lines 300 trim on verify off pages 50000
|
|
|
|
select
|
|
'dd if='|| d.path||' bs=131072 skip='||(AU_KFFXP*8)+(mod(stripefact.r,8)*131072)||' count=1 '||
|
|
'>> /tmp/'||substr('&1',instr('&1','/',-1)+1)||'.dmp' cmd
|
|
from
|
|
X$KFFXP X,
|
|
V$ASM_DISK D,
|
|
V$ASM_ALIAS A,
|
|
(select rownum-1 r from v$mystat where rownum <= 8) stripefact
|
|
where
|
|
lower(A.NAME) = lower(substr('&1',instr('&1','/',-1)+1))
|
|
and X.NUMBER_KFFXP = A.FILE_NUMBER
|
|
and X.GROUP_KFFXP = A.GROUP_NUMBER
|
|
and X.INCARN_KFFXP = A.FILE_INCARNATION
|
|
and X.DISK_KFFXP = D.DISK_NUMBER
|
|
and X.GROUP_KFFXP = D.GROUP_NUMBER
|
|
order by
|
|
X.XNUM_KFFXP;
|
|
|