sqlplus -S "/ as sysdba" < output.out alter session set nls_date_format = 'DD-MON-YYYY-HH24-MI-SS' ; set termout off set pagesize 0 set heading off set trimspool on set echo off set feedback off spool ${db}_tmp01.lst select sysdate || ',' || instance_name || ':' || host_name from v\$instance ; spool off spool ${db}_tmp02.lst select controlfile_type || ':' || open_mode from v\$database ; spool off spool ${db}_tmp03.lst select max(sequence#) from v\$log_history ; spool off EOL