thanks again, below is my scripts is not quite working 100%, can you tell me what happened to my scritps ???


SET ECHO ON
SET TERMOUT ON
SET STOPONERROR OFF

SPOOL C:\TEMP\INFO.LOG

CONNECT SYSTEM/MANAGER

ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS;

select 'HOST COPY C:\ORACLE\ORA817\ADMIN\mydata\UDUMP\ORA' || ltrim(to_char(p.spid,'09999')) || '.TRC C:\TEMP\CTRL_TO_TRACE.TXT'
from v$process p, v$session s
where p.addr = s.paddr
and s.sid = (select sid from v$mystat where rownum=1);

DISCONNECT;

exit;

SPOOL OFF;