生成一个bat文件
sqlplus /nolog @archive.sql
exit
生成archive.sql文件
conn as sysdba;
spool D:\archivecheck\日志检查.txt
col name format a30;
set pagesize 100;
select to_char(sysdate, 'yy-mm-dd hh24:mi:ss') run_time from dual;
SELECT A.NAME, A.APPLIED, to_char(A.FIRST_TIME, 'yy-mm-dd hh24:mi:ss') time
FROM V$ARCHIVED_LOG a
where a.APPLIED = 'NO';
spool off
exit
sqlplus /nolog @D:\archivech\count.sql
exit
conn sysdba;
column file_name2010 new_value fname2010
select 'D:\archivecheck\db_check_' || to_char(sysdate,'yyyy-mm-dd_hh24-mi-ss') || '_log.txt'
file_name2010 from dual;
spool &fname2010
select to_char(sysdate,'yyyy-mm-dd_hh24-mi-ss') time from dual;
select count(*) session_num from v$session;
select count(*) process_num from v$process;
spool off
exit
保存为bat文件
set st=%date:~0,10%_%time:~0,2%-%time:~3,2%-%time:~6,2%
pslist.exe -x oracle >d:/%st%.txt
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7633405/viewspace-626293/ ，如需转载，请注明出处，否则将追究法律责任。
